Show all student IDs with the number of sports and total number of games played
create table sportsinfo (stuid varchar, gamesplayed integer, PRIMARY KEY (stuid))
select stuid, count(*), sum(gamesplayed) from sportsinfo group by stuid