SELECT Name, COUNT(Sport) as SPORTCOUNT FROM Student GROUP BY Name