Total number of professors in NEB building?
select count ( * ) from faculty where rank = "Professor" and building = "NEB"
What of instructors?
select count ( * ) from faculty where rank = "Instructor" and building = "NEB"
What of total number of faculty?
select count ( * ) from faculty where building = "NEB"