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
Hi. How many different clubs are there in total?
assistant
SELECT COUNT( * ) FROM club;
human
What are the names of the 4 clubs?
assistant
SELECT clubName FROM club;
human
Among the 4 clubs, how many members are there in total?
assistant
SELECT COUNT( * ) FROM member_of_club;
human
Of the 4 members, how many of them are members of the club 'Pen and Paper Gaming'?
assistant
SELECT COUNT( * ) 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 = "Pen AND Paper Gaming" ;