What information do you have on each sport?
select * from sportsinfo group by sportname
How many students play each one?
select count(*) from sportsinfo group by sportname
Also, what are the names of each sport?
select sportname, count(*) from sportsinfo group by sportname