CREATE TABLE table_name_22 (staying_councillors INT, new_council VARCHAR, previous_council VARCHAR)

Which Staying councillors have a New council of 7, and a Previous council larger than 8?
SELECT AVG(staying_councillors) FROM table_name_22 WHERE new_council = 7 AND previous_council > 8
SELECT AVG("staying_councillors") FROM "table_name_22" WHERE "new_council" = 7 AND "previous_council" > 8