What are the average age of all the members of the tennis club
select avg ( t3.age ) 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"
Give me the first names and last names of all the members of the tennis club
select t3.fname, t3.lname 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"
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"
Give me the position of the member in the tennis club
select t2.position 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"