CREATE TABLE table_204_346 (id NUMBER, "#" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "result" CLOB, "competition" CLOB, "scored" NUMBER)

how many times does friendly appear in the competition column ?
SELECT COUNT(*) FROM table_204_346 WHERE "competition" = 'friendly'
SELECT COUNT(*) FROM "table_204_346" WHERE "competition" = 'friendly'