CREATE TABLE table_203_36 (id NUMBER, "parish" CLOB, "locality" CLOB, "parish priest" CLOB, "founded" NUMBER, "closed" NUMBER)

which parish is the only one to have closed ?
SELECT "parish" FROM table_203_36 WHERE NOT "closed" IS NULL
SELECT "parish" FROM "table_203_36" WHERE NOT "closed" IS NULL