Tell me the age of the student named "Eric Tai".
select age from student where fname = "Eric" and lname = "Tai"
How about his advisor?
select advisor from student where fname = "Eric" and lname = "Tai"
How many clubs does the student named "Eric Tai" belong to?
select count(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.fname = "Eric" and t3.lname = "Tai"