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: Quantos conselheiros permaneceram quando o resultado da eleição foi maior que 0, o novo conselho menos que 27 e o partido conservador?
 ###Tabelas: CREATE TABLE listing (listing_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Population ( 2011 Census ) INT, Percent of national population VARCHAR, % growth (2006–11) VARCHAR, Land area (km²) INT, Population density (/km 2 ) INT, House of Commons seats INT, House of Commons seats (%) VARCHAR, 2013 population (July est.) INT) CREATE TABLE season_3 (season_3_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production code VARCHAR) CREATE TABLE council_composition (council_composition_id AUTO_INCREMENT PRIMARY KEY, Party VARCHAR, Previous council INT, Staying councillors INT, Seats up for election INT, Election result INT, New council INT) CREATE TABLE in_operation (in_operation_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Operators Name VARCHAR, Technology VARCHAR, Subscribers (in millions) VARCHAR, Ownership VARCHAR, Market Share VARCHAR) CREATE TABLE 1985_nfl_draft (1985_nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Pick INT, Name VARCHAR, Position VARCHAR, School VARCHAR)  
SELECT AVG Staying councillors FROM council_composition WHERE Election result > 0 AND Party = conservatives AND New council < 27