CREATE TABLE table_204_469 (id DECIMAL, "coach" TEXT, "years" TEXT, "seasons" DECIMAL, "wins" DECIMAL, "losses" DECIMAL, "ties" DECIMAL, "pct" DECIMAL)

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