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)

how many parties had zero councils ?
SELECT COUNT("party") FROM table_204_223 WHERE "new council" = 0
SELECT COUNT("party") FROM "table_204_223" WHERE "new council" = 0