how many times does friendly appear in the competition column ?
CREATE TABLE table_204_346 (
    id number,
    "#" number,
    "date" text,
    "venue" text,
    "opponent" text,
    "result" text,
    "competition" text,
    "scored" number
)
SELECT COUNT(*) FROM table_204_346 WHERE "competition" = 'friendly'
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 times does friendly appear in the competition column ? ### Input: CREATE TABLE table_204_346 (
    id number,
    "#" number,
    "date" text,
    "venue" text,
    "opponent" text,
    "result" text,
    "competition" text,
    "scored" number
) ### Response: SELECT COUNT(*) FROM table_204_346 WHERE "competition" = 'friendly'