Database: wedding
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