Show all student IDs with the number of sports and total number of games played
CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INTEGER)
SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Sportsinfo (StuID VARCHAR, gamesplayed INTEGER) Question: Show all student IDs with the number of sports and total number of games played [/INST] SELECT StuID, COUNT(*), SUM(gamesplayed) FROM Sportsinfo GROUP BY StuID </s>