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: Qual é o total de gols para Mark Ward?
 ###Tabelas: CREATE TABLE launches (launches_id AUTO_INCREMENT PRIMARY KEY, Mission No. VARCHAR, Cover Name VARCHAR, Launch Date VARCHAR, NSSDC ID No. VARCHAR, Alt. Name VARCHAR, Camera VARCHAR, Notes VARCHAR) CREATE TABLE england_in_south_africa_1913_4 (england_in_south_africa_1913_4_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Home captain VARCHAR, Away captain VARCHAR, Venue VARCHAR, Result VARCHAR) CREATE TABLE targets (targets_id AUTO_INCREMENT PRIMARY KEY, HD designation VARCHAR, Constellation VARCHAR, Distance ( ly ) INT, Spectral type VARCHAR, Signal power ( kW ) INT, Date sent VARCHAR, Arrival date VARCHAR) CREATE TABLE appearances_and_goals (appearances_and_goals_id AUTO_INCREMENT PRIMARY KEY, 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, Total Apps VARCHAR, Total Goals INT) CREATE TABLE president (president_id AUTO_INCREMENT PRIMARY KEY, Election INT, Candidate VARCHAR, Number of votes VARCHAR, Share of votes VARCHAR, Outcome of election VARCHAR)  
SELECT MIN Total Goals FROM appearances_and_goals WHERE Name = mark ward