CREATE TABLE table_204_600 (id NUMBER, "name" CLOB, "status" CLOB, "population" NUMBER, "district" CLOB, "former local authority" CLOB)

how many areas are unparished areas ?
SELECT COUNT("name") FROM table_204_600 WHERE "status" = 'unparished area'
SELECT COUNT("name") FROM "table_204_600" WHERE "status" = 'unparished area'