CREATE TABLE Faculty (building VARCHAR, rank VARCHAR)

Show all the buildings that have at least 10 professors.
SELECT building FROM Faculty WHERE rank = "Professor" GROUP BY building HAVING COUNT(*) >= 10
SELECT "building" FROM "Faculty" WHERE "Professor" = "rank" GROUP BY "building" HAVING COUNT(*) >= 10