how many coaches had above 500 wins ?
CREATE TABLE table_204_469 (
    id number,
    "coach" text,
    "years" text,
    "seasons" number,
    "wins" number,
    "losses" number,
    "ties" number,
    "pct" number
)
SELECT COUNT("coach") FROM table_204_469 WHERE "wins" > 500
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: how many coaches had above 500 wins ? ### Input: CREATE TABLE table_204_469 (
    id number,
    "coach" text,
    "years" text,
    "seasons" number,
    "wins" number,
    "losses" number,
    "ties" number,
    "pct" number
) ### Response: SELECT COUNT("coach") FROM table_204_469 WHERE "wins" > 500