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 did joni mitchell perform ?
SELECT COUNT("song") FROM table_204_697 WHERE "artist(s)" = 'joni mitchell'
SELECT COUNT("song") FROM "table_204_697" WHERE "artist(s)" = 'joni mitchell'