Table: oxford_election_2008
Columns: party
previous_council
staying_councillors
seats_up_for_election
election_result
new_council

Question: Which Seats up for election have an Election result larger than 8, and Staying councillors of 24?
SQL: SELECT MAX("seats_up_for_election") FROM oxford_election_2008 WHERE "election_result" > 8 AND "staying_councillors" = 24

Question: Which New council has an Election result larger than 24?
SQL: SELECT AVG("new_council") FROM oxford_election_2008 WHERE "election_result" > 24

Question: Which Staying councillors have a New council of 7, and a Previous council larger than 8?
SQL: SELECT AVG("staying_councillors") FROM oxford_election_2008 WHERE "new_council" = 7 AND "previous_council" > 8