user: ### NOW ANSWER:
Question: How many seats were up for election during the vote where the election result was 9 and the new council 27?
Columns: ['Party', 'Previous council', 'Staying councillors', 'Seats up for election', 'Election result', 'New council']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Conservatives', 29.0, 19.0, 10.0, 9.0, 27.0]
SQL:

assistant: SELECT SUM("Seats up for election") FROM "Table" WHERE "Election result" = 9.0 AND "New council" > 27.0;