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
what is the club id of stud 1001
assistant
SELECT clubid FROM Member_of_club WHERE stuid = 1001;
human
what is the club name of AKW
assistant
SELECT clubname FROM club WHERE clublocation = 'AKW';
human
what is the position of club id 1 | What do you mean by the position of club id 1 | in the table member of club
assistant
SELECT position FROM Member_of_club WHERE clubid = 1 ;