Tell me the first names of students whose advisor is 1121.
select fname from student where advisor = 1121
Tell me the last names of students whose major is 600.
select lname from student where major = 600
Tell me which club has the most members majoring in "600".
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.major = "600" group by t1.clubname order by count(*) desc limit 1