CREATE TABLE table_204_147 (id NUMBER, "#" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "win" CLOB, "loss" CLOB, "save" CLOB, "attendance" NUMBER, "record" CLOB)

how many games took place in july before the fourth of july ?
SELECT COUNT(*) FROM table_204_147 WHERE "date" = 7 AND "date" < 4
SELECT COUNT(*) FROM "table_204_147" WHERE FALSE