What information is there on all students who play sports?
select * from sportsinfo
Which subset of this information is for students on scholarships?
select * from sportsinfo where onscholarship = 'Y'
What are their last names?
select t2.lname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'