What is the name of every sport?
select sportname from sportsinfo group by sportname
Of those, which had students on scholarship?
select sportname from sportsinfo where onscholarship = 'Y' group by sportname
Which sport has the most of those students?
select sportname from sportsinfo where onscholarship = 'Y' group by sportname order by count(*) desc limit 1