Database: activity_1
Question: Show all the buildings that have at least 10 professors.
SQL:
SELECT building FROM Faculty WHERE rank  =  "Professor" GROUP BY building HAVING count(*)  >=  10