Show the building for all Faculty.
select building from faculty
How about those for professors?
select building from faculty where rank = "Professor"
For each of the buildings, show the number of professors.
select building, count(*) from faculty where rank = "Professor" group by building
Which of them have at least 10?
select building from faculty where rank = "Professor" group by building having count(*) >= 10