Tell me the advisor of "Linda Smith".
select advisor from student where lname = "Smith" and fname = "Linda"
Tell me her age.
select age from student where lname = "Smith" and fname = "Linda"
How many clubs does "Linda Smith" belong to?
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 = "Linda" and t3.lname = "Smith"