CREATE TABLE table_10295 ("Party" CLOB, "Previous council" FLOAT, "Staying councillors" FLOAT, "Seats up for election" FLOAT, "Election result" FLOAT, "New council" FLOAT)

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_10295 WHERE "Election result" < '10' AND "Party" = 'green' AND "New council" > '0'
SELECT AVG("Staying councillors") FROM "table_10295" WHERE "Election result" < '10' AND "New council" > '0' AND "Party" = 'green'