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.
SQL: SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING SUM(hoursperweek) > 10