What information is there on all sport players?
select * from sportsinfo
Which of those are on scholarship?
select * from sportsinfo where onscholarship = 'Y'
What are their student ids?
select stuid from sportsinfo where onscholarship = 'Y'