Database: region_building
Question: Please show each completion year and the number of buildings completed in that year.
SQL:
SELECT Completed_Year ,  COUNT(*) FROM building GROUP BY Completed_Year