CREATE TABLE table_204_56 (id NUMBER, "year" NUMBER, "song" CLOB, "us r&b" NUMBER, "us rap" NUMBER, "album" CLOB)

the number of singles by del the funky homosapien released before the year 2000
SELECT COUNT("song") FROM table_204_56 WHERE "year" < 2000
SELECT COUNT("song") FROM "table_204_56" WHERE "year" < 2000