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 do you have?
assistant
SELECT COUNT( * ) FROM club;
human
How many members does each club have?
assistant
SELECT clubId , COUNT( StuId ) FROM Member_of_club GROUP by clubId ;