How many professors do you have in buildings? | Can you clarify your question? | Total number of professors in NEB building?
SELECT count ( * )  FROM Faculty WHERE Rank   =   "Professor" AND building   =   "NEB"
Total number of professors refers to COUNT(*); in a specific building refers to WHERE building = 'specific building name';