Schema: CREATE TABLE church (open_date VARCHAR)
Question: Show all opening years and the number of churches that opened in that year.
SQL: SELECT open_date, COUNT(*) FROM church GROUP BY open_date