CREATE TABLE table_204_469 (id NUMBER, "coach" CLOB, "years" CLOB, "seasons" NUMBER, "wins" NUMBER, "losses" NUMBER, "ties" NUMBER, "pct" NUMBER)

how many coaches had above 500 wins ?
SELECT COUNT("coach") FROM table_204_469 WHERE "wins" > 500
SELECT COUNT("coach") FROM "table_204_469" WHERE "wins" > 500