
CREATE TABLE "Plays_Games" (
	"StuID" INTEGER, 
	"GameID" INTEGER, 
	"Hours_Played" INTEGER, 
	FOREIGN KEY("GameID") REFERENCES "Video_Games" ("GameID"), 
	FOREIGN KEY("StuID") REFERENCES "Student" ("StuID")
)


CREATE TABLE "SportsInfo" (
	"StuID" INTEGER, 
	"SportName" VARCHAR(32), 
	"HoursPerWeek" INTEGER, 
	"GamesPlayed" INTEGER, 
	"OnScholarship" VARCHAR(1), 
	FOREIGN KEY("StuID") REFERENCES "Student" ("StuID")
)


CREATE TABLE "Student" (
	"StuID" INTEGER, 
	"LName" VARCHAR(12), 
	"Fname" VARCHAR(12), 
	"Age" INTEGER, 
	"Sex" VARCHAR(1), 
	"Major" INTEGER, 
	"Advisor" INTEGER, 
	city_code VARCHAR(3), 
	PRIMARY KEY ("StuID")
)


CREATE TABLE "Video_Games" (
	"GameID" INTEGER, 
	"GName" VARCHAR(40), 
	"GType" VARCHAR(40), 
	PRIMARY KEY ("GameID")
)

CREATE TABLE "Plays_Games" (
	"StuID" INTEGER, 
	"GameID" INTEGER, 
	"Hours_Played" INTEGER, 
	FOREIGN KEY("GameID") REFERENCES "Video_Games" ("GameID"), 
	FOREIGN KEY("StuID") REFERENCES "Student" ("StuID")
)

/*
2 rows from Plays_Games table:
StuID	GameID	Hours_Played
1001	1	35
1001	2	15
*/


CREATE TABLE "SportsInfo" (
	"StuID" INTEGER, 
	"SportName" VARCHAR(32), 
	"HoursPerWeek" INTEGER, 
	"GamesPlayed" INTEGER, 
	"OnScholarship" VARCHAR(1), 
	FOREIGN KEY("StuID") REFERENCES "Student" ("StuID")
)

/*
2 rows from SportsInfo table:
StuID	SportName	HoursPerWeek	GamesPlayed	OnScholarship
1001	Athletics	2	5	N
1002	Football	7	20	Y
*/


CREATE TABLE "Student" (
	"StuID" INTEGER, 
	"LName" VARCHAR(12), 
	"Fname" VARCHAR(12), 
	"Age" INTEGER, 
	"Sex" VARCHAR(1), 
	"Major" INTEGER, 
	"Advisor" INTEGER, 
	city_code VARCHAR(3), 
	PRIMARY KEY ("StuID")
)

/*
2 rows from Student table:
StuID	LName	Fname	Age	Sex	Major	Advisor	city_code
1001	Smith	Linda	18	F	600	1121	BAL
1002	Kim	Tracy	19	F	600	7712	HKG
*/


CREATE TABLE "Video_Games" (
	"GameID" INTEGER, 
	"GName" VARCHAR(40), 
	"GType" VARCHAR(40), 
	PRIMARY KEY ("GameID")
)

/*
2 rows from Video_Games table:
GameID	GName	GType
1	RNG Stone	Collectible card game
2	The Vanishing of Eric Calder	Walking Simulator
*/
Show student ids who don't have any sports.
SELECT StuID FROM Student EXCEPT SELECT StuID FROM Sportsinfo
[{'StuID': 1004}, {'StuID': 1006}, {'StuID': 1007}, {'StuID': 1008}, {'StuID': 1009}, {'StuID': 1010}, {'StuID': 1011}, {'StuID': 1012}, {'StuID': 1014}, {'StuID': 1016}, {'StuID': 1017}, {'StuID': 1020}, {'StuID': 1021}, {'StuID': 1024}, {'StuID': 1025}, {'StuID': 1027}, {'StuID': 1028}, {'StuID': 1029}, {'StuID': 1030}, {'StuID': 1031}, {'StuID': 1032}, {'StuID': 1034}]