user: ### NOW ANSWER:
Question: How many seasons has john mcfadden coached?
Columns: ['Coach', 'Years', 'Seasons', 'Lost', 'Pct.']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['No coach', '1902-06', 5.0, 15.0, 0.545]
SQL:

assistant: SELECT COUNT("Seasons") FROM "Table" WHERE "Coach" = 'john mcfadden';