What is the student id of the student with first name "Arthur"?
select stuid from student where fname = "Arthur"
Who is his advisor?
select advisor from student where fname = "Arthur"
Tell me the clubs that have at least a member with advisor "1121".
select distinct 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.advisor = 1121