
CREATE TABLE broadcast (
	"Channel_ID" INTEGER, 
	"Program_ID" INTEGER, 
	"Time_of_day" TEXT, 
	PRIMARY KEY ("Channel_ID", "Program_ID"), 
	FOREIGN KEY("Program_ID") REFERENCES program ("Program_ID"), 
	FOREIGN KEY("Channel_ID") REFERENCES channel ("Channel_ID")
)


CREATE TABLE broadcast_share (
	"Channel_ID" INTEGER, 
	"Program_ID" INTEGER, 
	"Date" TEXT, 
	"Share_in_percent" REAL, 
	PRIMARY KEY ("Channel_ID", "Program_ID"), 
	FOREIGN KEY("Program_ID") REFERENCES program ("Program_ID"), 
	FOREIGN KEY("Channel_ID") REFERENCES channel ("Channel_ID")
)


CREATE TABLE channel (
	"Channel_ID" INTEGER, 
	"Name" TEXT, 
	"Owner" TEXT, 
	"Share_in_percent" REAL, 
	"Rating_in_percent" REAL, 
	PRIMARY KEY ("Channel_ID")
)


CREATE TABLE program (
	"Program_ID" INTEGER, 
	"Name" TEXT, 
	"Origin" TEXT, 
	"Launch" REAL, 
	"Owner" TEXT, 
	PRIMARY KEY ("Program_ID")
)

CREATE TABLE broadcast (
	"Channel_ID" INTEGER, 
	"Program_ID" INTEGER, 
	"Time_of_day" TEXT, 
	PRIMARY KEY ("Channel_ID", "Program_ID"), 
	FOREIGN KEY("Program_ID") REFERENCES program ("Program_ID"), 
	FOREIGN KEY("Channel_ID") REFERENCES channel ("Channel_ID")
)

/*
2 rows from broadcast table:
Channel_ID	Program_ID	Time_of_day
1	1	Morning
2	1	Night
*/


CREATE TABLE broadcast_share (
	"Channel_ID" INTEGER, 
	"Program_ID" INTEGER, 
	"Date" TEXT, 
	"Share_in_percent" REAL, 
	PRIMARY KEY ("Channel_ID", "Program_ID"), 
	FOREIGN KEY("Program_ID") REFERENCES program ("Program_ID"), 
	FOREIGN KEY("Channel_ID") REFERENCES channel ("Channel_ID")
)

/*
2 rows from broadcast_share table:
Channel_ID	Program_ID	Date	Share_in_percent
1	1	01,May	3.1
2	1	02,May	1.8
*/


CREATE TABLE channel (
	"Channel_ID" INTEGER, 
	"Name" TEXT, 
	"Owner" TEXT, 
	"Share_in_percent" REAL, 
	"Rating_in_percent" REAL, 
	PRIMARY KEY ("Channel_ID")
)

/*
2 rows from channel table:
Channel_ID	Name	Owner	Share_in_percent	Rating_in_percent
1	CCTV-1	CCTV	4.9	0.54
2	Hunan Satellite TV	HBS	4.81	0.53
*/


CREATE TABLE program (
	"Program_ID" INTEGER, 
	"Name" TEXT, 
	"Origin" TEXT, 
	"Launch" REAL, 
	"Owner" TEXT, 
	PRIMARY KEY ("Program_ID")
)

/*
2 rows from program table:
Program_ID	Name	Origin	Launch	Owner
1	Aniworld	Hunan	2005.0	Hunan Broadcasting System (HBS)
2	Kaku	Beijing	2004.0	Beijing Television (BTV)
*/
Which programs are never broadcasted in the morning? Give me the names of the programs.
SELECT name FROM program EXCEPT SELECT t1.name FROM program AS t1 JOIN broadcast AS t2 ON t1.program_id  =  t2.program_id WHERE t2.Time_of_day  =  "Morning"
[{'Name': 'Youman'}]