Table schema:
CREATE TABLE Faculty (building VARCHAR)

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