
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
*/
Give me a list of cities whose temperature in Feb is higher than that in Jun or cities that were once host cities?
SELECT T1.city FROM city AS T1 JOIN temperature AS T2 ON T1.city_id  =  T2.city_id WHERE T2.Feb  >  T2.Jun UNION SELECT T3.city FROM city AS T3 JOIN hosting_city AS T4 ON T3.city_id  =  T4.host_city
[{'City': 'Jiaxing ( Zhejiang )'}, {'City': 'Nanjing ( Jiangsu )'}, {'City': 'Shanghai'}, {'City': 'Taizhou ( Zhejiang )'}, {'City': 'Wuxi ( Jiangsu )'}]