CREATE TABLE Student (StuID VARCHAR2, Fname VARCHAR2, Lname VARCHAR2)
CREATE TABLE Sportsinfo (StuID VARCHAR2)

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"