Table: buffaloes_basketball_stats
Columns: coach
years
seasons
lost
pct

Question: How many seasons has John Mcfadden coached?
SQL: SELECT COUNT("seasons") FROM buffaloes_basketball_stats WHERE "coach" = 'john mcfadden'