Tell me the major of the student named "Eric".
select major from student where fname = "Eric"
What club did he join?
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 = "Eric"
How many members does the club "Tennis Club" have?
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"