human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Faculty (FacID, Lname, Fname, Rank, Sex, Phone, Room, Building)
Department (DNO, Division, DName, Room, Building, DPhone)
Member_of (FacID, DNO, Appt_Type)
Course (CID, CName, Credits, Instructor, Days, Hours, DNO)
Minor_in (StuID, DNO)
Enrolled_in (StuID, CID, Grade)
Gradeconversion (lettergrade, gradepoint)
Please answer with SQL.
assistant
Sure, I understand.
human
How many male faculties live in NEB?
assistant
SELECT COUNT( * ) FROM FACULTY WHERE sex = 'M' AND Building = 'NEB';
human
What is the rank of Mark Giuliano?
assistant
SELECT rank FROM FACULTY WHERE fname = 'Mark' AND lname = 'Giuliano';
human
How many of the faculties are the rank of professors?
assistant
SELECT COUNT( * ) FROM FACULTY WHERE rank = "Professor" ;