
CREATE TABLE film (
	"Film_ID" INTEGER, 
	"Title" TEXT, 
	"Studio" TEXT, 
	"Director" TEXT, 
	"Gross_in_dollar" INTEGER, 
	PRIMARY KEY ("Film_ID")
)


CREATE TABLE film_market_estimation (
	"Estimation_ID" INTEGER, 
	"Low_Estimate" REAL, 
	"High_Estimate" REAL, 
	"Film_ID" INTEGER, 
	"Type" TEXT, 
	"Market_ID" INTEGER, 
	"Year" INTEGER, 
	PRIMARY KEY ("Estimation_ID"), 
	FOREIGN KEY("Film_ID") REFERENCES film ("Film_ID"), 
	FOREIGN KEY("Market_ID") REFERENCES market ("Market_ID")
)


CREATE TABLE market (
	"Market_ID" INTEGER, 
	"Country" TEXT, 
	"Number_cities" INTEGER, 
	PRIMARY KEY ("Market_ID")
)

CREATE TABLE film (
	"Film_ID" INTEGER, 
	"Title" TEXT, 
	"Studio" TEXT, 
	"Director" TEXT, 
	"Gross_in_dollar" INTEGER, 
	PRIMARY KEY ("Film_ID")
)

/*
2 rows from film table:
Film_ID	Title	Studio	Director	Gross_in_dollar
1	ET the Extra-Terrestrial	Universal	Steven Spielberg	435110554
2	Tootsie	Columbia	Sydney Pollack	177200000
*/


CREATE TABLE film_market_estimation (
	"Estimation_ID" INTEGER, 
	"Low_Estimate" REAL, 
	"High_Estimate" REAL, 
	"Film_ID" INTEGER, 
	"Type" TEXT, 
	"Market_ID" INTEGER, 
	"Year" INTEGER, 
	PRIMARY KEY ("Estimation_ID"), 
	FOREIGN KEY("Film_ID") REFERENCES film ("Film_ID"), 
	FOREIGN KEY("Market_ID") REFERENCES market ("Market_ID")
)

/*
2 rows from film_market_estimation table:
Estimation_ID	Low_Estimate	High_Estimate	Film_ID	Type	Market_ID	Year
1	80000.0	80400.0	1	Mass suicide murder	1	1945
2	8000.0	8000.0	2	Mass suicide	2	1944
*/


CREATE TABLE market (
	"Market_ID" INTEGER, 
	"Country" TEXT, 
	"Number_cities" INTEGER, 
	PRIMARY KEY ("Market_ID")
)

/*
2 rows from market table:
Market_ID	Country	Number_cities
1	Japan	209
2	China	540
*/
What are the countries for each market ordered by decreasing number of cities?
SELECT Country FROM market ORDER BY Number_cities DESC
[{'Country': 'USA'}, {'Country': 'China'}, {'Country': 'Poland'}, {'Country': 'Russia'}, {'Country': 'France'}, {'Country': 'Japan'}]