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 first names of all the female students.
assistant
SELECT Fname FROM Student WHERE Sex = 'F';
human
Tell me their majors.
assistant
SELECT Major FROM Student WHERE Sex = 'F';
human
Find all members of 'Bootup Baltimore' whose major is '600'. Show the first name and last name
assistant
SELECT t3.fname , t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid = t2.clubid JOIN student AS t3 ON t2.stuid = t3.stuid WHERE t1.clubname = "Bootup Baltimore" AND t3.major = "600" ;