CREATE TABLE table_204_223 (id NUMBER, "party" CLOB, "previous council" NUMBER, "staying councillors" NUMBER, "seats up for election" NUMBER, "election result" NUMBER, "new council" NUMBER)

what is the average number of previou council ?
SELECT AVG("previous council") FROM table_204_223
SELECT AVG("previous council") FROM "table_204_223"