For each student, how many sports do they play?
select count(*) from sportsinfo group by stuid
Order the information in descending order by number of sports played.
select count(*) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid group by t1.stuid
What is the first and last name of student who played the most?
select t2.fname, t2.lname from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid group by t1.stuid order by count(*) desc limit 1