human
Schema:
Student (StuID, LName, Fname, Age, Sex, Major, Advisor, city_code)
Club (ClubID, ClubName, ClubDesc, ClubLocation)
Member_of_club (StuID, ClubID, Position)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the city code of the city where 'Davis Steven' lives.
assistant
SELECT city_code FROM Student WHERE Lname = 'Davis' AND FName = 'Steven';
human
What is his major?
assistant
SELECT Major FROM Student WHERE Lname = "Davis" AND FName = "Steven" ;