Show all student IDs with more than total 10 hours per week on all sports played.
CREATE TABLE Sportsinfo (StuID VARCHAR, hoursperweek INTEGER)
SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING SUM(hoursperweek) > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Sportsinfo (StuID VARCHAR, hoursperweek INTEGER) Question: Show all student IDs with more than total 10 hours per week on all sports played. [/INST] SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING SUM(hoursperweek) > 10 </s>