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 tentativas Charley Johnson teve?
 ###Tabelas: CREATE TABLE team_seedings (team_seedings_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Team VARCHAR, Total Points INT, 2008-09 Points INT, 2007-08 Points INT, 2006-07 Points INT, 2005-06 Points INT) CREATE TABLE by_nationality (by_nationality_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Total Drivers INT, Champions INT, Championships INT, Current March 20, 2010 INT, First driver(s) VARCHAR, Last/Current driver(s) March 20, 2010 VARCHAR) CREATE TABLE short_vowels (short_vowels_id AUTO_INCREMENT PRIMARY KEY, Short vowels VARCHAR, 17th-c. VARCHAR, American VARCHAR, British VARCHAR, Australian VARCHAR) CREATE TABLE south_dakota_counties_by_per_capita_income (south_dakota_counties_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT) 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)  
SELECT COUNT Attempts FROM team_career_passing_records WHERE Name = Charley Johnson