Show all student IDs with more than total 10 hours per week on all sports played.
CREATE TABLE Sportsinfo (StuID VARCHAR, hoursperweek INTEGER)
[SQL] SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING SUM(hoursperweek) > 10 [/SQL]