CREATE TABLE table_204_275 (id NUMBER, "date" CLOB, "city" CLOB, "opponent" CLOB, "results" CLOB, "scorers" CLOB, "type of game" CLOB)

how many friendly games have been played ?
SELECT COUNT(*) FROM table_204_275 WHERE "type of game" = 'friendly'
SELECT COUNT(*) FROM "table_204_275" WHERE "type of game" = 'friendly'