Tell me Paul's sex.
select sex from student where fname = "Paul"
Tell me the number of clubs where he is a member.
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 t3.fname = "Paul"
What is the number of clubs where "Tracy Kim" is a member?
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 t3.fname = "Tracy" and t3.lname = "Kim"