What are the student IDs for every student?
select stuid from sportsinfo group by stuid
Which of those are for students who played more than 10 hours of a week for all sports?
select stuid from sportsinfo group by stuid having sum(hoursperweek) > 10