What are the rooms for all faculty with rank professor?
select room from faculty where rank = "Professor"
Of those, which are for faculty who live in building NEB?
select room from faculty where rank = "Professor" and building = "NEB"