Database: activity_1
Question: Show all the buildings along with the number of faculty members the buildings have.
SQL:
SELECT building ,  count(*) FROM Faculty GROUP BY building