
CREATE TABLE "match" (
	"Match_ID" INTEGER, 
	"Date" TEXT, 
	"Venue" TEXT, 
	"Score" TEXT, 
	"Result" TEXT, 
	"Competition" TEXT, 
	PRIMARY KEY ("Match_ID")
)


CREATE TABLE city (
	"City_ID" INTEGER, 
	"City" TEXT, 
	"Hanzi" TEXT, 
	"Hanyu_Pinyin" TEXT, 
	"Regional_Population" INTEGER, 
	"GDP" REAL, 
	PRIMARY KEY ("City_ID")
)


CREATE TABLE hosting_city (
	"Year" INTEGER, 
	"Match_ID" INTEGER, 
	"Host_City" TEXT, 
	PRIMARY KEY ("Year"), 
	FOREIGN KEY("Match_ID") REFERENCES "match" ("Match_ID"), 
	FOREIGN KEY("Host_City") REFERENCES city ("City_ID")
)


CREATE TABLE temperature (
	"City_ID" INTEGER, 
	"Jan" REAL, 
	"Feb" REAL, 
	"Mar" REAL, 
	"Apr" REAL, 
	"Jun" REAL, 
	"Jul" REAL, 
	"Aug" REAL, 
	"Sep" REAL, 
	"Oct" REAL, 
	"Nov" REAL, 
	"Dec" REAL, 
	PRIMARY KEY ("City_ID"), 
	FOREIGN KEY("City_ID") REFERENCES city ("City_ID")
)

CREATE TABLE "match" (
	"Match_ID" INTEGER, 
	"Date" TEXT, 
	"Venue" TEXT, 
	"Score" TEXT, 
	"Result" TEXT, 
	"Competition" TEXT, 
	PRIMARY KEY ("Match_ID")
)

/*
2 rows from match table:
Match_ID	Date	Venue	Score	Result	Competition
1	18 February 1992	Estadio Cuscatlán , San Salvador , El Salvador	1-0	2-0	Friendly match
2	19 July 1992	Estadio Rigoberto López , Managua , Nicaragua	3-0	5-0	1994 FIFA World Cup qualification
*/


CREATE TABLE city (
	"City_ID" INTEGER, 
	"City" TEXT, 
	"Hanzi" TEXT, 
	"Hanyu_Pinyin" TEXT, 
	"Regional_Population" INTEGER, 
	"GDP" REAL, 
	PRIMARY KEY ("City_ID")
)

/*
2 rows from city table:
City_ID	City	Hanzi	Hanyu_Pinyin	Regional_Population	GDP
1	Shanghai	上海	Shànghǎi	23019148	1919.57
2	Nanjing ( Jiangsu )	南京	Nánjīng	8004680	614.55
*/


CREATE TABLE hosting_city (
	"Year" INTEGER, 
	"Match_ID" INTEGER, 
	"Host_City" TEXT, 
	PRIMARY KEY ("Year"), 
	FOREIGN KEY("Match_ID") REFERENCES "match" ("Match_ID"), 
	FOREIGN KEY("Host_City") REFERENCES city ("City_ID")
)

/*
2 rows from hosting_city table:
Year	Match_ID	Host_City
2008	1	1
2009	2	2
*/


CREATE TABLE temperature (
	"City_ID" INTEGER, 
	"Jan" REAL, 
	"Feb" REAL, 
	"Mar" REAL, 
	"Apr" REAL, 
	"Jun" REAL, 
	"Jul" REAL, 
	"Aug" REAL, 
	"Sep" REAL, 
	"Oct" REAL, 
	"Nov" REAL, 
	"Dec" REAL, 
	PRIMARY KEY ("City_ID"), 
	FOREIGN KEY("City_ID") REFERENCES city ("City_ID")
)

/*
2 rows from temperature table:
City_ID	Jan	Feb	Mar	Apr	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	17.8	17.8	18.3	18.9	20.0	20.6	20.6	20.6	20.0	19.4	18.3
2	26.1	26.1	26.1	26.1	27.8	27.8	28.3	28.3	28.3	27.2	26.7
*/
What are the venues of all the matches? Sort them in the descending order of match date.
SELECT venue FROM MATCH ORDER BY date DESC
[{'Venue': 'Estadio Cuscatlán , San Salvador , El Salvador'}, {'Venue': 'Estadio Cuscatlán , San Salvador , El Salvador'}, {'Venue': 'Estadio Cuscatlán , San Salvador , El Salvador'}, {'Venue': 'Estadio Cuscatlán , San Salvador , El Salvador'}, {'Venue': 'Estadio Rigoberto López , Managua , Nicaragua'}, {'Venue': 'Estadio Cuscatlán , San Salvador , El Salvador'}]