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

how many albums were released under the emi record label ?
SELECT COUNT("title") FROM table_204_471 WHERE "label" = 'emi'
SELECT COUNT("title") FROM "table_204_471" WHERE "label" = 'emi'