SELECT sportname ,  count(*) FROM Sportsinfo GROUP BY sportname
How many students play each sport?
SELECT sportname , count ( * ) FROM Sportsinfo GROUP BY sportname
select sportname , count ( * ) from sportsinfo group by sportname
How many students play each sport ?