CREATE TABLE table_204_508 (id NUMBER, "no." NUMBER, "race title" CLOB, "track" CLOB, "date" CLOB, "tv" CLOB)

what are the number of times a race was held in august ?
SELECT COUNT(*) FROM table_204_508 WHERE "date" = 8
SELECT COUNT(*) FROM "table_204_508" WHERE "date" = 8