SELECT sportname FROM Sportsinfo WHERE onscholarship  =  'Y' GROUP BY sportname ORDER BY count(*) DESC LIMIT 1
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
select sportname from sportsinfo where onscholarship = value group by sportname order by count ( * ) desc limit value
Which sport has most number of students on scholarship ?