CREATE TABLE table_name_42 (staying_councillors INT, new_council VARCHAR, election_result VARCHAR, party VARCHAR)

How many staying councillors were there when the election result was larger than 0, the new council less than 27 and the party conservatives?
SELECT AVG(staying_councillors) FROM table_name_42 WHERE election_result > 0 AND party = "conservatives" AND new_council < 27
SELECT AVG("staying_councillors") FROM "table_name_42" WHERE "conservatives" = "party" AND "election_result" > 0 AND "new_council" < 27