CREATE TABLE table_name_10 (seats_up_for_election NUMBER, election_result VARCHAR2, new_council VARCHAR2)

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