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 positions of the student named Lisa.
assistant
SELECT Position FROM member_of_club AS t1 JOIN student AS t2 ON t1.stuid = t2.stuid WHERE T2.Fname = "Lisa" ;