Could you please show me all the student IDs with the number of sports?
select stuid, count ( * ) from sportsinfo group by stuid
Could you add the total number of games played to that table please?
select stuid, count ( * ), sum ( gamesplayed ) from sportsinfo group by stuid
How many students are on scholarships?
select count ( distinct stuid ) from sportsinfo where onscholarship = "Y"
What is the most common sports name?
select sportname from sportsinfo group by sportname order by count ( * ) desc limit 1
What is the name of the sport the student with the most hours per week played?
select sportname from sportsinfo order by hoursperweek desc limit 1