CREATE TABLE church (open_date VARCHAR2)

Show all opening years and the number of churches that opened in that year.
SELECT open_date, COUNT(*) FROM church GROUP BY open_date
SELECT "open_date", COUNT(*) FROM "church" GROUP BY "open_date"