CREATE TABLE table_203_179 (id NUMBER, "goal" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "competition" CLOB)

how many competitions were something other than a friendly match ?
SELECT COUNT(*) FROM table_203_179 WHERE "competition" <> 'friendly match'
SELECT COUNT(*) FROM "table_203_179" WHERE "competition" <> 'friendly match'