
CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from city table:
ID	Name	CountryCode	District	Population
1	Kabul	AFG	Kabol	1780000
2	Qandahar	AFG	Qandahar	237500
*/


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)

/*
2 rows from country table:
Code	Name	Continent	Region	SurfaceArea	IndepYear	Population	LifeExpectancy	GNP	GNPOld	LocalName	GovernmentForm	HeadOfState	Capital	Code2
ABW	Aruba	North America	Caribbean	193.0000000000	None	103000	78.4000000000	828.0000000000	793.0000000000	Aruba	Nonmetropolitan Territory of The Netherlands	Beatrix	129	AW
AFG	Afghanistan	Asia	Southern and Central Asia	652090.0000000000	1919	22720000	45.9000000000	5976.0000000000	None	Afganistan/Afqanestan	Islamic Emirate	Mohammad Omar	1	AF
*/


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from countrylanguage table:
CountryCode	Language	IsOfficial	Percentage
ABW	Dutch	T	5.3000000000
ABW	English	F	9.5000000000
*/
How many cities in each district have a population that is above the average population across all cities?
SELECT count(*) ,  District FROM city WHERE Population  >  (SELECT avg(Population) FROM city) GROUP BY District
[{'count(*)': 1, 'District': 'Abidjan'}, {'count(*)': 1, 'District': 'Abu Dhabi'}, {'count(*)': 1, 'District': 'Adana'}, {'count(*)': 1, 'District': 'Addis Abeba'}, {'count(*)': 1, 'District': 'Aden'}, {'count(*)': 1, 'District': 'Aguascalientes'}, {'count(*)': 1, 'District': 'Ahal'}, {'count(*)': 2, 'District': 'Aichi'}, {'count(*)': 1, 'District': 'Alagoas'}, {'count(*)': 2, 'District': 'Alberta'}, {'count(*)': 1, 'District': 'Aleksandria'}, {'count(*)': 1, 'District': 'Aleppo'}, {'count(*)': 1, 'District': 'Alger'}, {'count(*)': 1, 'District': 'Almaty Qalasy'}, {'count(*)': 1, 'District': 'Altai'}, {'count(*)': 1, 'District': 'Amazonas'}, {'count(*)': 1, 'District': 'Amman'}, {'count(*)': 1, 'District': 'Anambra & Enugu & Eb'}, {'count(*)': 2, 'District': 'Andalusia'}, {'count(*)': 5, 'District': 'Andhra Pradesh'}, {'count(*)': 5, 'District': 'Anhui'}, {'count(*)': 1, 'District': 'Ankara'}, {'count(*)': 1, 'District': 'Antalya'}, {'count(*)': 1, 'District': 'Antananarivo'}, {'count(*)': 1, 'District': 'Antioquia'}, {'count(*)': 1, 'District': 'Antwerpen'}, {'count(*)': 1, 'District': 'Aragonia'}, {'count(*)': 1, 'District': 'Aragua'}, {'count(*)': 1, 'District': 'Arequipa'}, {'count(*)': 3, 'District': 'Arizona'}, {'count(*)': 1, 'District': 'Arkangeli'}, {'count(*)': 1, 'District': 'Ashanti'}, {'count(*)': 1, 'District': 'Assam'}, {'count(*)': 1, 'District': 'Astrahan'}, {'count(*)': 1, 'District': 'Asunción'}, {'count(*)': 1, 'District': 'Atlantique'}, {'count(*)': 1, 'District': 'Atlántico'}, {'count(*)': 1, 'District': 'Attika'}, {'count(*)': 1, 'District': 'Auckland'}, {'count(*)': 1, 'District': 'Baden-Württemberg'}, {'count(*)': 1, 'District': 'Baghdad'}, {'count(*)': 2, 'District': 'Bahia'}, {'count(*)': 2, 'District': 'Baijeri'}, {'count(*)': 3, 'District': 'Baja California'}, {'count(*)': 1, 'District': 'Baki'}, {'count(*)': 1, 'District': 'Bali'}, {'count(*)': 1, 'District': 'Baluchistan'}, {'count(*)': 1, 'District': 'Bamako'}, {'count(*)': 1, 'District': 'Banaadir'}, {'count(*)': 1, 'District': 'Bangkok'}, {'count(*)': 1, 'District': 'Bangui'}, {'count(*)': 1, 'District': 'Baskimaa'}, {'count(*)': 1, 'District': 'Basra'}, {'count(*)': 1, 'District': 'Baškortostan'}, {'count(*)': 1, 'District': 'Beirut'}, {'count(*)': 1, 'District': 'Bengasi'}, {'count(*)': 1, 'District': 'Berliini'}, {'count(*)': 1, 'District': 'Bihar'}, {'count(*)': 1, 'District': 'Bishkek shaary'}, {'count(*)': 1, 'District': 'Blantyre'}, {'count(*)': 2, 'District': 'Bolívar'}, {'count(*)': 1, 'District': 'Bratislava'}, {'count(*)': 1, 'District': 'Brazzaville'}, {'count(*)': 1, 'District': 'Bremen'}, {'count(*)': 1, 'District': 'British Colombia'}, {'count(*)': 1, 'District': 'Brjansk'}, {'count(*)': 1, 'District': 'Budapest'}, {'count(*)': 12, 'District': 'Buenos Aires'}, {'count(*)': 1, 'District': 'Bukarest'}, {'count(*)': 1, 'District': 'Bulawayo'}, {'count(*)': 1, 'District': 'Burjatia'}, {'count(*)': 1, 'District': 'Bursa'}, {'count(*)': 8, 'District': 'California'}, {'count(*)': 1, 'District': 'Callao'}, {'count(*)': 1, 'District': 'Campania'}, {'count(*)': 1, 'District': 'Canary Islands'}, {'count(*)': 2, 'District': 'Cap-Vert'}, {'count(*)': 1, 'District': 'Carabobo'}, {'count(*)': 1, 'District': 'Casablanca'}, {'count(*)': 1, 'District': 'Ceará'}, {'count(*)': 2, 'District': 'Central'}, {'count(*)': 2, 'District': 'Central Java'}, {'count(*)': 1, 'District': 'Central Macedonia'}, {'count(*)': 1, 'District': 'Central Serbia'}, {'count(*)': 1, 'District': 'Central Visayas'}, {'count(*)': 1, 'District': 'Centre'}, {'count(*)': 1, 'District': 'Chandigarh'}, {'count(*)': 1, 'District': 'Chari-Baguirmi'}, {'count(*)': 2, 'District': 'Chhatisgarh'}, {'count(*)': 1, 'District': 'Chiapas'}, {'count(*)': 4, 'District': 'Chiba'}, {'count(*)': 2, 'District': 'Chihuahua'}, {'count(*)': 1, 'District': 'Chisinau'}, {'count(*)': 1, 'District': 'Chittagong'}, {'count(*)': 1, 'District': 'Chollabuk'}, {'count(*)': 1, 'District': 'Chongqing'}, {'count(*)': 1, 'District': 'Chungchongbuk'}, {'count(*)': 2, 'District': 'Coahuila de Zaragoza'}, {'count(*)': 1, 'District': 'Coast'}, {'count(*)': 1, 'District': 'Cochabamba'}, {'count(*)': 2, 'District': 'Colorado'}, {'count(*)': 1, 'District': 'Conakry'}, {'count(*)': 1, 'District': 'Constantine'}, {'count(*)': 1, 'District': 'Cortés'}, {'count(*)': 1, 'District': 'Córdoba'}, {'count(*)': 1, 'District': 'Damascus'}, {'count(*)': 1, 'District': 'Dar es Salaam'}, {'count(*)': 1, 'District': 'Delhi'}, {'count(*)': 1, 'District': 'Dhaka'}, {'count(*)': 1, 'District': 'District of Columbia'}, {'count(*)': 1, 'District': 'Distrito Central'}, {'count(*)': 4, 'District': 'Distrito Federal'}, {'count(*)': 1, 'District': 'Distrito Nacional'}, {'count(*)': 1, 'District': 'Diyarbakir'}, {'count(*)': 1, 'District': 'Djibouti'}, {'count(*)': 2, 'District': 'Dnipropetrovsk'}, {'count(*)': 1, 'District': 'Doha'}, {'count(*)': 1, 'District': 'Dolnoslaskie'}, {'count(*)': 3, 'District': 'Donetsk'}, {'count(*)': 1, 'District': 'Dubai'}, {'count(*)': 1, 'District': 'Durango'}, {'count(*)': 1, 'District': 'East Azerbaidzan'}, {'count(*)': 2, 'District': 'East Java'}, {'count(*)': 1, 'District': 'East Kasai'}, {'count(*)': 1, 'District': 'Eastern Cape'}, {'count(*)': 1, 'District': 'Ehime'}, {'count(*)': 1, 'District': 'Emilia-Romagna'}, {'count(*)': 7, 'District': 'England'}, {'count(*)': 1, 'District': 'Esfahan'}, {'count(*)': 1, 'District': 'Eskisehir'}, {'count(*)': 1, 'District': 'Estuaire'}, {'count(*)': 1, 'District': 'Fars'}, {'count(*)': 1, 'District': 'Federaatio'}, {'count(*)': 2, 'District': 'Florida'}, {'count(*)': 2, 'District': 'Fujian'}, {'count(*)': 2, 'District': 'Fukuoka'}, {'count(*)': 1, 'District': 'Fukushima'}, {'count(*)': 1, 'District': 'Fès-Boulemane'}, {'count(*)': 1, 'District': 'Gansu'}, {'count(*)': 7, 'District': 'Gauteng'}, {'count(*)': 1, 'District': 'Gaza'}, {'count(*)': 1, 'District': 'Gaziantep'}, {'count(*)': 1, 'District': 'Georgia'}, {'count(*)': 1, 'District': 'Gifu'}, {'count(*)': 1, 'District': 'Gilan'}, {'count(*)': 1, 'District': 'Giza'}, {'count(*)': 1, 'District': 'Goiás'}, {'count(*)': 1, 'District': 'Gomel'}, {'count(*)': 1, 'District': 'Grad Sofija'}, {'count(*)': 1, 'District': 'Grad Zagreb'}, {'count(*)': 1, 'District': 'Greater Accra'}, {'count(*)': 3, 'District': 'Guanajuato'}, {'count(*)': 4, 'District': 'Guangdong'}, {'count(*)': 3, 'District': 'Guangxi'}, {'count(*)': 1, 'District': 'Guatemala'}, {'count(*)': 1, 'District': 'Guayas'}, {'count(*)': 1, 'District': 'Guerrero'}, {'count(*)': 2, 'District': 'Guizhou'}, {'count(*)': 5, 'District': 'Gujarat'}, {'count(*)': 1, 'District': 'Habarovsk'}, {'count(*)': 1, 'District': 'Hainan'}, {'count(*)': 1, 'District': 'Haiphong'}, {'count(*)': 1, 'District': 'Hamadan'}, {'count(*)': 1, 'District': 'Hamburg'}, {'count(*)': 1, 'District': 'Hamgyong N'}, {'count(*)': 1, 'District': 'Hamgyong P'}, {'count(*)': 1, 'District': 'Hanoi'}, {'count(*)': 1, 'District': 'Harare'}, {'count(*)': 1, 'District': 'Harjumaa'}, {'count(*)': 1, 'District': 'Harkova'}, {'count(*)': 1, 'District': 'Haryana'}, {'count(*)': 1, 'District': 'Haute-Zaïre'}, {'count(*)': 1, 'District': 'Hawaii'}, {'count(*)': 6, 'District': 'Hebei'}, {'count(*)': 9, 'District': 'Heilongjiang'}, {'count(*)': 7, 'District': 'Henan'}, {'count(*)': 1, 'District': 'Herson'}, {'count(*)': 1, 'District': 'Hessen'}, {'count(*)': 1, 'District': 'Hims'}, {'count(*)': 2, 'District': 'Hiroshima'}, {'count(*)': 1, 'District': 'Hlavní mesto Praha'}, {'count(*)': 1, 'District': 'Ho Chi Minh City'}, {'count(*)': 2, 'District': 'Hokkaido'}, {'count(*)': 1, 'District': 'Hongkong'}, {'count(*)': 1, 'District': 'Horad Minsk'}, {'count(*)': 1, 'District': 'Hsinchu'}, {'count(*)': 4, 'District': 'Hubei'}, {'count(*)': 4, 'District': 'Hunan'}, {'count(*)': 4, 'District': 'Hyogo'}, {'count(*)': 1, 'District': 'Illinois'}, {'count(*)': 1, 'District': 'Inchon'}, {'count(*)': 1, 'District': 'Indiana'}, {'count(*)': 3, 'District': 'Inner Mongolia'}, {'count(*)': 1, 'District': 'Irbil'}, {'count(*)': 1, 'District': 'Irkutsk'}, {'count(*)': 1, 'District': 'Ishikawa'}, {'count(*)': 1, 'District': 'Islamabad'}, {'count(*)': 1, 'District': 'Istanbul'}, {'count(*)': 1, 'District': 'Ivanovo'}, {'count(*)': 1, 'District': 'Izmir'}, {'count(*)': 1, 'District': 'Içel'}, {'count(*)': 1, 'District': 'Jakarta Raya'}, {'count(*)': 3, 'District': 'Jalisco'}, {'count(*)': 1, 'District': 'Jambi'}, {'count(*)': 1, 'District': 'Jammu and Kashmir'}, {'count(*)': 1, 'District': 'Jaroslavl'}, {'count(*)': 1, 'District': 'Jerusalem'}, {'count(*)': 2, 'District': 'Jharkhand'}, {'count(*)': 7, 'District': 'Jiangsu'}, {'count(*)': 2, 'District': 'Jiangxi'}, {'count(*)': 4, 'District': 'Jilin'}, {'count(*)': 1, 'District': 'Jizní Morava'}, {'count(*)': 1, 'District': 'Kabol'}, {'count(*)': 1, 'District': 'Kadiogo'}, {'count(*)': 1, 'District': 'Kaduna'}, {'count(*)': 1, 'District': 'Kagoshima'}, {'count(*)': 1, 'District': 'Kairo'}, {'count(*)': 1, 'District': 'Kalimantan Barat'}, {'count(*)': 1, 'District': 'Kalimantan Selatan'}, {'count(*)': 1, 'District': 'Kalimantan Timur'}, {'count(*)': 1, 'District': 'Kaliningrad'}, {'count(*)': 5, 'District': 'Kanagawa'}, {'count(*)': 1, 'District': 'Kano & Jigawa'}, {'count(*)': 1, 'District': 'Kaohsiung'}, {'count(*)': 3, 'District': 'Karnataka'}, {'count(*)': 1, 'District': 'Karotegin'}, {'count(*)': 1, 'District': 'Katalonia'}, {'count(*)': 1, 'District': 'Kaunas'}, {'count(*)': 1, 'District': 'Kayseri'}, {'count(*)': 1, 'District': 'Keelung'}, {'count(*)': 2, 'District': 'Kemerovo'}, {'count(*)': 3, 'District': 'Kerala'}, {'count(*)': 1, 'District': 'Kerman'}, {'count(*)': 1, 'District': 'Kermanshah'}, {'count(*)': 3, 'District': 'Khartum'}, {'count(*)': 1, 'District': 'Khorasan'}, {'count(*)': 1, 'District': 'Khulna'}, {'count(*)': 1, 'District': 'Khuzestan'}, {'count(*)': 1, 'District': 'Kinshasa'}, {'count(*)': 1, 'District': 'Kiova'}, {'count(*)': 1, 'District': 'Kirov'}, {'count(*)': 1, 'District': 'Konya'}, {'count(*)': 1, 'District': 'Kouilou'}, {'count(*)': 1, 'District': 'Kowloon and New Kowl'}, {'count(*)': 2, 'District': 'Krasnodar'}, {'count(*)': 1, 'District': 'Krasnojarsk'}, {'count(*)': 1, 'District': 'Kujawsko-Pomorskie'}, {'count(*)': 1, 'District': 'Kumamoto'}, {'count(*)': 1, 'District': 'Kurgan'}, {'count(*)': 1, 'District': 'Kursk'}, {'count(*)': 4, 'District': 'KwaZulu-Natal'}, {'count(*)': 1, 'District': 'Kwangju'}, {'count(*)': 1, 'District': 'Kwara & Kogi'}, {'count(*)': 7, 'District': 'Kyonggi'}, {'count(*)': 1, 'District': 'Kyongsangbuk'}, {'count(*)': 3, 'District': 'Kyongsangnam'}, {'count(*)': 1, 'District': 'Kyoto'}, {'count(*)': 1, 'District': 'København'}, {'count(*)': 1, 'District': 'La Habana'}, {'count(*)': 1, 'District': 'La Libertad'}, {'count(*)': 2, 'District': 'La Paz'}, {'count(*)': 1, 'District': 'Lagos'}, {'count(*)': 1, 'District': 'Lambayeque'}, {'count(*)': 1, 'District': 'Lampung'}, {'count(*)': 1, 'District': 'Lara'}, {'count(*)': 1, 'District': 'Latium'}, {'count(*)': 1, 'District': 'Leinster'}, {'count(*)': 12, 'District': 'Liaoning'}, {'count(*)': 1, 'District': 'Liguria'}, {'count(*)': 1, 'District': 'Lilongwe'}, {'count(*)': 1, 'District': 'Lima'}, {'count(*)': 1, 'District': 'Lipetsk'}, {'count(*)': 2, 'District': 'Lisboa'}, {'count(*)': 1, 'District': 'Littoral'}, {'count(*)': 1, 'District': 'Lodzkie'}, {'count(*)': 1, 'District': 'Lombardia'}, {'count(*)': 1, 'District': 'Loreto'}, {'count(*)': 1, 'District': 'Louisiana'}, {'count(*)': 1, 'District': 'Luanda'}, {'count(*)': 1, 'District': 'Lubelskie'}, {'count(*)': 1, 'District': 'Lugansk'}, {'count(*)': 1, 'District': 'Lusaka'}, {'count(*)': 1, 'District': 'Luxor'}, {'count(*)': 1, 'District': 'Lviv'}, {'count(*)': 1, 'District': 'Macau'}, {'count(*)': 5, 'District': 'Madhya Pradesh'}, {'count(*)': 1, 'District': 'Madrid'}, {'count(*)': 1, 'District': 'Maekel'}, {'count(*)': 1, 'District': 'Magdalena'}, {'count(*)': 13, 'District': 'Maharashtra'}, {'count(*)': 1, 'District': 'Malopolskie'}, {'count(*)': 1, 'District': 'Managua'}, {'count(*)': 1, 'District': 'Mandalay'}, {'count(*)': 1, 'District': 'Manitoba'}, {'count(*)': 2, 'District': 'Maputo'}, {'count(*)': 1, 'District': 'Maranhão'}, {'count(*)': 1, 'District': 'Maritime'}, {'count(*)': 1, 'District': 'Markazi'}, {'count(*)': 1, 'District': 'Marrakech-Tensift-Al'}, {'count(*)': 1, 'District': 'Maryland'}, {'count(*)': 1, 'District': 'Massachusetts'}, {'count(*)': 1, 'District': 'Mato Grosso'}, {'count(*)': 1, 'District': 'Mato Grosso do Sul'}, {'count(*)': 1, 'District': 'Mazowieckie'}, {'count(*)': 1, 'District': 'Medina'}, {'count(*)': 3, 'District': 'Mekka'}, {'count(*)': 1, 'District': 'Meknès-Tafilalet'}, {'count(*)': 1, 'District': 'Michigan'}, {'count(*)': 1, 'District': 'Michoacán de Ocampo'}, {'count(*)': 1, 'District': 'Midi-Pyrénées'}, {'count(*)': 4, 'District': 'Minas Gerais'}, {'count(*)': 1, 'District': 'Minnesota'}, {'count(*)': 1, 'District': 'Miranda'}, {'count(*)': 1, 'District': 'Missouri'}, {'count(*)': 1, 'District': 'Miyagi'}, {'count(*)': 1, 'District': 'Mogiljov'}, {'count(*)': 1, 'District': 'Montevideo'}, {'count(*)': 1, 'District': 'Montserrado'}, {'count(*)': 1, 'District': 'Moscow (City)'}, {'count(*)': 1, 'District': 'Murcia'}, {'count(*)': 1, 'District': 'Murmansk'}, {'count(*)': 1, 'District': 'Mykolajiv'}, {'count(*)': 9, 'District': 'México'}, {'count(*)': 1, 'District': 'Nagano'}, {'count(*)': 1, 'District': 'Nagasaki'}, {'count(*)': 1, 'District': 'Nairobi'}, {'count(*)': 1, 'District': 'Namangan'}, {'count(*)': 1, 'District': 'Nampo-si'}, {'count(*)': 1, 'District': 'Nara'}, {'count(*)': 12, 'District': 'National Capital Reg'}, {'count(*)': 1, 'District': 'Nebraska'}, {'count(*)': 1, 'District': 'Nevada'}, {'count(*)': 1, 'District': 'New Mexico'}, {'count(*)': 1, 'District': 'New South Wales'}, {'count(*)': 1, 'District': 'New York'}, {'count(*)': 1, 'District': 'Newmaa'}, {'count(*)': 1, 'District': 'Niamey'}, {'count(*)': 1, 'District': 'Niedersachsen'}, {'count(*)': 1, 'District': 'Niigata'}, {'count(*)': 1, 'District': 'Ninawa'}, {'count(*)': 1, 'District': 'Ningxia'}, {'count(*)': 1, 'District': 'Nizni Novgorod'}, {'count(*)': 1, 'District': 'Noord-Holland'}, {'count(*)': 7, 'District': 'Nordrhein-Westfalen'}, {'count(*)': 1, 'District': 'Norte de Santander'}, {'count(*)': 1, 'District': 'North Carolina'}, {'count(*)': 1, 'District': 'Northern Mindanao'}, {'count(*)': 1, 'District': 'Nothwest Border Prov'}, {'count(*)': 1, 'District': 'Nouakchott'}, {'count(*)': 1, 'District': 'Novosibirsk'}, {'count(*)': 3, 'District': 'Nuevo León'}, {'count(*)': 1, 'District': 'Odesa'}, {'count(*)': 1, 'District': 'Ogun'}, {'count(*)': 2, 'District': 'Ohio'}, {'count(*)': 1, 'District': 'Oita'}, {'count(*)': 2, 'District': 'Okayama'}, {'count(*)': 2, 'District': 'Oklahoma'}, {'count(*)': 1, 'District': 'Omsk'}, {'count(*)': 1, 'District': 'Ondo & Ekiti'}, {'count(*)': 4, 'District': 'Ontario'}, {'count(*)': 1, 'District': 'Oran'}, {'count(*)': 1, 'District': 'Oregon'}, {'count(*)': 1, 'District': 'Orenburg'}, {'count(*)': 1, 'District': 'Oriental'}, {'count(*)': 2, 'District': 'Orissa'}, {'count(*)': 6, 'District': 'Osaka'}, {'count(*)': 1, 'District': 'Oslo'}, {'count(*)': 1, 'District': 'Ouest'}, {'count(*)': 5, 'District': 'Oyo & Osun'}, {'count(*)': 1, 'District': 'Panamá'}, {'count(*)': 2, 'District': 'Paraná'}, {'count(*)': 2, 'District': 'Paraíba'}, {'count(*)': 2, 'District': 'Pará'}, {'count(*)': 1, 'District': 'Peking'}, {'count(*)': 1, 'District': 'Pennsylvania'}, {'count(*)': 1, 'District': 'Penza'}, {'count(*)': 1, 'District': 'Perak'}, {'count(*)': 1, 'District': 'Perm'}, {'count(*)': 3, 'District': 'Pernambuco'}, {'count(*)': 1, 'District': 'Phnom Penh'}, {'count(*)': 1, 'District': 'Piauí'}, {'count(*)': 1, 'District': 'Pichincha'}, {'count(*)': 1, 'District': 'Piemonte'}, {'count(*)': 1, 'District': 'Pietari'}, {'count(*)': 1, 'District': 'Pomorskie'}, {'count(*)': 1, 'District': 'Port Said'}, {'count(*)': 1, 'District': 'Primorje'}, {'count(*)': 1, 'District': 'Provence-Alpes-Côte'}, {'count(*)': 1, 'District': 'Puebla'}, {'count(*)': 11, 'District': 'Punjab'}, {'count(*)': 1, 'District': 'Pusan'}, {'count(*)': 1, 'District': 'Pyongyang-si'}, {'count(*)': 1, 'District': 'Qaraghandy'}, {'count(*)': 1, 'District': 'Qinghai'}, {'count(*)': 1, 'District': 'Qom'}, {'count(*)': 1, 'District': 'Quang Nam-Da Nang'}, {'count(*)': 1, 'District': 'Queensland'}, {'count(*)': 1, 'District': 'Querétaro de Arteaga'}, {'count(*)': 1, 'District': 'Quintana Roo'}, {'count(*)': 1, 'District': 'Québec'}, {'count(*)': 2, 'District': 'Rabat-Salé-Zammour-Z'}, {'count(*)': 5, 'District': 'Rajasthan'}, {'count(*)': 1, 'District': 'Rangoon [Yangon]'}, {'count(*)': 1, 'District': 'Rhône-Alpes'}, {'count(*)': 1, 'District': 'Riau'}, {'count(*)': 1, 'District': 'Riika'}, {'count(*)': 1, 'District': 'Rio Grande do Norte'}, {'count(*)': 1, 'District': 'Rio Grande do Sul'}, {'count(*)': 8, 'District': 'Rio de Janeiro'}, {'count(*)': 1, 'District': 'Risaralda'}, {'count(*)': 1, 'District': 'Rivers & Bayelsa'}, {'count(*)': 1, 'District': 'Riyadh'}, {'count(*)': 1, 'District': 'Rjazan'}, {'count(*)': 1, 'District': 'Rostov-na-Donu'}, {'count(*)': 3, 'District': 'Saitama'}, {'count(*)': 2, 'District': 'Saksi'}, {'count(*)': 1, 'District': 'Salta'}, {'count(*)': 2, 'District': 'Samara'}, {'count(*)': 1, 'District': 'Samarkand'}, {'count(*)': 1, 'District': 'San Juan'}, {'count(*)': 1, 'District': 'San Luis Potosí'}, {'count(*)': 1, 'District': 'San Salvador'}, {'count(*)': 1, 'District': 'Sanaa'}, {'count(*)': 1, 'District': 'Sanliurfa'}, {'count(*)': 1, 'District': 'Santa Catarina'}, {'count(*)': 1, 'District': 'Santa Cruz'}, {'count(*)': 2, 'District': 'Santa Fé'}, {'count(*)': 1, 'District': 'Santafé de Bogotá'}, {'count(*)': 1, 'District': 'Santander'}, {'count(*)': 3, 'District': 'Santiago'}, {'count(*)': 1, 'District': 'Santiago de Cuba'}, {'count(*)': 1, 'District': 'Saratov'}, {'count(*)': 2, 'District': 'Scotland'}, {'count(*)': 1, 'District': 'Seoul'}, {'count(*)': 1, 'District': 'Sergipe'}, {'count(*)': 2, 'District': 'Shaanxi'}, {'count(*)': 2, 'District': 'Shaba'}, {'count(*)': 7, 'District': 'Shandong'}, {'count(*)': 1, 'District': 'Shanghai'}, {'count(*)': 3, 'District': 'Shanxi'}, {'count(*)': 2, 'District': 'Shizuoka'}, {'count(*)': 3, 'District': 'Sichuan'}, {'count(*)': 3, 'District': 'Sinaloa'}, {'count(*)': 2, 'District': 'Sindh'}, {'count(*)': 1, 'District': 'Sisilia'}, {'count(*)': 1, 'District': 'Sistan va Baluchesta'}, {'count(*)': 1, 'District': 'Skopje'}, {'count(*)': 1, 'District': 'Smolensk'}, {'count(*)': 1, 'District': 'Sofala'}, {'count(*)': 2, 'District': 'Sonora'}, {'count(*)': 1, 'District': 'South Australia'}, {'count(*)': 1, 'District': 'South Kazakstan'}, {'count(*)': 2, 'District': 'Southern Mindanao'}, {'count(*)': 2, 'District': 'Southern Tagalog'}, {'count(*)': 1, 'District': 'Suez'}, {'count(*)': 1, 'District': 'Sulawesi Selatan'}, {'count(*)': 1, 'District': 'Sumatera Barat'}, {'count(*)': 1, 'District': 'Sumatera Selatan'}, {'count(*)': 1, 'District': 'Sumatera Utara'}, {'count(*)': 2, 'District': 'Sverdlovsk'}, {'count(*)': 13, 'District': 'São Paulo'}, {'count(*)': 1, 'District': 'Tabasco'}, {'count(*)': 1, 'District': 'Taegu'}, {'count(*)': 1, 'District': 'Taejon'}, {'count(*)': 1, 'District': 'Taichung'}, {'count(*)': 1, 'District': 'Tainan'}, {'count(*)': 5, 'District': 'Taipei'}, {'count(*)': 2, 'District': 'Tamaulipas'}, {'count(*)': 5, 'District': 'Tamil Nadu'}, {'count(*)': 1, 'District': 'Tanger-Tétouan'}, {'count(*)': 2, 'District': 'Tatarstan'}, {'count(*)': 1, 'District': 'Tbilisi'}, {'count(*)': 2, 'District': 'Teheran'}, {'count(*)': 2, 'District': 'Tennessee'}, {'count(*)': 6, 'District': 'Texas'}, {'count(*)': 1, 'District': 'Tianjin'}, {'count(*)': 1, 'District': 'Tjumen'}, {'count(*)': 1, 'District': 'Tochigi'}, {'count(*)': 3, 'District': 'Tokyo-to'}, {'count(*)': 1, 'District': 'Tolima'}, {'count(*)': 1, 'District': 'Tomsk'}, {'count(*)': 1, 'District': 'Toscana'}, {'count(*)': 1, 'District': 'Toskent Shahri'}, {'count(*)': 1, 'District': 'Tripoli'}, {'count(*)': 1, 'District': 'Tucumán'}, {'count(*)': 1, 'District': 'Tula'}, {'count(*)': 1, 'District': 'Tunis'}, {'count(*)': 1, 'District': 'Tver'}, {'count(*)': 2, 'District': 'Tšeljabinsk'}, {'count(*)': 1, 'District': 'Tšuvassia'}, {'count(*)': 1, 'District': 'Udmurtia'}, {'count(*)': 1, 'District': 'Ulaanbaatar'}, {'count(*)': 1, 'District': 'Uljanovsk'}, {'count(*)': 12, 'District': 'Uttar Pradesh'}, {'count(*)': 1, 'District': 'Valencia'}, {'count(*)': 1, 'District': 'Valle'}, {'count(*)': 2, 'District': 'Veracruz'}, {'count(*)': 1, 'District': 'Viangchan'}, {'count(*)': 1, 'District': 'Victoria'}, {'count(*)': 1, 'District': 'Vilna'}, {'count(*)': 1, 'District': 'Vinnytsja'}, {'count(*)': 1, 'District': 'Virginia'}, {'count(*)': 1, 'District': 'Volgograd'}, {'count(*)': 1, 'District': 'Voronez'}, {'count(*)': 1, 'District': 'Wakayama'}, {'count(*)': 1, 'District': 'Washington'}, {'count(*)': 1, 'District': 'West Australia'}, {'count(*)': 1, 'District': 'West Azerbaidzan'}, {'count(*)': 3, 'District': 'West Bengali'}, {'count(*)': 1, 'District': 'West Götanmaan län'}, {'count(*)': 4, 'District': 'West Java'}, {'count(*)': 1, 'District': 'West Kasai'}, {'count(*)': 2, 'District': 'Western'}, {'count(*)': 1, 'District': 'Western Cape'}, {'count(*)': 1, 'District': 'Western Mindanao'}, {'count(*)': 2, 'District': 'Western Visayas'}, {'count(*)': 1, 'District': 'Wielkopolskie'}, {'count(*)': 1, 'District': 'Wien'}, {'count(*)': 1, 'District': 'Wilayah Persekutuan'}, {'count(*)': 1, 'District': 'Wisconsin'}, {'count(*)': 1, 'District': 'Xinxiang'}, {'count(*)': 1, 'District': 'Yerevan'}, {'count(*)': 1, 'District': 'Yogyakarta'}, {'count(*)': 1, 'District': 'Yucatán'}, {'count(*)': 1, 'District': 'Yunnan'}, {'count(*)': 1, 'District': 'Zachodnio-Pomorskie'}, {'count(*)': 1, 'District': 'Zaporizzja'}, {'count(*)': 3, 'District': 'Zhejiang'}, {'count(*)': 2, 'District': 'Zuid-Holland'}, {'count(*)': 1, 'District': 'Zulia'}, {'count(*)': 1, 'District': 'al-Daqahliya'}, {'count(*)': 2, 'District': 'al-Gharbiya'}, {'count(*)': 1, 'District': 'al-Qalyubiya'}, {'count(*)': 1, 'District': 'al-Sharqiya'}, {'count(*)': 1, 'District': 'al-Sulaymaniya'}, {'count(*)': 1, 'District': 'al-Tamim'}, {'count(*)': 1, 'District': 'al-Zarqa'}, {'count(*)': 1, 'District': 'Île-de-France'}, {'count(*)': 1, 'District': '–'}]