CREATE TABLE table_171356_2 (status VARCHAR, official_name VARCHAR)

How many statuses are listed for the parish officially named Gagetown?
SELECT COUNT(status) FROM table_171356_2 WHERE official_name = "Gagetown"
SELECT COUNT("status") FROM "table_171356_2" WHERE "Gagetown" = "official_name"