CREATE TABLE table_204_697 (id NUMBER, "song" CLOB, "artist ( s ) " CLOB, "concert" NUMBER, "film" NUMBER, "1978 album" NUMBER, "2002 album" NUMBER)

how many songs in total ?
SELECT COUNT("song") FROM table_204_697
SELECT COUNT("song") FROM "table_204_697"