CREATE TABLE FACULTY (Fname VARCHAR2, Lname VARCHAR2, sex VARCHAR2, Building VARCHAR2)

Find the first names and last names of male (sex is M) faculties who live in building NEB.
SELECT Fname, Lname FROM FACULTY WHERE sex = "M" AND Building = "NEB"
SELECT "Fname", "Lname" FROM "FACULTY" WHERE "Building" = "NEB" AND "M" = "sex"