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
[{'SportName': 'Athletics', 'count(*)': 1}, {'SportName': 'Baseball', 'count(*)': 1}, {'SportName': 'Basketball', 'count(*)': 1}, {'SportName': 'Cricket', 'count(*)': 1}, {'SportName': 'Curling', 'count(*)': 1}, {'SportName': 'Football', 'count(*)': 2}, {'SportName': 'Lacrosse', 'count(*)': 3}, {'SportName': 'Soccer', 'count(*)': 1}, {'SportName': 'Swimming', 'count(*)': 1}, {'SportName': 'Tennis', 'count(*)': 2}]