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: Eu quero saber a soma dos gols da fa cup para david mirfin e o total de gols inferior a 1.
 ###Tabelas: CREATE TABLE 1954_to_1972 (1954_to_1972_id AUTO_INCREMENT PRIMARY KEY, Issued INT, Type VARCHAR, Design VARCHAR, Serial format VARCHAR, Serials issued VARCHAR) CREATE TABLE post_positions (post_positions_id AUTO_INCREMENT PRIMARY KEY, Finished INT, Time/ Behind VARCHAR, Post INT, Horse VARCHAR, Jockey VARCHAR, Trainer VARCHAR, Owner VARCHAR) CREATE TABLE first_ladder_1999 (first_ladder_1999_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Wins INT, Byes INT, Losses INT, Against INT) CREATE TABLE appearances_and_goals (appearances_and_goals_id AUTO_INCREMENT PRIMARY KEY, Squad No. INT, Name VARCHAR, Position VARCHAR, League Apps VARCHAR, League Goals INT, FA Cup Apps VARCHAR, FA Cup Goals INT, League Cup Apps VARCHAR, League Cup Goals INT, FLT Apps VARCHAR, FLT Goals INT, Total Apps VARCHAR, Total Goals INT) CREATE TABLE most_race_wins_in_a_single_season (most_race_wins_in_a_single_season_id AUTO_INCREMENT PRIMARY KEY, Women VARCHAR, Country VARCHAR, Season VARCHAR, Victories INT, Downhill VARCHAR, Super G VARCHAR, Giant Slalom VARCHAR, Slalom VARCHAR, Combined VARCHAR)  
SELECT SUM FA Cup Goals FROM appearances_and_goals WHERE Name = david mirfin AND Total Goals < 1