Table schema:
CREATE TABLE Faculty (building VARCHAR, rank VARCHAR)

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