CREATE TABLE table_204_52 (id NUMBER, "#" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "competition" CLOB)

how many were friendly competitions ?
SELECT COUNT(DISTINCT "date") FROM table_204_52 WHERE "competition" = 'friendly'
SELECT COUNT(DISTINCT "date") FROM "table_204_52" WHERE "competition" = 'friendly'