user: ### NOW ANSWER:
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?
Columns: ['Party', 'Previous council', 'Staying councillors', 'Seats up for election', 'Election result', 'New council']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Conservatives', 29.0, 19.0, 10.0, 9.0, 27.0]
SQL:

assistant: SELECT AVG("Staying councillors") FROM "Table" WHERE "Election result" > 0.0 AND "Party" = 'conservatives' AND "New council" < 27.0;