how many albums were released under the emi record label ?
CREATE TABLE table_204_471 (
    id number,
    "year" number,
    "title" text,
    "peak chart positions\nger" number,
    "label" text,
    "artist" text
)
SELECT COUNT("title") FROM table_204_471 WHERE "label" = 'emi'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: how many albums were released under the emi record label ? ### Input: CREATE TABLE table_204_471 (
    id number,
    "year" number,
    "title" text,
    "peak chart positions\nger" number,
    "label" text,
    "artist" text
) ### Response: SELECT COUNT("title") FROM table_204_471 WHERE "label" = 'emi'