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 aplicativos de liga o jogador com 11 gols na equipe teve?
 ###Tabelas: CREATE TABLE registered_births_and_deaths (registered_births_and_deaths_id AUTO_INCREMENT PRIMARY KEY, Average population (x 1000) INT, Live births VARCHAR, Deaths VARCHAR, Natural change VARCHAR, Crude birth rate (per 1000) INT, Crude death rate (per 1000) INT, Natural change (per 1000) INT) CREATE TABLE series_3_2004 (series_3_2004_id AUTO_INCREMENT PRIMARY KEY, Celebrity VARCHAR, Famous for VARCHAR, Entered VARCHAR, Exited VARCHAR, Finished VARCHAR) CREATE TABLE season_table (season_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Total points VARCHAR, Bonus points VARCHAR, Match points VARCHAR, Games VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Diff VARCHAR) CREATE TABLE player_statistics (player_statistics_id AUTO_INCREMENT PRIMARY KEY, Position VARCHAR, Nationality VARCHAR, Name VARCHAR, League apps INT, League goals INT, FA Cup apps INT, FA Cup goals INT, Total apps INT, Total goals INT) CREATE TABLE wards (wards_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Labour INT, Conservative INT, Political party VARCHAR, Electorate INT, Constituency VARCHAR)  
SELECT League apps FROM player_statistics WHERE Total goals = 11