Can you please list the full names of all male faculty members and the buildings they live in?
select fname, lname, building from faculty where sex = "M"
Could you narrow that down to just male faculty members in the NEB building?
select fname, lname from faculty where sex = "M" and building = "NEB"
What rooms do they live in? Please add it to the table.
select fname, lname, room from faculty where sex = "M" and building = "NEB"