what is last name of the members in club?
select t3.lname from club as t1 join member_of_club as t2 on t1.clubid = t2.clubid join student as t3 on t2.stuid = t3.stuid
what is the first name of the student with last name smith?
select fname from student where lname = "Smith"