CREATE TABLE table_204_471 (id NUMBER, "year" NUMBER, "title" CLOB, "peak chart positions\ ger" NUMBER, "label" CLOB, "artist" CLOB)

how many compilation albums did they release in 1997 ?
SELECT COUNT("title") FROM table_204_471 WHERE "year" = 1997
SELECT COUNT("title") FROM "table_204_471" WHERE "year" = 1997