-- Database schema
| Student : StuID [ INT ] primary_key , LName [ TEXT ] , Fname [ TEXT ] , Age [ INT ] , Sex [ TEXT ] , Major [ INT ] , Advisor [ INT ] , city_code [ TEXT ] | Club : ClubID [ INT ] primary_key , ClubName [ TEXT ] , ClubDesc [ TEXT ] , ClubLocation [ TEXT ] | Member_of_club : StuID [ INT ] Member_of_club.StuID = Student.StuID , ClubID [ INT ] Member_of_club.ClubID = Club.ClubID , Position [ TEXT ] |
-- -- Count the members of the club "Tennis Club".

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";