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
Which of those were just football?
select stuid from sportsinfo where sportname = 'Football'
What's the average hours per week all students played football?
select avg ( hoursperweek ) from sportsinfo where sportname = 'Football'
What's the average hours per week all students played athletics?
select avg ( hoursperweek ) from sportsinfo
What are all sports names?
select distinct sportname from sportsinfo
What's the average hours per week all students played Lacrosse?
select avg ( hoursperweek ) from sportsinfo where sportname = 'Lacrosse'
What are the student IDs of those students?
select stuid from sportsinfo