Table: coventry_election_2008
Columns: party
previous_council
staying_councillors
seats_up_for_election
election_result
new_council

Question: What is the average new council number when the election result is smaller than 0?
SQL: SELECT AVG("new_council") FROM coventry_election_2008 WHERE "election_result" < 0

Question: How many seats were up for election during the vote where the election result was 9 and the new council 27?
SQL: SELECT SUM("seats_up_for_election") FROM coventry_election_2008 WHERE "election_result" = 9 AND "new_council" > 27

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?
SQL: SELECT AVG("staying_councillors") FROM coventry_election_2008 WHERE "election_result" > 0 AND "party" = 'conservatives' AND "new_council" < 27