CREATE TABLE table_name_96 (seats_up_for_election NUMBER, election_result VARCHAR2, staying_councillors VARCHAR2)

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