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
Hello, what is the name of the student with student id 1008? | The first and last name of the student with student id 1008 is Jandy Nelson. | What is her major?
assistant
SELECT Major FROM student WHERE StuID = 1008;
human
Apologies, I meant to ask his/her major; what is the student's sex?
assistant
SELECT sex FROM student WHERE StuID = 1008 ;