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 é a capacidade média do local onde a equipe kommunalnik jogou?
 ###Tabelas: CREATE TABLE teams_and_venues (teams_and_venues_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Location VARCHAR, Venue VARCHAR, Capacity INT, Position in 1999 VARCHAR) CREATE TABLE internal_correspondences (internal_correspondences_id AUTO_INCREMENT PRIMARY KEY, Tongan VARCHAR, Niuean VARCHAR, Sāmoan VARCHAR, Takuu VARCHAR, Tahitian VARCHAR, Rarotongan VARCHAR, Māori VARCHAR, North Marquesan VARCHAR, South Marquesan VARCHAR, Hawai'ian VARCHAR, Mangarevan VARCHAR) CREATE TABLE swindon_town_career_details (swindon_town_career_details_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Team VARCHAR, League Apps INT, League Goals INT, Cup Apps INT, Cup Goals INT) CREATE TABLE georgia_counties_ranked_by_per_capita_income (georgia_counties_ranked_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 clausura_2004_standings (clausura_2004_standings_id AUTO_INCREMENT PRIMARY KEY, Place INT, Team VARCHAR, Played INT, Draw INT, Lost INT, Goals Scored INT, Goals Conceded INT, Points INT)  
SELECT AVG Capacity FROM teams_and_venues WHERE Team = kommunalnik