Show me all the buildings that have at least 10 professors
SELECT building FROM Faculty WHERE rank   =   "Professor" GROUP BY building HAVING count ( * )    > =    10
buildings that have at least 10 professors refers to HAVING COUNT(*) >= 10; rank = 'Professor' specifies filtering condition for professors;