Encontre as salas dos professores com classificação de professor que moram no prédio NEB.
CREATE TABLE FACULTY (Room VARCHAR, Rank VARCHAR, Building VARCHAR)
SELECT Room FROM FACULTY WHERE Rank = "Professor" AND Building = "NEB"