Tell me the club Andy is in.
select t1.clubname 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 t3.fname = "Andy"
What is Andy's sex?
select sex from student where fname = "Andy"
What is the name of the club that has the most female students.
select t1.clubname 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 t3.sex = "F" group by t1.clubname order by count(*) desc limit 1