Database: activity_1
Question: How many faculty members does each building have? List the result with the name of the building.
SQL:
SELECT building ,  count(*) FROM Faculty GROUP BY building