What is the total count of faculty members?
select count(*) from faculty
How many are Professors?
select count(*) from faculty where rank = "Professor"
How many of these are in building NEB?
select count(*) from faculty where rank = "Professor" and building = "NEB"