Yes, total hours
select sum ( hoursperweek ) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t2.fname = "David" and t2.lname = "Shieber"
What are the total number of games he played?
select sum ( gamesplayed ) from sportsinfo as t1 join student as t2 on t1.stuid = t2.stuid where t2.fname = "David" and t2.lname = "Shieber"
What are the first and last names of the student who played the most total hours per week?
select fname, lname from student where stuid = ( select stuid from sportsinfo group by stuid order by sum ( hoursperweek ) desc limit 1 )
How many total games did she play?
select sum ( gamesplayed ) from sportsinfo group by stuid order by sum ( hoursperweek ) desc limit 1