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: Quantos Totais têm um FA Trophy de 0 e um Jogador de charlie butler?
 ###Tabelas: CREATE TABLE singles_21–5 (singles_21–5_id AUTO_INCREMENT PRIMARY KEY, Edition VARCHAR, Round VARCHAR, Date VARCHAR, Surface VARCHAR, Opponent VARCHAR, Result VARCHAR) CREATE TABLE complete_world_championship_grand_prix_results (complete_world_championship_grand_prix_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Entrant VARCHAR, Chassis VARCHAR, Engine VARCHAR, Points INT) CREATE TABLE world_energy_intensity_progression_by_year. (world_energy_intensity_progression_by_year._id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Unit p koe/$05 VARCHAR, 2006 INT, 2007 INT, 2008 INT, 2009 INT) CREATE TABLE top_scorers_in_order_of_league_goals (top_scorers_in_order_of_league_goals_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Club VARCHAR, League INT, FA Cup INT, FA Trophy INT, League Cup INT, Total INT) CREATE TABLE main_issuers (main_issuers_id AUTO_INCREMENT PRIMARY KEY, Currency VARCHAR, Country VARCHAR, Generic Name or Nickname VARCHAR, Rating ( S&P / Moodys ) VARCHAR, Negotiable debt at mid-2005 ( US dollar bn equivalent) INT, Government financial liabilities as % of GDP (end 2003 - source : OECD ) VARCHAR, Issuer VARCHAR, Internet site VARCHAR)  
SELECT COUNT Total FROM top_scorers_in_order_of_league_goals WHERE FA Trophy = 0 AND Player = charlie butler