CREATE TABLE club (clubid VARCHAR2, clubname VARCHAR2)
CREATE TABLE student (stuid VARCHAR2)
CREATE TABLE member_of_club (clubid VARCHAR2, stuid VARCHAR2)

How many members does the club 'Tennis Club' has?
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 = "Tennis Club"
SELECT COUNT(*) FROM "club" "t1" JOIN "member_of_club" "t2" ON "t1"."clubid" = "t2"."clubid" JOIN "student" "t3" ON "t2"."stuid" = "t3"."stuid" WHERE "Tennis Club" = "t1"."clubname"