human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Restaurant (ResID, ResName, Address, Rating)
Type_Of_Restaurant (ResID, ResTypeID)
Restaurant_Type (ResTypeID, ResTypeName, ResTypeDescription)
Visits_Restaurant (StuID, ResID, Time, Spent)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi, could you please let me know the list of all female students who are older than 18 and not majoring in 600? | what did you want to get about female students who are older than 18 and not majoring in 600? | Oh sorry for the confusion, it would be great if I can see their first and last name.
assistant
SELECT Fname , Lname FROM Student WHERE Age > 18 AND Major ! = 600 AND Sex = 'F';
human
Thank you very much! Then could you please show me the male students' first and last name with the same condition? Meaning older than 18 and not majoring in 600.
assistant
SELECT Fname , Lname FROM Student WHERE Age > 18 AND Major ! = 600 AND Sex = "M" ;