Hi. How many different clubs are there in total?
select count ( * ) from club
What are the names of the 4 clubs?
select clubname from club
Among the 4 clubs, how many members are there in total?
select count ( * ) from member_of_club
Of the 4 members, how many of them are members of the club "Pen and Paper Gaming"?
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"