Database: activity_1
Question: In which buildings are there at least ten professors?
SQL:
SELECT building FROM Faculty WHERE rank  =  "Professor" GROUP BY building HAVING count(*)  >=  10