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 clubs are there in AKW?
assistant
SELECT COUNT( * ) FROM Club WHERE ClubLocation = 'AKW';
human
Tell me their name.
assistant
SELECT ClubName FROM Club WHERE ClubLocation = 'AKW';
human
How many different roles are there in the club 'Bootup Baltimore'?
assistant
SELECT COUNT( DISTINCT t2.position ) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid = t2.clubid WHERE t1.clubname = "Bootup Baltimore" ;