
CREATE TABLE "Cartoon" (
	id REAL, 
	"Title" TEXT, 
	"Directed_by" TEXT, 
	"Written_by" TEXT, 
	"Original_air_date" TEXT, 
	"Production_code" REAL, 
	"Channel" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY("Channel") REFERENCES "TV_Channel" (id)
)


CREATE TABLE "TV_Channel" (
	id TEXT, 
	series_name TEXT, 
	"Country" TEXT, 
	"Language" TEXT, 
	"Content" TEXT, 
	"Pixel_aspect_ratio_PAR" TEXT, 
	"Hight_definition_TV" TEXT, 
	"Pay_per_view_PPV" TEXT, 
	"Package_Option" TEXT, 
	PRIMARY KEY (id)
)


CREATE TABLE "TV_series" (
	id REAL, 
	"Episode" TEXT, 
	"Air_Date" TEXT, 
	"Rating" TEXT, 
	"Share" REAL, 
	"18_49_Rating_Share" TEXT, 
	"Viewers_m" TEXT, 
	"Weekly_Rank" REAL, 
	"Channel" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY("Channel") REFERENCES "TV_Channel" (id)
)

CREATE TABLE "Cartoon" (
	id REAL, 
	"Title" TEXT, 
	"Directed_by" TEXT, 
	"Written_by" TEXT, 
	"Original_air_date" TEXT, 
	"Production_code" REAL, 
	"Channel" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY("Channel") REFERENCES "TV_Channel" (id)
)

/*
2 rows from Cartoon table:
id	Title	Directed_by	Written_by	Original_air_date	Production_code	Channel
1.0	The Rise of the Blue Beetle!	Ben Jones	Michael Jelenic	November14,2008	101.0	700
2.0	Terror on Dinosaur Island!	Brandon Vietti	Steven Melching	November21,2008	102.0	701
*/


CREATE TABLE "TV_Channel" (
	id TEXT, 
	series_name TEXT, 
	"Country" TEXT, 
	"Language" TEXT, 
	"Content" TEXT, 
	"Pixel_aspect_ratio_PAR" TEXT, 
	"Hight_definition_TV" TEXT, 
	"Pay_per_view_PPV" TEXT, 
	"Package_Option" TEXT, 
	PRIMARY KEY (id)
)

/*
2 rows from TV_Channel table:
id	series_name	Country	Language	Content	Pixel_aspect_ratio_PAR	Hight_definition_TV	Pay_per_view_PPV	Package_Option
700	Sky Radio	Italy	Italian	music	4:3	no	no	Sky Famiglia
701	Sky Music	Italy	Italian	music	4:3	no	no	Sky Famiglia
*/


CREATE TABLE "TV_series" (
	id REAL, 
	"Episode" TEXT, 
	"Air_Date" TEXT, 
	"Rating" TEXT, 
	"Share" REAL, 
	"18_49_Rating_Share" TEXT, 
	"Viewers_m" TEXT, 
	"Weekly_Rank" REAL, 
	"Channel" TEXT, 
	PRIMARY KEY (id), 
	FOREIGN KEY("Channel") REFERENCES "TV_Channel" (id)
)

/*
2 rows from TV_series table:
id	Episode	Air_Date	Rating	Share	18_49_Rating_Share	Viewers_m	Weekly_Rank	Channel
1.0	A Love of a Lifetime	September 24, 2007	5.8	9.0	3.5/9	9.16	43.0	700
2.0	Friendly Skies	October 1, 2007	5.3	9.0	3.2/8	8.23	50.0	701
*/
List the title of all cartoon directed by "Ben Jones" or "Brandon Vietti".
SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones" OR Directed_by = "Brandon Vietti";
[{'Title': 'The Rise of the Blue Beetle!'}, {'Title': 'Terror on Dinosaur Island!'}, {'Title': 'Day of the Dark Knight!'}, {'Title': 'Invasion of the Secret Santas!'}, {'Title': 'Dawn of the Dead Man!'}, {'Title': 'Fall of the Blue Beetle!'}, {'Title': 'The Eyes of Despero!'}, {'Title': 'Return of the Fearsome Fangs!'}]