CREATE TABLE table_57801 ("Coach" CLOB, "Years" CLOB, "Seasons" FLOAT, "Lost" FLOAT, "Pct." FLOAT)

How many seasons has John Mcfadden coached?
SELECT COUNT("Seasons") FROM table_57801 WHERE "Coach" = 'john mcfadden'
SELECT COUNT("Seasons") FROM "table_57801" WHERE "Coach" = 'john mcfadden'