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

which is a civil parish , aintree village or maghull ?
SELECT "name" FROM table_204_600 WHERE "name" IN ('aintree village', 'maghull') AND "status" = 'civil parish'
SELECT "name" FROM "table_204_600" WHERE "name" IN ('aintree village', 'maghull') AND "status" = 'civil parish'