CREATE TABLE table_204_689 (id NUMBER, "year" NUMBER, "title" CLOB, "album" CLOB, "uk" NUMBER, "b-sides" CLOB)

how many titles were in 2007 ?
SELECT COUNT("title") FROM table_204_689 WHERE "year" = 2007
SELECT COUNT("title") FROM "table_204_689" WHERE "year" = 2007