How many students are on scholarship?
select count ( * ) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'
What are the last names for those students?
select t2.lname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'
What are their first names?
select t2.fname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'
What are their majors?
select t2.major from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'
What sport name do they play?
select t1.sportname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t1.onscholarship = 'Y'