How many SportName on scholarship?
select count ( distinct sportname ) from sportsinfo where onscholarship = "Y"
What are these 7 different sports that have student on scholarship?
select distinct sportname from sportsinfo where onscholarship = "Y"
which sport has most number of students on scholarship?
select sportname from sportsinfo where onscholarship = "Y" group by sportname order by count ( * ) desc limit 1