How many professors are there?
select count ( * ) from faculty where rank = "Professor"
How many different buildings do you have?
select count ( distinct building ) from faculty
Can you tell me the number of Professors in the building NEB?
select count ( * ) from faculty where rank = "Professor" and building = "NEB"