What is the mean amount of staying councilors with an election result amounting to less than 10 with the Green party, and a new council bigger than 0?
SELECT AVG Staying councillors FROM table WHERE Election result < 10 AND Party = green AND New council > 0