How many students play each sport?
select sportname, count(*) from sportsinfo group by sportname