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

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" "T1" JOIN "student" "T2" ON "David" = "T2"."fname" AND "Shieber" = "T2"."lname" AND "T1"."stuid" = "T2"."stuid"