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 média Total possui um prêmio Gold de 13 e um prêmio Bronze inferior a 13?
 ###Tabelas: CREATE TABLE nice_system (nice_system_id AUTO_INCREMENT PRIMARY KEY, Member state VARCHAR, Population millions INT, MEPs INT, Inhabitants per MEP INT, Influence INT) CREATE TABLE total (total_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Nation VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE current_judges (current_judges_id AUTO_INCREMENT PRIMARY KEY, Position VARCHAR, Name VARCHAR, Stationed In VARCHAR, Appointed INT, Nominated by VARCHAR, Position Prior to Appointment VARCHAR) CREATE TABLE lpga_tour_wins_9 (lpga_tour_wins_9_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Winning score VARCHAR, To par VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR, Winner's share ( $ ) INT) CREATE TABLE coaches'_poll (coaches'_poll_id AUTO_INCREMENT PRIMARY KEY, Week 1 Sept 2 VARCHAR, Week 2 Sept 7 VARCHAR, Week 3 Sept 14 VARCHAR, Week 5 Sept 28 VARCHAR, Week 6 Oct 5 VARCHAR, Week 7 Oct 12 VARCHAR, Week 10 Nov 2 VARCHAR, Week 13 Nov 23 VARCHAR, Week 14 Nov 30 VARCHAR, Week 15 Dec 7 VARCHAR, Week 16 (Final) Jan 9 VARCHAR)  
SELECT AVG Total FROM total WHERE Gold = 13 AND Bronze < 13