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 soma das pontuações dos maiôs de Missouri que têm pontuações de vestido de noite inferiores a 8,77 e pontuações médias inferiores a 8,823?
 ###Tabelas: CREATE TABLE 20th-_and_21st-century_swiss_confederation_issues (20th-_and_21st-century_swiss_confederation_issues_id AUTO_INCREMENT PRIMARY KEY, Location VARCHAR, Date INT, Denomination VARCHAR, Coinage metal VARCHAR, Mintage INT, KM number VARCHAR) CREATE TABLE south_carolina_counties_ranked_by_per_capita_income (south_carolina_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 preliminary_competition (preliminary_competition_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Interview INT, Swimsuit INT, Evening gown INT, Average INT) CREATE TABLE list_of_some_notable_incidents_involving_time_bombs (list_of_some_notable_incidents_involving_time_bombs_id AUTO_INCREMENT PRIMARY KEY, Year INT, Event VARCHAR, Location VARCHAR, Perpetrator(s) VARCHAR, Deaths VARCHAR) CREATE TABLE in_general_elections (in_general_elections_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, General Election VARCHAR, Seats Won INT, Change in Seat INT, % of votes VARCHAR, votes swing VARCHAR)  
SELECT SUM Swimsuit FROM preliminary_competition WHERE Evening gown < 8.77 AND State = missouri AND Average < 8.823