CREATE TABLE table_203_877 (id NUMBER, "year" NUMBER, "single" CLOB, "us cashbox" NUMBER, "us hot 100" NUMBER, "uk singles" NUMBER)

what are the total number of singles in 1974 ?
SELECT COUNT("single") FROM table_203_877 WHERE "year" = 1974
SELECT COUNT("single") FROM "table_203_877" WHERE "year" = 1974