Show all the buildings along with the number of faculty members the buildings have.
CREATE TABLE Faculty (building VARCHAR)
SELECT building, COUNT(*) FROM Faculty GROUP BY building
### Context: CREATE TABLE Faculty (building VARCHAR) ### Question: Show all the buildings along with the number of faculty members the buildings have. ### Answer: SELECT building, COUNT(*) FROM Faculty GROUP BY building