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 jardas totais para Bobby Layne?
 ###Tabelas: CREATE TABLE most_starts_from_front_row_in_a_season (most_starts_from_front_row_in_a_season_id AUTO_INCREMENT PRIMARY KEY, Driver VARCHAR, Season VARCHAR, Entries INT, Front row starts INT, Percentage VARCHAR) CREATE TABLE team_career_passing_records (team_career_passing_records_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Completions INT, Attempts INT, Completion % VARCHAR, Yards INT, Touchdowns INT, Interceptions INT, QB Rating VARCHAR) CREATE TABLE matches_in_europe (matches_in_europe_id AUTO_INCREMENT PRIMARY KEY, Competition VARCHAR, Round VARCHAR, Opposition VARCHAR, Home Leg VARCHAR, Away Leg VARCHAR) CREATE TABLE pool_4 (pool_4_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Tries for INT, Tries against INT, Try diff VARCHAR, Points for INT, Points against INT, Points diff VARCHAR) CREATE TABLE 1937 (1937_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Series VARCHAR, Director VARCHAR, Production Num. VARCHAR, Release date VARCHAR)  
SELECT MAX Yards FROM team_career_passing_records WHERE Name = Bobby Layne