Table: coventry_election_2007
Columns: party
previous_council
staying_councillors
seats_up_for_election
election_result
new_council

Question: What is the full number of New Council when the previous council was 54 and the staying councilor number is bigger than 36?
SQL: SELECT COUNT("new_council") FROM coventry_election_2007 WHERE "previous_council" = 54 AND "staying_councillors" > 36

Question: Which number of New Councils had a previous council number of 19 and the seats up for election were bigger than 6?
SQL: SELECT COUNT("new_council") FROM coventry_election_2007 WHERE "previous_council" = 19 AND "seats_up_for_election" < 6

Question: What is the mean amount of staying councilors with an election result amounting to less than 10 with the Green party, and a new council bigger than 0?
SQL: SELECT AVG("staying_councillors") FROM coventry_election_2007 WHERE "election_result" < 10 AND "party" = 'green' AND "new_council" > 0