
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)
*/
What is the list of program names, sorted by the order of launch date?
SELECT name FROM program ORDER BY launch
[{'Name': 'Kaku'}, {'Name': 'Aniworld'}, {'Name': 'Toonmax'}, {'Name': 'Jiajia'}, {'Name': 'Youman'}]