CREATE TABLE student (stuid DECIMAL, lname TEXT, fname TEXT, age DECIMAL, sex TEXT, major DECIMAL, advisor DECIMAL, city_code TEXT)
CREATE TABLE video_games (gameid DECIMAL, gname TEXT, gtype TEXT)
CREATE TABLE sportsinfo (stuid DECIMAL, sportname TEXT, hoursperweek DECIMAL, gamesplayed DECIMAL, onscholarship TEXT)
CREATE TABLE plays_games (stuid DECIMAL, gameid DECIMAL, hours_played DECIMAL)

Show total hours per week and number of games played for student David Shieber.
SELECT SUM(hoursperweek), SUM(gamesplayed) FROM sportsinfo AS T1 JOIN student AS T2 ON T1.stuid = T2.stuid WHERE T2.fname = "David" AND T2.lname = "Shieber"
SELECT SUM("hoursperweek"), SUM("gamesplayed") FROM "sportsinfo" AS "T1" JOIN "student" AS "T2" ON "David" = "T2"."fname" AND "Shieber" = "T2"."lname" AND "T1"."stuid" = "T2"."stuid"