Show the building for all Faculty.
select building from faculty
Show the number of faculty members for each of those buildings.
select building, count(*) from faculty group by building
List them in descending order of the count.
select building, count(*) from faculty group by building order by count(*) desc
Which building has the most?
select building from faculty group by building order by count(*) desc limit 1