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" ;