SELECT building ,  count(*) FROM Faculty GROUP BY building
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
Show all the buildings along with the number of faculty members the buildings have .