SELECT building ,  count(*) FROM Faculty GROUP BY building
How many faculty members does each building have? List the result with the name of the building.
SELECT building , count ( * ) FROM Faculty GROUP BY building
select building , count ( * ) from faculty group by building
How many faculty members does each building have ? List the result with the name of the building .