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

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