user: ### NOW ANSWER:
Question: What is the average new council number when the election result is smaller than 0?
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 AVG("New council") FROM "Table" WHERE "Election result" < 0.0;