Schema: CREATE TABLE Faculty (Rank VARCHAR, building VARCHAR)
Question: How many Professors are in building NEB?
SQL: SELECT COUNT(*) FROM Faculty WHERE Rank = "Professor" AND building = "NEB"