CREATE TABLE table_204_158 (id NUMBER, "official name" CLOB, "designation" CLOB, "area km2" NUMBER, "population" NUMBER, "parish" CLOB)

city in the same parish of moncton
SELECT "official name" FROM table_204_158 WHERE "official name" <> 'moncton' AND "parish" = 'moncton'
SELECT "official name" FROM "table_204_158" WHERE "official name" <> 'moncton' AND "parish" = 'moncton'