Database: game_1
Question: How many students play each sport?
SQL:
SELECT sportname ,  count(*) FROM Sportsinfo GROUP BY sportname