CREATE TABLE table_204_146 (id NUMBER, "tie" NUMBER, "home team" CLOB, "score" CLOB, "away team" CLOB, "attendance" NUMBER)

how many games attendance was under 1000 ?
SELECT COUNT(*) FROM table_204_146 WHERE "attendance" < 1000
SELECT COUNT(*) FROM "table_204_146" WHERE "attendance" < 1000