Show all student IDs with more than a total of 10 hours per week on all sports played please.
SELECT StuID FROM Sportsinfo GROUP BY StuID HAVING sum ( hoursperweek )  > 10
Show all student IDs with more than a total of 10 hours per week on all sports played refers to selecting student IDs (StuID) from a table (Sportsinfo) where the sum of hours per week spent on sports (hoursperweek) is greater than 10;