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

how many different opponents were played after august 4 ?
SELECT COUNT(DISTINCT "opponent") FROM table_203_240 WHERE id > (SELECT id FROM table_203_240 WHERE "date" = 'august 4')
SELECT COUNT(DISTINCT "opponent") FROM "table_203_240" WHERE "id" > (SELECT "id" FROM "table_203_240" WHERE "date" = 'august 4')