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

how many friendly competitions occurred before september ?
SELECT COUNT(*) FROM table_203_442 WHERE "date" < 9 AND "competition" = 'friendly'
SELECT COUNT(*) FROM "table_203_442" WHERE "competition" = 'friendly' AND "date" < 9