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: Capacidade menor que 3.292 e um Maior maior que 812, e um Estádio do estádio de casas de strathclyde tem qual soma da média?
 ###Tabelas: CREATE TABLE specifications_r-985_wasp_junior_sb (specifications_r-985_wasp_junior_sb_id AUTO_INCREMENT PRIMARY KEY, Engine VARCHAR, Power, continuous VARCHAR, Critical altitude This is the highest altitude at which the engine can achieve its full continuous power rating. Above this altitude, power falls off with height as with a naturally aspirated engine . See Supercharger#Altitude effects for details. VARCHAR, Power, takeoff VARCHAR, Compression ratio VARCHAR, Supercharger gear ratio VARCHAR, Octane rating VARCHAR, Dry weight VARCHAR) CREATE TABLE back-to-back_night_pre-season_winners (back-to-back_night_pre-season_winners_id AUTO_INCREMENT PRIMARY KEY, Season INT, Premier VARCHAR, Runner Up VARCHAR, Score VARCHAR, Venue VARCHAR, Attendance INT, Margin INT) CREATE TABLE sales_and_production_figures (sales_and_production_figures_id AUTO_INCREMENT PRIMARY KEY, Model VARCHAR, 1998 VARCHAR, 1999 VARCHAR, 2000 VARCHAR, 2001 VARCHAR, 2002 VARCHAR, 2003 VARCHAR, 2004 VARCHAR, 2005 VARCHAR, 2006 VARCHAR, 2007 VARCHAR, 2008 VARCHAR, 2009 VARCHAR, 2010 VARCHAR, 2011 VARCHAR) CREATE TABLE world_championship_group_a_soviet_union (world_championship_group_a_soviet_union_id AUTO_INCREMENT PRIMARY KEY, Games INT, Drawn INT, Lost INT, Points difference VARCHAR, Points INT) CREATE TABLE stadia_and_attendances (stadia_and_attendances_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Stadium VARCHAR, Capacity INT, Highest INT, Lowest INT, Average INT)  
SELECT SUM Average FROM stadia_and_attendances WHERE Capacity < 3,292 AND Highest > 812 AND Stadium = strathclyde homes stadium