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 é o mais geral quando as nomeações executivas eram 28 e o histórico era menor que 37?
 ###Tabelas: CREATE TABLE week_6 (week_6_id AUTO_INCREMENT PRIMARY KEY, Couple VARCHAR, Style VARCHAR, Music VARCHAR, Trine Dehli Cleve INT, Tor Fløysvik INT, Karianne Gulliksen INT, Christer Tornell INT, Total INT) CREATE TABLE siena_college_research_institute_survey (siena_college_research_institute_survey_id AUTO_INCREMENT PRIMARY KEY, Seq. VARCHAR, Name VARCHAR, Background INT, Party Leadership INT, Communication Ability INT, Relations with Congress INT, Court Appointments INT, Handling of Economy INT, Luck INT, Ability to Compromise INT, Willing to take Risks INT, Executive Appointments INT, Overall Ability INT, Imagination INT, Domestic Accomplishments INT, Integrity INT, Executive Ability INT, Foreign Policy Accomplishments INT, Leadership Ability INT, Intelligence INT, Avoid Crucial Mistakes INT, Expert's View INT, Overall INT) CREATE TABLE most_goals_in_a_season (most_goals_in_a_season_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Goals VARCHAR, Player VARCHAR, Club VARCHAR, Season VARCHAR) CREATE TABLE june_secondary_phase (june_secondary_phase_id AUTO_INCREMENT PRIMARY KEY, Round INT, Name VARCHAR, Position VARCHAR, School VARCHAR, Signed VARCHAR) CREATE TABLE biosynthesis (biosynthesis_id AUTO_INCREMENT PRIMARY KEY, Enzyme VARCHAR, Location VARCHAR, Substrate VARCHAR, Product VARCHAR, Chromosome VARCHAR, EC VARCHAR, OMIM INT, Porphyria VARCHAR)  
SELECT MAX Overall FROM siena_college_research_institute_survey WHERE Executive Appointments = 28 AND Background < 37