How many staying councillors were there when the election result was larger than 0, the new council less than 27 and the party conservatives?
CREATE TABLE table_name_42 (staying_councillors INTEGER, new_council VARCHAR, election_result VARCHAR, party VARCHAR)
SELECT AVG(staying_councillors) FROM table_name_42 WHERE election_result > 0 AND party = "conservatives" AND new_council < 27
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (staying_councillors INTEGER, new_council VARCHAR, election_result VARCHAR, party VARCHAR) Question: How many staying councillors were there when the election result was larger than 0, the new council less than 27 and the party conservatives? [/INST] SELECT AVG(staying_councillors) FROM table_name_42 WHERE election_result > 0 AND party = "conservatives" AND new_council < 27 </s>