Find the first names and last names of male (sex is M) faculties who live in building NEB.
CREATE TABLE FACULTY (Fname VARCHAR, Lname VARCHAR, sex VARCHAR, Building VARCHAR)
SELECT Fname, Lname FROM FACULTY WHERE sex = "M" AND Building = "NEB"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE FACULTY (Fname VARCHAR, Lname VARCHAR, sex VARCHAR, Building VARCHAR) Question: Find the first names and last names of male (sex is M) faculties who live in building NEB. [/INST] SELECT Fname, Lname FROM FACULTY WHERE sex = "M" AND Building = "NEB" </s>