CREATE TABLE Faculty (building VARCHAR2)

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