Which sport has most number of students on scholarship?
create table sportsinfo (sportname varchar, onscholarship varchar, PRIMARY KEY (sportname))
select sportname from sportsinfo where onscholarship = 'y' group by sportname order by count(*) desc limit 1