Can i have the city code of all members of the tennis club
SELECT t3.city_code 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"
city code of all members of the tennis club refers to SELECT t3.city_code; joining tables to relate clubs, memberships, and students' information; filtering by Tennis Club name refers to WHERE t1.clubname = \"Tennis Club\";