SELECT sportname ,  count(*) FROM Sportsinfo GROUP BY sportname
Show all sport name and the number of students.
SELECT sportname , count ( * ) FROM Sportsinfo GROUP BY sportname
select sportname , count ( * ) from sportsinfo group by sportname
Show all sport name and the number of students .