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
How many students are members of the club 'Bootup Baltimore'?
assistant
SELECT COUNT( * ) FROM Club AS T1 JOIN member_of_club AS T2 ON T1.clubid = T2.clubid WHERE T1.clubname = 'Bootup Baltimore';
human
Please provide the ages of the two members.
assistant
SELECT T3.age 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';
human
What is the average age of the two members of the club Bootup Baltimore?
assistant
SELECT AVG ( T3.age ) 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" ;