user: ### NOW ANSWER:
Question: Which Staying councillors have a New council of 7, and a Previous council larger than 8?
Columns: ['Party', 'Previous council', 'Staying councillors', 'Seats up for election', 'Election result', 'New council']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Labour', 19.0, 11.0, 8.0, 12.0, 23.0]
SQL:

assistant: SELECT AVG("Staying councillors") FROM "Table" WHERE "New council" = 7.0 AND "Previous council" > 8.0;