CREATE TABLE Sportsinfo (StuID VARCHAR2, hoursperweek NUMBER)

Show all student IDs with more than total 10 hours per week on all sports played.
SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING SUM(hoursperweek) > 10
SELECT "StuID" FROM "Sportsinfo" GROUP BY "StuID" HAVING SUM("hoursperweek") > 10