Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantas temporadas John McFadden treinou?
 ###Tabelas: CREATE TABLE recording_career (recording_career_id AUTO_INCREMENT PRIMARY KEY, Event VARCHAR, Year INT, Category VARCHAR, Work VARCHAR, Outcome VARCHAR) CREATE TABLE most_points_in_a_la_liga_season_at_least_90_points (most_points_in_a_la_liga_season_at_least_90_points_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Club VARCHAR, Season VARCHAR, Points INT, Apps INT) CREATE TABLE record_by_coach (record_by_coach_id AUTO_INCREMENT PRIMARY KEY, Coach VARCHAR, Years VARCHAR, Seasons INT, Lost INT, Pct. INT) CREATE TABLE results_by_club (results_by_club_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Wins INT, Runners-up INT, Years won VARCHAR, Years runner-up VARCHAR) CREATE TABLE house_of_savoy (house_of_savoy_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Father VARCHAR, Birth VARCHAR, Marriage VARCHAR, Became Duchess VARCHAR, Ceased to be Duchess VARCHAR, Death VARCHAR, Spouse VARCHAR)  
SELECT COUNT Seasons FROM record_by_coach WHERE Coach = john mcfadden