Linnad, mille elanike arv on suurem kui riigi keskmine (alampäringuga)

SELECT CityName, CountryCode, Population
FROM tCity 
WHERE Population >
    (SELECT AVG(C.Population)
    FROM tCity AS C
    WHERE C.CountryCode=CountryCode)
ORDER BY Countrycode, Population DESC

(875 rows affected)

Total execution time: 00:00:00.042

CityName	CountryCode	Population
Kabul	AFG	1760000
Luanda	AGO	2022000
Dubai	ARE	669181
Abu Dhabi	ARE	398695
Buenos Aires	ARG	2982146
La Matanza	ARG	1266461
Córdoba	ARG	1157507
Rosario	ARG	907718
Lomas de Zamora	ARG	622013
Quilmes	ARG	559249
Almirante Brown	ARG	538918
La Plata	ARG	521936
Mar del Plata	ARG	512880
San Miguel de Tucumin	ARG	470809
Lanss	ARG	469735
Merlo	ARG	463846
General San Martkn	ARG	422542
Salta	ARG	367550
Moreno	ARG	356993
Santa Fé	ARG	353063
Avellaneda	ARG	353046
Tres de Febrero	ARG	352311
Yerevan	ARM	1248700
Sydney	AUS	3276207
Melbourne	AUS	2865329
Brisbane	AUS	1291117
Perth	AUS	1096829
Adelaide	AUS	978100
Wien	AUT	1608144
Baku	AZE	1787800
Antwerpen	BEL	446525
Cotonou	BEN	536827
Ouagadougou	BFA	824000
Dhaka	BGD	3612850
Chittagong	BGD	1392860
Khulna	BGD	663340
Sofija	BGR	1122302
Sarajevo	BIH	360000
Minsk	BLR	1674000
Gomel	BLR	475000
Mogiljov	BLR	356000
Santa Cruz de la Sierra	BOL	935361
La Paz	BOL	758141
El Alto	BOL	534466
Cochabamba	BOL	482800
Sco Paulo	BRA	9968485
Rio de Janeiro	BRA	5598953
Salvador	BRA	2302832
Belo Horizonte	BRA	2139125
Fortaleza	BRA	2097757
Brasklia	BRA	1969868
Curitiba	BRA	1584232
Recife	BRA	1378087
Porto Alegre	BRA	1314032
Manaus	BRA	1255049
Belém	BRA	1186926
Guarulhos	BRA	1095874
Goiania	BRA	1056330
Campinas	BRA	950043
Sco Gonealo	BRA	869254
Nova Iguaeu	BRA	862225
Sco Luks	BRA	837588
Maceió	BRA	786288
Duque de Caxias	BRA	746758
Sco Bernardo do Campo	BRA	723132
Teresina	BRA	691942
Natal	BRA	688955
Osasco	BRA	659604
Campo Grande	BRA	649593
Santo André	BRA	630073
Joco Pessoa	BRA	584029
Jaboatco dos Guararapes	BRA	558680
Contagem	BRA	520801
Sco José dos Campos	BRA	515553
Uberlandia	BRA	487222
Feira de Santana	BRA	479992
Ribeirco Preto	BRA	473276
Sorocaba	BRA	466823
Niterói	BRA	459884
Cuiabi	BRA	453813
Juiz de Fora	BRA	450288
Aracaju	BRA	445555
Sco Joco de Meriti	BRA	440052
Londrina	BRA	432257
Joinville	BRA	428011
Belford Roxo	BRA	425194
Santos	BRA	408748
Ananindeua	BRA	400940
Campos dos Goytacazes	BRA	398418
Maui	BRA	375055
Carapicukba	BRA	357552
Olinda	BRA	354732
Campina Grande	BRA	352497
Sco José do Rio Preto	BRA	351944
Bangui	CAF	524000
Montréal	CAN	1016376
Calgary	CAN	768082
Toronto	CAN	688275
North York	CAN	622632
Winnipeg	CAN	618477
Edmonton	CAN	616306
Mississauga	CAN	608072
Scarborough	CAN	594501
Vancouver	CAN	514008
Santiago de Chile	CHL	4703954
Puente Alto	CHL	386236
Shanghai	CHN	9696300
Peking	CHN	7472000
Chongqing	CHN	6351600
Tianjin	CHN	5286800
Wuhan	CHN	4344600
Harbin	CHN	4289800
Shenyang	CHN	4265200
Kanton [Guangzhou]	CHN	4256300
Chengdu	CHN	3361500
Nanking [Nanjing]	CHN	2870300
Changchun	CHN	2812000
Xi´an	CHN	2761400
Dalian	CHN	2697000
Qingdao	CHN	2596000
Jinan	CHN	2278100
Hangzhou	CHN	2190500
Zhengzhou	CHN	2107200
Shijiazhuang	CHN	2041500
Taiyuan	CHN	1968400
Kunming	CHN	1829500
Changsha	CHN	1809800
Nanchang	CHN	1691600
Fuzhou	CHN	1593800
Lanzhou	CHN	1565800
Guiyang	CHN	1465200
Ningbo	CHN	1371200
Hefei	CHN	1369100
Urumtši [Ürümqi]	CHN	1310100
Anshan	CHN	1200000
Fushun	CHN	1200000
Nanning	CHN	1161800
Zibo	CHN	1140000
Qiqihar	CHN	1070000
Jilin	CHN	1040000
Tangshan	CHN	1040000
Baotou	CHN	980000
Shenzhen	CHN	950500
Hohhot	CHN	916700
Handan	CHN	840000
Wuxi	CHN	830000
Xuzhou	CHN	810000
Datong	CHN	800000
Yichun	CHN	800000
Benxi	CHN	770000
Luoyang	CHN	760000
Suzhou	CHN	710000
Xining	CHN	700200
Huainan	CHN	700000
Jixi	CHN	683885
Daqing	CHN	660000
Fuxin	CHN	640000
Amoy [Xiamen]	CHN	627500
Liuzhou	CHN	610000
Shantou	CHN	580000
Jinzhou	CHN	570000
Mudanjiang	CHN	570000
Yinchuan	CHN	544500
Changzhou	CHN	530000
Zhangjiakou	CHN	530000
Dandong	CHN	520000
Hegang	CHN	520000
Kaifeng	CHN	510000
Jiamusi	CHN	493409
Liaoyang	CHN	492559
Hengyang	CHN	487148
Baoding	CHN	483155
Hunjiang	CHN	482043
Xinxiang	CHN	473762
Huangshi	CHN	457601
Haikou	CHN	454300
Yantai	CHN	452127
Bengbu	CHN	449245
Xiangtan	CHN	441968
Weifang	CHN	428522
Wuhu	CHN	425740
Pingxiang	CHN	425579
Yingkou	CHN	421589
Anyang	CHN	420332
Panzhihua	CHN	415466
Pingdingshan	CHN	410775
Xiangfan	CHN	410407
Zhuzhou	CHN	409924
Jiaozuo	CHN	409100
Wenzhou	CHN	401871
Zhangjiang	CHN	400997
Zigong	CHN	393184
Shuangyashan	CHN	386081
Zaozhuang	CHN	380846
Yakeshi	CHN	377869
Yichang	CHN	371601
Zhenjiang	CHN	368316
Huaibei	CHN	366549
Qinhuangdao	CHN	364972
Guilin	CHN	364130
Liupanshui	CHN	363954
Panjin	CHN	362773
Yangquan	CHN	362268
Jinxi	CHN	357052
Liaoyuan	CHN	354141
Lianyungang	CHN	354139
Xianyang	CHN	352125
Tai´an	CHN	350696
Abidjan	CIV	2500000
Douala	CMR	1448300
Yaoundé	CMR	1372800
Kinshasa	COD	5064000
Lubumbashi	COD	851381
Mbuji-Mayi	COD	806475
Kolwezi	COD	417810
Kisangani	COD	417517
Kananga	COD	393030
Brazzaville	COG	950000
Pointe-Noire	COG	500000
Santafé de Bogoti	COL	6260862
Cali	COL	2077386
Medellkn	COL	1861265
Barranquilla	COL	1223260
Cartagena	COL	805757
Cscuta	COL	606932
Bucaramanga	COL	515555
Ibagué	COL	393664
Pereira	COL	381725
Santa Marta	COL	359147
La Habana	CUB	2256000
Santiago de Cuba	CUB	433180
Praha	CZE	1181126
Brno	CZE	381862
Berlin	DEU	3386667
Hamburg	DEU	1704735
Munich [München]	DEU	1194560
Köln	DEU	962507
Frankfurt am Main	DEU	643821
Essen	DEU	599515
Dortmund	DEU	590213
Stuttgart	DEU	582443
Düsseldorf	DEU	568855
Bremen	DEU	540330
Duisburg	DEU	519793
Hannover	DEU	514718
Leipzig	DEU	489532
Nürnberg	DEU	486628
Dresden	DEU	476668
Bochum	DEU	392830
Wuppertal	DEU	368993
Djibouti	DJI	383000
Kubenhavn	DNK	495699
Santo Domingo de Guzmin	DOM	1609966
Santiago de los Caballeros	DOM	365463
Alger	DZA	2168000
Oran	DZA	609823
Constantine	DZA	443727
Guayaquil	ECU	2070040
Quito	ECU	1573458
Cairo	EGY	6789479
Alexandria	EGY	3328196
Giza	EGY	2221868
Shubra al-Khayma	EGY	870716
Port Said	EGY	469533
Suez	EGY	417610
al-Mahallat al-Kubra	EGY	395402
Tanta	EGY	371010
al-Mansura	EGY	369621
Luxor	EGY	360503
Asmara	ERI	431000
Madrid	ESP	2879052
Barcelona	ESP	1503451
Valencia	ESP	739412
Sevilla	ESP	701927
Zaragoza	ESP	603367
Milaga	ESP	530553
Bilbao	ESP	357589
Las Palmas de Gran Canaria	ESP	354757
Murcia	ESP	353504
Tallinn	EST	403981
Addis Abeba	ETH	2495000
Helsinki [Helsingfors]	FIN	555474
Paris	FRA	2125246
Marseille	FRA	798430
Lyon	FRA	445452
Toulouse	FRA	390350
Libreville	GAB	419000
London	GBR	7285000
Birmingham	GBR	1013000
Glasgow	GBR	619680
Liverpool	GBR	461000
Edinburgh	GBR	450180
Sheffield	GBR	431607
Manchester	GBR	430000
Leeds	GBR	424194
Bristol	GBR	402000
Tbilisi	GEO	1235200
Accra	GHA	1070000
Kumasi	GHA	385192
Conakry	GIN	1090610
Athenai	GRC	772072
Thessaloniki	GRC	383967
Ciudad de Guatemala	GTM	823301
Kowloon and New Kowloon	HKG	1987996
Victoria	HKG	1312637
Tegucigalpa	HND	813900
San Pedro Sula	HND	383900
Zagreb	HRV	706770
Port-au-Prince	HTI	884472
Budapest	HUN	1811552
Jakarta	IDN	9604900
Surabaya	IDN	2663820
Bandung	IDN	2429000
Medan	IDN	1843919
Palembang	IDN	1222764
Tangerang	IDN	1198300
Semarang	IDN	1104405
Ujung Pandang	IDN	1060257
Malang	IDN	716862
Bandar Lampung	IDN	680332
Bekasi	IDN	644300
Padang	IDN	534474
Surakarta	IDN	518600
Banjarmasin	IDN	482931
Pekan Baru	IDN	438638
Denpasar	IDN	435000
Yogyakarta	IDN	418944
Pontianak	IDN	409632
Samarinda	IDN	399175
Jambi	IDN	385201
Depok	IDN	365200
Mumbai (Bombay)	IND	10500000
Delhi	IND	7206704
Calcutta [Kolkata]	IND	4399819
Chennai (Madras)	IND	3841396
Hyderabad	IND	2964638
Ahmedabad	IND	2876710
Bangalore	IND	2660088
Kanpur	IND	1874409
Nagpur	IND	1624752
Lucknow	IND	1619115
Pune	IND	1566651
Surat	IND	1498817
Jaipur	IND	1458483
Indore	IND	1091674
Bhopal	IND	1062771
Ludhiana	IND	1042740
Vadodara (Baroda)	IND	1031346
Kalyan	IND	1014557
Madurai	IND	977856
Haora (Howrah)	IND	950435
Varanasi (Benares)	IND	929270
Patna	IND	917243
Srinagar	IND	892506
Agra	IND	891790
Coimbatore	IND	816321
Thane (Thana)	IND	803389
Allahabad	IND	792858
Meerut	IND	753778
Vishakhapatnam	IND	752037
Jabalpur	IND	741927
Amritsar	IND	708835
Faridabad	IND	703592
Vijayawada	IND	701827
Gwalior	IND	690765
Jodhpur	IND	666279
Nashik (Nasik)	IND	656925
Hubli-Dharwad	IND	648298
Solapur (Sholapur)	IND	604215
Ranchi	IND	599306
Bareilly	IND	587211
Guwahati (Gauhati)	IND	584342
Shambajinagar (Aurangabad)	IND	573272
Cochin (Kochi)	IND	564589
Rajkot	IND	559407
Kota	IND	537371
Thiruvananthapuram (Trivandrum	IND	524006
Pimpri-Chinchwad	IND	517083
Jalandhar (Jullundur)	IND	509510
Gorakhpur	IND	505566
Chandigarh	IND	504094
Mysore	IND	480692
Aligarh	IND	480520
Guntur	IND	471051
Jamshedpur	IND	460577
Ghaziabad	IND	454156
Warangal	IND	447657
Raipur	IND	438639
Moradabad	IND	429214
Durgapur	IND	425836
Amravati	IND	421576
Calicut (Kozhikode)	IND	419831
Bikaner	IND	416289
Bhubaneswar	IND	411542
Kolhapur	IND	406370
Kataka (Cuttack)	IND	403418
Ajmer	IND	402700
Bhavnagar	IND	402338
Tiruchirapalli	IND	387223
Bhilai	IND	386159
Bhiwandi	IND	379070
Saharanpur	IND	374945
Ulhasnagar	IND	369077
Salem	IND	366712
Ujjain	IND	362266
Dublin	IRL	481854
Teheran	IRN	6758845
Mashhad	IRN	1887405
Esfahan	IRN	1266072
Tabriz	IRN	1191043
Shiraz	IRN	1053025
Karaj	IRN	940968
Ahvaz	IRN	804980
Qom	IRN	777677
Kermanshah	IRN	692986
Urmia	IRN	435200
Zahedan	IRN	419518
Rasht	IRN	417748
Hamadan	IRN	401281
Kerman	IRN	384991
Arak	IRN	380755
Baghdad	IRQ	4336000
Mosul	IRQ	879000
Irbil	IRQ	485968
Kirkuk	IRQ	418624
Basra	IRQ	406296
al-Sulaymaniya	IRQ	364096
Jerusalem	ISR	633700
Roma	ITA	2643581
Milano	ITA	1300977
Napoli	ITA	1002619
Torino	ITA	903705
Palermo	ITA	683794
Genova	ITA	636104
Bologna	ITA	381161
Firenze	ITA	376662
Amman	JOR	1000000
al-Zarqa	JOR	389815
Tokyo	JPN	7980230
Jokohama [Yokohama]	JPN	3339594
Osaka	JPN	2595674
Nagoya	JPN	2154376
Sapporo	JPN	1790886
Kioto	JPN	1461974
Kobe	JPN	1425139
Fukuoka	JPN	1308379
Kawasaki	JPN	1217359
Hiroshima	JPN	1119117
Kitakyushu	JPN	1016264
Sendai	JPN	989975
Chiba	JPN	863930
Sakai	JPN	797735
Kumamoto	JPN	656734
Okayama	JPN	624269
Sagamihara	JPN	586300
Hamamatsu	JPN	568796
Kagoshima	JPN	549977
Funabashi	JPN	545299
Higashiosaka	JPN	517785
Hachioji	JPN	513451
Niigata	JPN	497464
Amagasaki	JPN	481434
Himeji	JPN	475167
Shizuoka	JPN	473854
Urawa	JPN	469675
Matsuyama	JPN	466133
Matsudo	JPN	461126
Kanazawa	JPN	455386
Kawaguchi	JPN	452155
Ichikawa	JPN	441893
Omiya	JPN	441649
Utsunomiya	JPN	440353
Oita	JPN	433401
Nagasaki	JPN	432759
Yokosuka	JPN	430200
Kurashiki	JPN	425103
Gifu	JPN	408007
Hirakata	JPN	403151
Nishinomiya	JPN	397618
Toyonaka	JPN	396689
Wakayama	JPN	391233
Fukuyama	JPN	376921
Fujisawa	JPN	372840
Asahikawa	JPN	364813
Machida	JPN	364197
Nara	JPN	362812
Takatsuki	JPN	361747
Iwaki	JPN	361737
Nagano	JPN	361391
Toyohashi	JPN	360066
Almaty	KAZ	1129400
Qaraghandy	KAZ	436900
Shymkent	KAZ	360100
Nairobi	KEN	2290000
Mombasa	KEN	461753
Bishkek	KGZ	589400
Phnom Penh	KHM	570155
Seoul	KOR	9981619
Pusan	KOR	3804522
Inchon	KOR	2559424
Taegu	KOR	2548568
Taejon	KOR	1425835
Kwangju	KOR	1368341
Ulsan	KOR	1084891
Songnam	KOR	869094
Puchon	KOR	779412
Suwon	KOR	755550
Anyang	KOR	591106
Chonju	KOR	563153
Chongju	KOR	531376
Koyang	KOR	518282
Ansan	KOR	510314
Pohang	KOR	508899
Chang-won	KOR	481694
Masan	KOR	441242
Kwangmyong	KOR	350914
Vientiane	LAO	531800
Beirut	LBN	1100000
Monrovia	LBR	850000
Tripoli	LBY	1682000
Bengasi	LBY	804000
Colombo	LKA	645000
Vilnius	LTU	577969
Kaunas	LTU	412639
Riga	LVA	764328
Macao	MAC	437500
Casablanca	MAR	2940623
Rabat	MAR	623457
Marrakech	MAR	621914
Fcs	MAR	541162
Tanger	MAR	521735
Salé	MAR	504420
Mekncs	MAR	460000
Oujda	MAR	365382
Chisinau	MDA	719900
Antananarivo	MDG	675669
Ciudad de México	MEX	8591309
Guadalajara	MEX	1647720
Ecatepec de Morelos	MEX	1620303
Puebla	MEX	1346176
Nezahualcóyotl	MEX	1224924
Juirez	MEX	1217818
Tijuana	MEX	1212232
León	MEX	1133576
Monterrey	MEX	1108499
Zapopan	MEX	1002239
Naucalpan de Juirez	MEX	857511
Mexicali	MEX	764902
Culiacin	MEX	744859
Acapulco de Juirez	MEX	721011
Tlalnepantla de Baz	MEX	720755
Mérida	MEX	703324
Chihuahua	MEX	670208
San Luis Potosk	MEX	669353
Guadalupe	MEX	668780
Toluca	MEX	665617
Aguascalientes	MEX	643360
Querétaro	MEX	639839
Morelia	MEX	619958
Hermosillo	MEX	608697
Saltillo	MEX	577352
Torreón	MEX	529093
Centro (Villahermosa)	MEX	519873
San Nicolis de los Garza	MEX	495540
Durango	MEX	490524
Chimalhuacin	MEX	490245
Tlaquepaque	MEX	475472
Atizapin de Zaragoza	MEX	467262
Veracruz	MEX	457119
Cuautitlin Izcalli	MEX	452976
Irapuato	MEX	440039
Tuxtla Gutiérrez	MEX	433544
Tultitlin	MEX	432411
Reynosa	MEX	419776
Benito Juirez	MEX	419276
Matamoros	MEX	416428
Xalapa	MEX	390058
Celaya	MEX	382140
Mazatlin	MEX	380265
Ensenada	MEX	369573
Ahome	MEX	358663
Cajeme	MEX	355679
Skopje	MKD	444299
Bamako	MLI	809552
Rangoon (Yangon)	MMR	3361700
Mandalay	MMR	885300
Ulan Bator	MNG	773700
Maputo	MOZ	1018938
Matola	MOZ	424662
Beira	MOZ	397368
Nouakchott	MRT	667300
Blantyre	MWI	478155
Lilongwe	MWI	435964
Kuala Lumpur	MYS	1297526
Ipoh	MYS	382853
Niamey	NER	420000
Lagos	NGA	1518000
Ibadan	NGA	1432000
Ogbomosho	NGA	730000
Kano	NGA	674100
Oshogbo	NGA	476800
Ilorin	NGA	475800
Abeokuta	NGA	427400
Port Harcourt	NGA	410000
Zaria	NGA	379200
Ilesha	NGA	378400
Onitsha	NGA	371900
Iwo	NGA	362000
Ado-Ekiti	NGA	359400
Managua	NIC	959000
Amsterdam	NLD	731200
Rotterdam	NLD	593321
Haag	NLD	440900
Oslo	NOR	508726
Kathmandu	NPL	591835
Auckland	NZL	381800
Karachi	PAK	9269265
Lahore	PAK	5063499
Faisalabad	PAK	1977246
Rawalpindi	PAK	1406214
Multan	PAK	1182441
Hyderabad	PAK	1151274
Gujranwala	PAK	1124749
Peshawar	PAK	988005
Quetta	PAK	560307
Islamabad	PAK	524500
Sargodha	PAK	455360
Sialkot	PAK	417597
Bahawalpur	PAK	403408
Ciudad de Panami	PAN	471373
Lima	PER	6464693
Arequipa	PER	762000
Trujillo	PER	652000
Chiclayo	PER	517000
Callao	PER	424294
Iquitos	PER	367000
Quezon	PHL	2173831
Manila	PHL	1581082
Kalookan	PHL	1177604
Davao	PHL	1147116
Cebu	PHL	718821
Zamboanga	PHL	601794
Pasig	PHL	505058
Valenzuela	PHL	485433
Las Pinas	PHL	472780
Antipolo	PHL	470866
Taguig	PHL	467375
Cagayan de Oro	PHL	461877
Paranaque	PHL	449811
Makati	PHL	444867
Bacolod	PHL	429076
General Santos	PHL	411822
Marikina	PHL	391170
Dasmarinas	PHL	379520
Muntinlupa	PHL	379310
Iloilo	PHL	365820
Pasay	PHL	354908
Warszawa	POL	1615369
Lódz	POL	800110
Kraków	POL	738150
Wroclaw	POL	636765
Poznan	POL	576899
Gdansk	POL	458988
Szczecin	POL	416988
Bydgoszcz	POL	386855
Lublin	POL	356251
San Juan	PRI	434374
Pyongyang	PRK	2484000
Hamhung	PRK	709730
Chongjin	PRK	582480
Nampo	PRK	566200
Lisboa	PRT	563210
Asunción	PRY	557776
Gaza	PSE	353632
Doha	QAT	355000
Bucuresti	ROM	2016131
Moscow	RUS	8389200
St Petersburg	RUS	4694000
Novosibirsk	RUS	1398800
Nizni Novgorod	RUS	1357000
Jekaterinburg	RUS	1266300
Samara	RUS	1156100
Omsk	RUS	1148900
Kazan	RUS	1101000
Ufa	RUS	1091200
Tšeljabinsk	RUS	1083200
Rostov-na-Donu	RUS	1012700
Perm	RUS	1009700
Volgograd	RUS	993400
Voronez	RUS	907700
Krasnojarsk	RUS	875500
Saratov	RUS	874000
Toljatti	RUS	722900
Uljanovsk	RUS	667400
Izevsk	RUS	652800
Krasnodar	RUS	639000
Jaroslavl	RUS	616700
Habarovsk	RUS	609400
Vladivostok	RUS	606200
Irkutsk	RUS	593700
Barnaul	RUS	580100
Novokuznetsk	RUS	561600
Penza	RUS	532200
Rjazan	RUS	529900
Orenburg	RUS	523600
Lipetsk	RUS	521000
Nabereznyje Tšelny	RUS	514700
Tula	RUS	506100
Tjumen	RUS	503400
Kemerovo	RUS	492700
Astrahan	RUS	486100
Tomsk	RUS	482100
Kirov	RUS	466200
Ivanovo	RUS	459200
Tšeboksary	RUS	459200
Brjansk	RUS	457400
Tver	RUS	454900
Kursk	RUS	443500
Magnitogorsk	RUS	427900
Kaliningrad	RUS	424400
Nizni Tagil	RUS	390900
Murmansk	RUS	376300
Ulan-Ude	RUS	370400
Kurgan	RUS	364700
Arkangeli	RUS	361800
Sotši	RUS	358600
Smolensk	RUS	353400
Riyadh	SAU	3324000
Jedda	SAU	2046300
Mekka	SAU	965700
Medina	SAU	608300
al-Dammam	SAU	482300
al-Taif	SAU	416100
Omdurman	SDN	1271403
Khartum	SDN	947483
Sharq al-Nil	SDN	700887
Pikine	SEN	855287
Dakar	SEN	785071
Singapore	SGP	4017733
Freetown	SLE	850000
San Salvador	SLV	415346
Mogadishu	SOM	997000
Bratislava	SVK	448292
Stockholm	SWE	750348
Gothenburg [Göteborg]	SWE	466990
Damascus	SYR	1347000
Aleppo	SYR	1261983
Hims	SYR	507404
N´Djaména	TCD	530965
Lomé	TGO	375000
Bangkok	THA	6320174
Dushanbe	TJK	524000
Ashgabat	TKM	540600
Tunis	TUN	690600
Istanbul	TUR	8787958
Ankara	TUR	3038159
Izmir	TUR	2130359
Adana	TUR	1131198
Bursa	TUR	1095842
Gaziantep	TUR	789056
Konya	TUR	628364
Mersin (Ieel)	TUR	587212
Antalya	TUR	564914
Diyarbakir	TUR	479884
Kayseri	TUR	475657
Eskisehir	TUR	470781
Sanliurfa	TUR	405905
Taipei	TWN	2641312
Kaohsiung	TWN	1475505
Taichung	TWN	940589
Tainan	TWN	728060
Panchiao	TWN	523850
Chungho	TWN	392176
Keelung (Chilung)	TWN	385201
Sanchung	TWN	380084
Hsinchuang	TWN	365048
Hsinchu	TWN	361958
Dar es Salaam	TZA	1747000
Kampala	UGA	890800
Kyiv	UKR	2624000
Harkova [Harkiv]	UKR	1500000
Dnipropetrovsk	UKR	1103000
Donetsk	UKR	1050000
Odesa	UKR	1011000
Zaporizzja	UKR	848000
Lviv	UKR	788000
Kryvyi Rig	UKR	703000
Mykolajiv	UKR	508000
Mariupol	UKR	490000
Lugansk	UKR	469000
Vinnytsja	UKR	391000
Makijivka	UKR	384000
Herson	UKR	353000
Montevideo	URY	1236000
New York	USA	8008278
Los Angeles	USA	3694820
Chicago	USA	2896016
Houston	USA	1953631
Philadelphia	USA	1517550
Phoenix	USA	1321045
San Diego	USA	1223400
Dallas	USA	1188580
San Antonio	USA	1144646
Detroit	USA	951270
San Jose	USA	894943
Indianapolis	USA	791926
San Francisco	USA	776733
Jacksonville	USA	735167
Columbus	USA	711470
Austin	USA	656562
Baltimore	USA	651154
Memphis	USA	650100
Milwaukee	USA	596974
Boston	USA	589141
Washington	USA	572059
Nashville-Davidson	USA	569891
El Paso	USA	563662
Seattle	USA	563374
Denver	USA	554636
Charlotte	USA	540828
Fort Worth	USA	534694
Portland	USA	529121
Oklahoma City	USA	506132
Tucson	USA	486699
New Orleans	USA	484674
Las Vegas	USA	478434
Cleveland	USA	478403
Long Beach	USA	461522
Albuquerque	USA	448607
Kansas City	USA	441545
Fresno	USA	427652
Virginia Beach	USA	425257
Atlanta	USA	416474
Sacramento	USA	407018
Oakland	USA	399484
Mesa	USA	396375
Tulsa	USA	393049
Omaha	USA	390007
Minneapolis	USA	382618
Honolulu	USA	371657
Miami	USA	362470
Colorado Springs	USA	360890
Toskent	UZB	2117500
Namangan	UZB	370500
Samarkand	UZB	361800
Caracas	VEN	1975294
Maracakbo	VEN	1304776
Barquisimeto	VEN	877239
Valencia	VEN	794246
Ciudad Guayana	VEN	663713
Petare	VEN	488868
Maracay	VEN	444443
Ho Chi Minh City	VNM	3980000
Hanoi	VNM	1410000
Haiphong	VNM	783133
Da Nang	VNM	382674
Sanaa	YEM	503600
Aden	YEM	398300
Beograd	YUG	1204000
Cape Town	ZAF	2352121
Soweto	ZAF	904165
Johannesburg	ZAF	756653
Port Elizabeth	ZAF	752319
Pretoria	ZAF	658630
Inanda	ZAF	634065
Durban	ZAF	566120
Vanderbijlpark	ZAF	468931
Kempton Park	ZAF	442633
Alberton	ZAF	410102
Pinetown	ZAF	378810
Pietermaritzburg	ZAF	370190
Benoni	ZAF	365467
Lusaka	ZMB	1317000
Harare	ZWE	1410000
Bulawayo	ZWE	621742

WITH Keskm AS
    (SELECT Countrycode, AVG(Population) as AVeragePopulation
    FROm tCity
    GROUP BY CountryCode)
SELECT *
FROM tCity INNER JOIN Keskm AS K ON tCity.CountryCode=K.CountryCode
WHERE Population > K.AVeragePopulation

(915 rows affected)

Total execution time: 00:00:00.073

ID	CityName	CountryCode	District	Population	Countrycode	AVeragePopulation
1	Kabul	AFG	Kabol	1760000	AFG	578025
56	Luanda	AGO	Luanda	2022000	AGO	512320
61	South Hill	AIA	NULL	961	AIA	778
64	Dubai	ARE	Dubai	669181	ARE	345667
65	Abu Dhabi	ARE	Abu Dhabi	398695	ARE	345667
69	Buenos Aires	ARG	Distrito Federal	2982146	ARG	350816
70	La Matanza	ARG	Buenos Aires	1266461	ARG	350816
71	Córdoba	ARG	Córdoba	1157507	ARG	350816
72	Rosario	ARG	Santa Fé	907718	ARG	350816
73	Lomas de Zamora	ARG	Buenos Aires	622013	ARG	350816
74	Quilmes	ARG	Buenos Aires	559249	ARG	350816
75	Almirante Brown	ARG	Buenos Aires	538918	ARG	350816
76	La Plata	ARG	Buenos Aires	521936	ARG	350816
77	Mar del Plata	ARG	Buenos Aires	512880	ARG	350816
78	San Miguel de Tucumin	ARG	Tucumin	470809	ARG	350816
79	Lanss	ARG	Buenos Aires	469735	ARG	350816
80	Merlo	ARG	Buenos Aires	463846	ARG	350816
81	General San Martkn	ARG	Buenos Aires	422542	ARG	350816
82	Salta	ARG	Salta	367550	ARG	350816
83	Moreno	ARG	Buenos Aires	356993	ARG	350816
84	Santa Fé	ARG	Santa Fé	353063	ARG	350816
85	Avellaneda	ARG	Buenos Aires	353046	ARG	350816
86	Tres de Febrero	ARG	Buenos Aires	352311	ARG	350816
126	Yerevan	ARM	Yerevan	1248700	ARM	544366
53	Tafuna	ASM	Tutuila	5200	ASM	3761
130	Sydney	AUS	New South Wales	3276207	AUS	808119
131	Melbourne	AUS	Victoria	2865329	AUS	808119
132	Brisbane	AUS	Queensland	1291117	AUS	808119
133	Perth	AUS	West Australia	1096829	AUS	808119
134	Adelaide	AUS	South Australia	978100	AUS	808119
1523	Wien	AUT	Wien	1608144	AUT	397378
144	Baku	AZE	Baki	1787800	AZE	616000
175	Antwerpen	BEL	Antwerpen	446525	BEL	178813
176	Gent	BEL	East Flanderi	224180	BEL	178813
177	Charleroi	BEL	Hainaut	200827	BEL	178813
178	Licge	BEL	Licge	185639	BEL	178813
186	Cotonou	BEN	Atlantique	536827	BEN	242125
549	Ouagadougou	BFA	Kadiogo	824000	BFA	409666
150	Dhaka	BGD	Dhaka	3612850	BGD	357079
151	Chittagong	BGD	Chittagong	1392860	BGD	357079
152	Khulna	BGD	Khulna	663340	BGD	357079
539	Sofija	BGR	Grad Sofija	1122302	BGR	269691
540	Plovdiv	BGR	Plovdiv	342584	BGR	269691
541	Varna	BGR	Varna	299801	BGR	269691
201	Sarajevo	BIH	Federaatio	360000	BIH	199702
3520	Minsk	BLR	Horad Minsk	1674000	BLR	296312
3521	Gomel	BLR	Gomel	475000	BLR	296312
3522	Mogiljov	BLR	Mogiljov	356000	BLR	296312
3523	Vitebsk	BLR	Vitebsk	340000	BLR	296312
3524	Grodno	BLR	Grodno	302000	BLR	296312
184	Belize City	BLZ	Belize City	55810	BLZ	31457
190	Saint George	BMU	Saint George´s	1800	BMU	1500
193	Santa Cruz de la Sierra	BOL	Santa Cruz	935361	BOL	422330
194	La Paz	BOL	La Paz	758141	BOL	422330
195	El Alto	BOL	La Paz	534466	BOL	422330
196	Cochabamba	BOL	Cochabamba	482800	BOL	422330
206	Sco Paulo	BRA	Sco Paulo	9968485	BRA	343507
207	Rio de Janeiro	BRA	Rio de Janeiro	5598953	BRA	343507
208	Salvador	BRA	Bahia	2302832	BRA	343507
209	Belo Horizonte	BRA	Minas Gerais	2139125	BRA	343507
210	Fortaleza	BRA	Ceari	2097757	BRA	343507
211	Brasklia	BRA	Distrito Federal	1969868	BRA	343507
212	Curitiba	BRA	Parani	1584232	BRA	343507
213	Recife	BRA	Pernambuco	1378087	BRA	343507
214	Porto Alegre	BRA	Rio Grande do Sul	1314032	BRA	343507
215	Manaus	BRA	Amazonas	1255049	BRA	343507
216	Belém	BRA	Pari	1186926	BRA	343507
217	Guarulhos	BRA	Sco Paulo	1095874	BRA	343507
218	Goiania	BRA	Goiis	1056330	BRA	343507
219	Campinas	BRA	Sco Paulo	950043	BRA	343507
220	Sco Gonealo	BRA	Rio de Janeiro	869254	BRA	343507
221	Nova Iguaeu	BRA	Rio de Janeiro	862225	BRA	343507
222	Sco Luks	BRA	Maranhco	837588	BRA	343507
223	Maceió	BRA	Alagoas	786288	BRA	343507
224	Duque de Caxias	BRA	Rio de Janeiro	746758	BRA	343507
225	Sco Bernardo do Campo	BRA	Sco Paulo	723132	BRA	343507
226	Teresina	BRA	Piauk	691942	BRA	343507
227	Natal	BRA	Rio Grande do Norte	688955	BRA	343507
228	Osasco	BRA	Sco Paulo	659604	BRA	343507
229	Campo Grande	BRA	Mato Grosso do Sul	649593	BRA	343507
230	Santo André	BRA	Sco Paulo	630073	BRA	343507
231	Joco Pessoa	BRA	Parakba	584029	BRA	343507
232	Jaboatco dos Guararapes	BRA	Pernambuco	558680	BRA	343507
233	Contagem	BRA	Minas Gerais	520801	BRA	343507
234	Sco José dos Campos	BRA	Sco Paulo	515553	BRA	343507
235	Uberlandia	BRA	Minas Gerais	487222	BRA	343507
236	Feira de Santana	BRA	Bahia	479992	BRA	343507
237	Ribeirco Preto	BRA	Sco Paulo	473276	BRA	343507
238	Sorocaba	BRA	Sco Paulo	466823	BRA	343507
239	Niterói	BRA	Rio de Janeiro	459884	BRA	343507
240	Cuiabi	BRA	Mato Grosso	453813	BRA	343507
241	Juiz de Fora	BRA	Minas Gerais	450288	BRA	343507
242	Aracaju	BRA	Sergipe	445555	BRA	343507
243	Sco Joco de Meriti	BRA	Rio de Janeiro	440052	BRA	343507
244	Londrina	BRA	Parani	432257	BRA	343507
245	Joinville	BRA	Santa Catarina	428011	BRA	343507
246	Belford Roxo	BRA	Rio de Janeiro	425194	BRA	343507
247	Santos	BRA	Sco Paulo	408748	BRA	343507
248	Ananindeua	BRA	Pari	400940	BRA	343507
249	Campos dos Goytacazes	BRA	Rio de Janeiro	398418	BRA	343507
250	Maui	BRA	Sco Paulo	375055	BRA	343507
251	Carapicukba	BRA	Sco Paulo	357552	BRA	343507
252	Olinda	BRA	Pernambuco	354732	BRA	343507
253	Campina Grande	BRA	Parakba	352497	BRA	343507
254	Sco José do Rio Preto	BRA	Sco Paulo	351944	BRA	343507
255	Caxias do Sul	BRA	Rio Grande do Sul	349581	BRA	343507
204	Gaborone	BWA	Gaborone	213017	BWA	157411
1810	Montréal	CAN	Québec	1016376	CAN	258649
1811	Calgary	CAN	Alberta	768082	CAN	258649
1812	Toronto	CAN	Ontario	688275	CAN	258649
1813	North York	CAN	Ontario	622632	CAN	258649
1814	Winnipeg	CAN	Manitoba	618477	CAN	258649
1815	Edmonton	CAN	Alberta	616306	CAN	258649
1816	Mississauga	CAN	Ontario	608072	CAN	258649
1817	Scarborough	CAN	Ontario	594501	CAN	258649
1818	Vancouver	CAN	British Colombia	514008	CAN	258649
1819	Etobicoke	CAN	Ontario	348845	CAN	258649
1820	London	CAN	Ontario	339917	CAN	258649
1821	Hamilton	CAN	Ontario	335614	CAN	258649
1822	Ottawa	CAN	Ontario	335277	CAN	258649
1823	Laval	CAN	Québec	330393	CAN	258649
1824	Surrey	CAN	British Colombia	304477	CAN	258649
1825	Brampton	CAN	Ontario	296711	CAN	258649
2316	Bantam	CCK	Home Island	503	CCK	335
3245	Zürich	CHE	Zürich	336800	CHE	182840
554	Santiago de Chile	CHL	Santiago	4703954	CHL	335102
555	Puente Alto	CHL	Santiago	386236	CHL	335102
1890	Shanghai	CHN	Shanghai	9696300	CHN	484720
1891	Peking	CHN	Peking	7472000	CHN	484720
1892	Chongqing	CHN	Chongqing	6351600	CHN	484720
1893	Tianjin	CHN	Tianjin	5286800	CHN	484720
1894	Wuhan	CHN	Hubei	4344600	CHN	484720
1895	Harbin	CHN	Heilongjiang	4289800	CHN	484720
1896	Shenyang	CHN	Liaoning	4265200	CHN	484720
1897	Kanton [Guangzhou]	CHN	Guangdong	4256300	CHN	484720
1898	Chengdu	CHN	Sichuan	3361500	CHN	484720
1899	Nanking [Nanjing]	CHN	Jiangsu	2870300	CHN	484720
1900	Changchun	CHN	Jilin	2812000	CHN	484720
1901	Xi´an	CHN	Shaanxi	2761400	CHN	484720
1902	Dalian	CHN	Liaoning	2697000	CHN	484720
1903	Qingdao	CHN	Shandong	2596000	CHN	484720
1904	Jinan	CHN	Shandong	2278100	CHN	484720
1905	Hangzhou	CHN	Zhejiang	2190500	CHN	484720
1906	Zhengzhou	CHN	Henan	2107200	CHN	484720
1907	Shijiazhuang	CHN	Hebei	2041500	CHN	484720
1908	Taiyuan	CHN	Shanxi	1968400	CHN	484720
1909	Kunming	CHN	Yunnan	1829500	CHN	484720
1910	Changsha	CHN	Hunan	1809800	CHN	484720
1911	Nanchang	CHN	Jiangxi	1691600	CHN	484720
1912	Fuzhou	CHN	Fujian	1593800	CHN	484720
1913	Lanzhou	CHN	Gansu	1565800	CHN	484720
1914	Guiyang	CHN	Guizhou	1465200	CHN	484720
1915	Ningbo	CHN	Zhejiang	1371200	CHN	484720
1916	Hefei	CHN	Anhui	1369100	CHN	484720
1917	Urumtši [Ürümqi]	CHN	Xinxiang	1310100	CHN	484720
1918	Anshan	CHN	Liaoning	1200000	CHN	484720
1919	Fushun	CHN	Liaoning	1200000	CHN	484720
1920	Nanning	CHN	Guangxi	1161800	CHN	484720
1921	Zibo	CHN	Shandong	1140000	CHN	484720
1922	Qiqihar	CHN	Heilongjiang	1070000	CHN	484720
1923	Jilin	CHN	Jilin	1040000	CHN	484720
1924	Tangshan	CHN	Hebei	1040000	CHN	484720
1925	Baotou	CHN	Inner Mongolia	980000	CHN	484720
1926	Shenzhen	CHN	Guangdong	950500	CHN	484720
1927	Hohhot	CHN	Inner Mongolia	916700	CHN	484720
1928	Handan	CHN	Hebei	840000	CHN	484720
1929	Wuxi	CHN	Jiangsu	830000	CHN	484720
1930	Xuzhou	CHN	Jiangsu	810000	CHN	484720
1931	Datong	CHN	Shanxi	800000	CHN	484720
1932	Yichun	CHN	Heilongjiang	800000	CHN	484720
1933	Benxi	CHN	Liaoning	770000	CHN	484720
1934	Luoyang	CHN	Henan	760000	CHN	484720
1935	Suzhou	CHN	Jiangsu	710000	CHN	484720
1936	Xining	CHN	Qinghai	700200	CHN	484720
1937	Huainan	CHN	Anhui	700000	CHN	484720
1938	Jixi	CHN	Heilongjiang	683885	CHN	484720
1939	Daqing	CHN	Heilongjiang	660000	CHN	484720
1940	Fuxin	CHN	Liaoning	640000	CHN	484720
1941	Amoy [Xiamen]	CHN	Fujian	627500	CHN	484720
1942	Liuzhou	CHN	Guangxi	610000	CHN	484720
1943	Shantou	CHN	Guangdong	580000	CHN	484720
1944	Jinzhou	CHN	Liaoning	570000	CHN	484720
1945	Mudanjiang	CHN	Heilongjiang	570000	CHN	484720
1946	Yinchuan	CHN	Ningxia	544500	CHN	484720
1947	Changzhou	CHN	Jiangsu	530000	CHN	484720
1948	Zhangjiakou	CHN	Hebei	530000	CHN	484720
1949	Dandong	CHN	Liaoning	520000	CHN	484720
1950	Hegang	CHN	Heilongjiang	520000	CHN	484720
1951	Kaifeng	CHN	Henan	510000	CHN	484720
1952	Jiamusi	CHN	Heilongjiang	493409	CHN	484720
1953	Liaoyang	CHN	Liaoning	492559	CHN	484720
1954	Hengyang	CHN	Hunan	487148	CHN	484720
2812	Abidjan	CIV	Abidjan	2500000	CIV	638227
1803	Douala	CMR	Littoral	1448300	CMR	503222
1804	Yaoundé	CMR	Centre	1372800	CMR	503222
2298	Kinshasa	COD	Kinshasa	5064000	COD	548034
2299	Lubumbashi	COD	Shaba	851381	COD	548034
2300	Mbuji-Mayi	COD	East Kasai	806475	COD	548034
2296	Brazzaville	COG	Brazzaville	950000	COG	725000
2257	Santafé de Bogoti	COL	Santafé de Bogoti	6260862	COL	532920
2258	Cali	COL	Valle	2077386	COL	532920
2259	Medellkn	COL	Antioquia	1861265	COL	532920
2260	Barranquilla	COL	Atlintico	1223260	COL	532920
2261	Cartagena	COL	Bolkvar	805757	COL	532920
2262	Cscuta	COL	Norte de Santander	606932	COL	532920
2413	La Habana	CUB	La Habana	2256000	CUB	330708
2414	Santiago de Cuba	CUB	Santiago de Cuba	433180	CUB	330708
2430	Nicosia	CYP	Nicosia	195000	CYP	174700
3339	Praha	CZE	Hlavnk mesto Praha	1181126	CZE	263471
3340	Brno	CZE	Jiznk Morava	381862	CZE	263471
3341	Ostrava	CZE	Severnk Morava	320041	CZE	263471
3068	Berlin	DEU	Berliini	3386667	DEU	282209
3069	Hamburg	DEU	Hamburg	1704735	DEU	282209
3070	Munich [München]	DEU	Baijeri	1194560	DEU	282209
3071	Köln	DEU	Nordrhein-Westfalen	962507	DEU	282209
3072	Frankfurt am Main	DEU	Hessen	643821	DEU	282209
3073	Essen	DEU	Nordrhein-Westfalen	599515	DEU	282209
3074	Dortmund	DEU	Nordrhein-Westfalen	590213	DEU	282209
3075	Stuttgart	DEU	Baden-Württemberg	582443	DEU	282209
3076	Düsseldorf	DEU	Nordrhein-Westfalen	568855	DEU	282209
3077	Bremen	DEU	Bremen	540330	DEU	282209
3078	Duisburg	DEU	Nordrhein-Westfalen	519793	DEU	282209
3079	Hannover	DEU	Niedersachsen	514718	DEU	282209
3080	Leipzig	DEU	Saksi	489532	DEU	282209
3081	Nürnberg	DEU	Baijeri	486628	DEU	282209
3082	Dresden	DEU	Saksi	476668	DEU	282209
3083	Bochum	DEU	Nordrhein-Westfalen	392830	DEU	282209
3084	Wuppertal	DEU	Nordrhein-Westfalen	368993	DEU	282209
3085	Bielefeld	DEU	Nordrhein-Westfalen	321125	DEU	282209
3086	Mannheim	DEU	Baden-Württemberg	307730	DEU	282209
3087	Bonn	DEU	Nordrhein-Westfalen	301048	DEU	282209
3315	Kubenhavn	DNK	Kubenhavn	495699	DNK	243189
3316	Århus	DNK	Århus	284846	DNK	243189
587	Santo Domingo de Guzmin	DOM	Distrito Nacional	1609966	DOM	406379
35	Alger	DZA	Alger	2168000	DZA	288454
36	Oran	DZA	Oran	609823	DZA	288454
37	Constantine	DZA	Constantine	443727	DZA	288454
593	Guayaquil	ECU	Guayas	2070040	ECU	382942
594	Quito	ECU	Pichincha	1573458	ECU	382942
608	Cairo	EGY	Kairo	6789479	EGY	542785
609	Alexandria	EGY	Aleksandria	3328196	EGY	542785
610	Giza	EGY	Giza	2221868	EGY	542785
611	Shubra al-Khayma	EGY	al-Qalyubiya	870716	EGY	542785
653	Madrid	ESP	Madrid	2879052	ESP	282528
654	Barcelona	ESP	Katalonia	1503451	ESP	282528
655	Valencia	ESP	Valencia	739412	ESP	282528
656	Sevilla	ESP	Andalusia	701927	ESP	282528
657	Zaragoza	ESP	Aragonia	603367	ESP	282528
658	Milaga	ESP	Andalusia	530553	ESP	282528
659	Bilbao	ESP	Baskimaa	357589	ESP	282528
660	Las Palmas de Gran Canaria	ESP	Canary Islands	354757	ESP	282528
661	Murcia	ESP	Murcia	353504	ESP	282528
662	Palma de Mallorca	ESP	Balears	326993	ESP	282528
663	Valladolid	ESP	Castilla and León	319998	ESP	282528
664	Córdoba	ESP	Andalusia	311708	ESP	282528
665	Vigo	ESP	Galicia	283670	ESP	282528
3791	Tallinn	EST	Harjumaa	403981	EST	252613
756	Addis Abeba	ETH	Addis Abeba	2495000	ETH	455762
3236	Helsinki [Helsingfors]	FIN	Newmaa	555474	FIN	218988
2974	Paris	FRA	Ile-de-France	2125246	FRA	231112
2975	Marseille	FRA	Provence-Alpes-Cote	798430	FRA	231112
2976	Lyon	FRA	Rhone-Alpes	445452	FRA	231112
2977	Toulouse	FRA	Midi-Pyrénées	390350	FRA	231112
2978	Nice	FRA	Provence-Alpes-Cote	342738	FRA	231112
2979	Nantes	FRA	Pays de la Loire	270251	FRA	231112
2980	Strasbourg	FRA	Alsace	264115	FRA	231112
2688	Weno	FSM	Chuuk	22000	FSM	15300
456	London	GBR	England	7285000	GBR	276995
457	Birmingham	GBR	England	1013000	GBR	276995
458	Glasgow	GBR	Scotland	619680	GBR	276995
459	Liverpool	GBR	England	461000	GBR	276995
460	Edinburgh	GBR	Scotland	450180	GBR	276995
461	Sheffield	GBR	England	431607	GBR	276995
462	Manchester	GBR	England	430000	GBR	276995
463	Leeds	GBR	England	424194	GBR	276995
464	Bristol	GBR	England	402000	GBR	276995
465	Cardiff	GBR	Wales	321000	GBR	276995
466	Coventry	GBR	England	304000	GBR	276995
467	Leicester	GBR	England	294000	GBR	276995
468	Bradford	GBR	England	289376	GBR	276995
469	Belfast	GBR	North Ireland	287500	GBR	276995
470	Nottingham	GBR	England	287000	GBR	276995
905	Tbilisi	GEO	Tbilisi	1235200	GEO	376180
910	Accra	GHA	Greater Accra	1070000	GHA	363977
911	Kumasi	GHA	Ashanti	385192	GHA	363977
918	Les Abymes	GLP	Grande-Terre	62947	GLP	37690
903	Serekunda	GMB	Kombo St Mary	102600	GMB	72463
2401	Athenai	GRC	Attika	772072	GRC	246605
2402	Thessaloniki	GRC	Central Macedonia	383967	GRC	246605
922	Ciudad de Guatemala	GTM	Guatemala	823301	GTM	306297
920	Tamuning	GUM	NULL	9500	GUM	5319
936	Kowloon and New Kowloon	HKG	Kowloon and New Kowl	1987996	HKG	1650316
933	Tegucigalpa	HND	Distrito Central	813900	HND	429000
2409	Zagreb	HRV	Grad Zagreb	706770	HRV	292220
929	Port-au-Prince	HTI	Ouest	884472	HTI	379334
3483	Budapest	HUN	Budapest	1811552	HUN	328145
939	Jakarta	IDN	Jakarta Raya	9604900	IDN	441008
940	Surabaya	IDN	East Java	2663820	IDN	441008
941	Bandung	IDN	West Java	2429000	IDN	441008
942	Medan	IDN	Sumatera Utara	1843919	IDN	441008
943	Palembang	IDN	Sumatera Selatan	1222764	IDN	441008
944	Tangerang	IDN	West Java	1198300	IDN	441008
945	Semarang	IDN	Central Java	1104405	IDN	441008
946	Ujung Pandang	IDN	Sulawesi Selatan	1060257	IDN	441008
947	Malang	IDN	East Java	716862	IDN	441008
948	Bandar Lampung	IDN	Lampung	680332	IDN	441008
949	Bekasi	IDN	West Java	644300	IDN	441008
950	Padang	IDN	Sumatera Barat	534474	IDN	441008
951	Surakarta	IDN	Central Java	518600	IDN	441008
952	Banjarmasin	IDN	Kalimantan Selatan	482931	IDN	441008
1024	Mumbai (Bombay)	IND	Maharashtra	10500000	IND	361579
1025	Delhi	IND	Delhi	7206704	IND	361579
1026	Calcutta [Kolkata]	IND	West Bengali	4399819	IND	361579
1027	Chennai (Madras)	IND	Tamil Nadu	3841396	IND	361579
1028	Hyderabad	IND	Andhra Pradesh	2964638	IND	361579
1029	Ahmedabad	IND	Gujarat	2876710	IND	361579
1030	Bangalore	IND	Karnataka	2660088	IND	361579
1031	Kanpur	IND	Uttar Pradesh	1874409	IND	361579
1032	Nagpur	IND	Maharashtra	1624752	IND	361579
1033	Lucknow	IND	Uttar Pradesh	1619115	IND	361579
1034	Pune	IND	Maharashtra	1566651	IND	361579
1035	Surat	IND	Gujarat	1498817	IND	361579
1036	Jaipur	IND	Rajasthan	1458483	IND	361579
1037	Indore	IND	Madhya Pradesh	1091674	IND	361579
1038	Bhopal	IND	Madhya Pradesh	1062771	IND	361579
1039	Ludhiana	IND	Punjab	1042740	IND	361579
1040	Vadodara (Baroda)	IND	Gujarat	1031346	IND	361579
1041	Kalyan	IND	Maharashtra	1014557	IND	361579
1042	Madurai	IND	Tamil Nadu	977856	IND	361579
1043	Haora (Howrah)	IND	West Bengali	950435	IND	361579
1044	Varanasi (Benares)	IND	Uttar Pradesh	929270	IND	361579
1045	Patna	IND	Bihar	917243	IND	361579
1046	Srinagar	IND	Jammu and Kashmir	892506	IND	361579
1047	Agra	IND	Uttar Pradesh	891790	IND	361579
1048	Coimbatore	IND	Tamil Nadu	816321	IND	361579
1049	Thane (Thana)	IND	Maharashtra	803389	IND	361579
1050	Allahabad	IND	Uttar Pradesh	792858	IND	361579
1051	Meerut	IND	Uttar Pradesh	753778	IND	361579
1052	Vishakhapatnam	IND	Andhra Pradesh	752037	IND	361579
1053	Jabalpur	IND	Madhya Pradesh	741927	IND	361579
1054	Amritsar	IND	Punjab	708835	IND	361579
1055	Faridabad	IND	Haryana	703592	IND	361579
1056	Vijayawada	IND	Andhra Pradesh	701827	IND	361579
1057	Gwalior	IND	Madhya Pradesh	690765	IND	361579
1058	Jodhpur	IND	Rajasthan	666279	IND	361579
1059	Nashik (Nasik)	IND	Maharashtra	656925	IND	361579
1060	Hubli-Dharwad	IND	Karnataka	648298	IND	361579
1061	Solapur (Sholapur)	IND	Maharashtra	604215	IND	361579
1062	Ranchi	IND	Jharkhand	599306	IND	361579
1063	Bareilly	IND	Uttar Pradesh	587211	IND	361579
1064	Guwahati (Gauhati)	IND	Assam	584342	IND	361579
1065	Shambajinagar (Aurangabad)	IND	Maharashtra	573272	IND	361579
1066	Cochin (Kochi)	IND	Kerala	564589	IND	361579
1067	Rajkot	IND	Gujarat	559407	IND	361579
1068	Kota	IND	Rajasthan	537371	IND	361579
1069	Thiruvananthapuram (Trivandrum	IND	Kerala	524006	IND	361579
1070	Pimpri-Chinchwad	IND	Maharashtra	517083	IND	361579
1071	Jalandhar (Jullundur)	IND	Punjab	509510	IND	361579
1072	Gorakhpur	IND	Uttar Pradesh	505566	IND	361579
1073	Chandigarh	IND	Chandigarh	504094	IND	361579
1074	Mysore	IND	Karnataka	480692	IND	361579
1075	Aligarh	IND	Uttar Pradesh	480520	IND	361579
1076	Guntur	IND	Andhra Pradesh	471051	IND	361579
1077	Jamshedpur	IND	Jharkhand	460577	IND	361579
1078	Ghaziabad	IND	Uttar Pradesh	454156	IND	361579
1079	Warangal	IND	Andhra Pradesh	447657	IND	361579
1080	Raipur	IND	Chhatisgarh	438639	IND	361579
1081	Moradabad	IND	Uttar Pradesh	429214	IND	361579
1082	Durgapur	IND	West Bengali	425836	IND	361579
1083	Amravati	IND	Maharashtra	421576	IND	361579
1084	Calicut (Kozhikode)	IND	Kerala	419831	IND	361579
1085	Bikaner	IND	Rajasthan	416289	IND	361579
1086	Bhubaneswar	IND	Orissa	411542	IND	361579
1087	Kolhapur	IND	Maharashtra	406370	IND	361579
1088	Kataka (Cuttack)	IND	Orissa	403418	IND	361579
1089	Ajmer	IND	Rajasthan	402700	IND	361579
1090	Bhavnagar	IND	Gujarat	402338	IND	361579
1091	Tiruchirapalli	IND	Tamil Nadu	387223	IND	361579
1092	Bhilai	IND	Chhatisgarh	386159	IND	361579
1093	Bhiwandi	IND	Maharashtra	379070	IND	361579
1094	Saharanpur	IND	Uttar Pradesh	374945	IND	361579
1095	Ulhasnagar	IND	Maharashtra	369077	IND	361579
1096	Salem	IND	Tamil Nadu	366712	IND	361579
1097	Ujjain	IND	Madhya Pradesh	362266	IND	361579
1447	Dublin	IRL	Leinster	481854	IRL	304520
1380	Teheran	IRN	Teheran	6758845	IRN	388552
1381	Mashhad	IRN	Khorasan	1887405	IRN	388552
1382	Esfahan	IRN	Esfahan	1266072	IRN	388552
1383	Tabriz	IRN	East Azerbaidzan	1191043	IRN	388552
1384	Shiraz	IRN	Fars	1053025	IRN	388552
1385	Karaj	IRN	Teheran	940968	IRN	388552
1386	Ahvaz	IRN	Khuzestan	804980	IRN	388552
1387	Qom	IRN	Qom	777677	IRN	388552
1388	Kermanshah	IRN	Kermanshah	692986	IRN	388552
1389	Urmia	IRN	West Azerbaidzan	435200	IRN	388552
1390	Zahedan	IRN	Sistan va Baluchesta	419518	IRN	388552
1391	Rasht	IRN	Gilan	417748	IRN	388552
1392	Hamadan	IRN	Hamadan	401281	IRN	388552
1365	Baghdad	IRQ	Baghdad	4336000	IRQ	595069
1366	Mosul	IRQ	Ninawa	879000	IRQ	595069
1450	Jerusalem	ISR	Jerusalem	633700	ISR	200928
1451	Tel Aviv-Jaffa	ISR	Tel Aviv	348100	ISR	200928
1452	Haifa	ISR	Haifa	265700	ISR	200928
1464	Roma	ITA	Latium	2643581	ITA	260121
1465	Milano	ITA	Lombardia	1300977	ITA	260121
1466	Napoli	ITA	Campania	1002619	ITA	260121
1467	Torino	ITA	Piemonte	903705	ITA	260121
1468	Palermo	ITA	Sisilia	683794	ITA	260121
1469	Genova	ITA	Liguria	636104	ITA	260121
1470	Bologna	ITA	Emilia-Romagna	381161	ITA	260121
1471	Firenze	ITA	Toscana	376662	ITA	260121
1472	Catania	ITA	Sisilia	337862	ITA	260121
1473	Bari	ITA	Apulia	331848	ITA	260121
1474	Venezia	ITA	Veneto	277305	ITA	260121
1529	Spanish Town	JAM	St. Catherine	110379	JAM	104713
1786	Amman	JOR	Amman	1000000	JOR	369535
1787	al-Zarqa	JOR	al-Zarqa	389815	JOR	369535
1532	Tokyo	JPN	Tokyo-to	7980230	JPN	314375
1533	Jokohama [Yokohama]	JPN	Kanagawa	3339594	JPN	314375
1534	Osaka	JPN	Osaka	2595674	JPN	314375
1535	Nagoya	JPN	Aichi	2154376	JPN	314375
1536	Sapporo	JPN	Hokkaido	1790886	JPN	314375
1537	Kioto	JPN	Kyoto	1461974	JPN	314375
1538	Kobe	JPN	Hyogo	1425139	JPN	314375
1539	Fukuoka	JPN	Fukuoka	1308379	JPN	314375
1540	Kawasaki	JPN	Kanagawa	1217359	JPN	314375
1541	Hiroshima	JPN	Hiroshima	1119117	JPN	314375
1542	Kitakyushu	JPN	Fukuoka	1016264	JPN	314375
1543	Sendai	JPN	Miyagi	989975	JPN	314375
1544	Chiba	JPN	Chiba	863930	JPN	314375
1545	Sakai	JPN	Osaka	797735	JPN	314375
1546	Kumamoto	JPN	Kumamoto	656734	JPN	314375
1547	Okayama	JPN	Okayama	624269	JPN	314375
1548	Sagamihara	JPN	Kanagawa	586300	JPN	314375
1549	Hamamatsu	JPN	Shizuoka	568796	JPN	314375
1550	Kagoshima	JPN	Kagoshima	549977	JPN	314375
1551	Funabashi	JPN	Chiba	545299	JPN	314375
1552	Higashiosaka	JPN	Osaka	517785	JPN	314375
1553	Hachioji	JPN	Tokyo-to	513451	JPN	314375
1554	Niigata	JPN	Niigata	497464	JPN	314375
1555	Amagasaki	JPN	Hyogo	481434	JPN	314375
1556	Himeji	JPN	Hyogo	475167	JPN	314375
1557	Shizuoka	JPN	Shizuoka	473854	JPN	314375
1558	Urawa	JPN	Saitama	469675	JPN	314375
1559	Matsuyama	JPN	Ehime	466133	JPN	314375
1560	Matsudo	JPN	Chiba	461126	JPN	314375
1561	Kanazawa	JPN	Ishikawa	455386	JPN	314375
1562	Kawaguchi	JPN	Saitama	452155	JPN	314375
1563	Ichikawa	JPN	Chiba	441893	JPN	314375
1564	Omiya	JPN	Saitama	441649	JPN	314375
1565	Utsunomiya	JPN	Tochigi	440353	JPN	314375
1566	Oita	JPN	Oita	433401	JPN	314375
1567	Nagasaki	JPN	Nagasaki	432759	JPN	314375
1568	Yokosuka	JPN	Kanagawa	430200	JPN	314375
1569	Kurashiki	JPN	Okayama	425103	JPN	314375
1570	Gifu	JPN	Gifu	408007	JPN	314375
1571	Hirakata	JPN	Osaka	403151	JPN	314375
1572	Nishinomiya	JPN	Hyogo	397618	JPN	314375
1573	Toyonaka	JPN	Osaka	396689	JPN	314375
1574	Wakayama	JPN	Wakayama	391233	JPN	314375
1575	Fukuyama	JPN	Hiroshima	376921	JPN	314375
1576	Fujisawa	JPN	Kanagawa	372840	JPN	314375
1577	Asahikawa	JPN	Hokkaido	364813	JPN	314375
1578	Machida	JPN	Tokyo-to	364197	JPN	314375
1579	Nara	JPN	Nara	362812	JPN	314375
1580	Takatsuki	JPN	Osaka	361747	JPN	314375
1581	Iwaki	JPN	Fukushima	361737	JPN	314375
1582	Nagano	JPN	Nagano	361391	JPN	314375
1583	Toyohashi	JPN	Aichi	360066	JPN	314375
1584	Toyota	JPN	Aichi	346090	JPN	314375
1585	Suita	JPN	Osaka	345750	JPN	314375
1586	Takamatsu	JPN	Kagawa	332471	JPN	314375
1587	Koriyama	JPN	Fukushima	330335	JPN	314375
1588	Okazaki	JPN	Aichi	328711	JPN	314375
1589	Kawagoe	JPN	Saitama	327211	JPN	314375
1590	Tokorozawa	JPN	Saitama	325809	JPN	314375
1591	Toyama	JPN	Toyama	325790	JPN	314375
1592	Kochi	JPN	Kochi	324710	JPN	314375
1593	Kashiwa	JPN	Chiba	320296	JPN	314375
1594	Akita	JPN	Akita	314440	JPN	314375
1860	Almaty	KAZ	Almaty Qalasy	1129400	KAZ	261152
1861	Qaraghandy	KAZ	Qaraghandy	436900	KAZ	261152
1862	Shymkent	KAZ	South Kazakstan	360100	KAZ	261152
1863	Taraz	KAZ	Taraz	330100	KAZ	261152
1864	Astana	KAZ	Astana	311200	KAZ	261152
1865	Öskemen	KAZ	East Kazakstan	311000	KAZ	261152
1866	Pavlodar	KAZ	Pavlodar	300500	KAZ	261152
1867	Semey	KAZ	East Kazakstan	269600	KAZ	261152
1881	Nairobi	KEN	Nairobi	2290000	KEN	440349
1882	Mombasa	KEN	Coast	461753	KEN	440349
2253	Bishkek	KGZ	Bishkek shaary	589400	KGZ	406050
1800	Phnom Penh	KHM	Phnom Penh	570155	KHM	268351
2255	Bikenibeu	KIR	South Tarawa	5055	KIR	3640
2331	Seoul	KOR	Seoul	9981619	KOR	557141
2332	Pusan	KOR	Pusan	3804522	KOR	557141
2333	Inchon	KOR	Inchon	2559424	KOR	557141
2334	Taegu	KOR	Taegu	2548568	KOR	557141
2335	Taejon	KOR	Taejon	1425835	KOR	557141
2336	Kwangju	KOR	Kwangju	1368341	KOR	557141
2337	Ulsan	KOR	Kyongsangnam	1084891	KOR	557141
2338	Songnam	KOR	Kyonggi	869094	KOR	557141
2339	Puchon	KOR	Kyonggi	779412	KOR	557141
2340	Suwon	KOR	Kyonggi	755550	KOR	557141
2341	Anyang	KOR	Kyonggi	591106	KOR	557141
2342	Chonju	KOR	Chollabuk	563153	KOR	557141
2427	al-Salimiya	KWT	Hawalli	130215	KWT	87084
2428	Jalib al-Shuyukh	KWT	Hawalli	102178	KWT	87084
2432	Vientiane	LAO	Viangchan	531800	LAO	314226
2438	Beirut	LBN	Beirut	1100000	LBN	670000
2441	Tripoli	LBY	Tripoli	1682000	LBY	674251
2442	Bengasi	LBY	Bengasi	804000	LBY	674251
2445	Schaan	LIE	Schaan	5346	LIE	5194
3217	Colombo	LKA	Western	645000	LKA	220714
2447	Vilnius	LTU	Vilna	577969	LTU	294663
2448	Kaunas	LTU	Kaunas	412639	LTU	294663
2434	Riga	LVA	Riika	764328	LVA	322865
2485	Casablanca	MAR	Casablanca	2940623	MAR	398071
2486	Rabat	MAR	Rabat-Salé-Zammour-Z	623457	MAR	398071
2487	Marrakech	MAR	Marrakech-Tensift-Al	621914	MAR	398071
2488	Fcs	MAR	Fcs-Boulemane	541162	MAR	398071
2489	Tanger	MAR	Tanger-Tétouan	521735	MAR	398071
2490	Salé	MAR	Rabat-Salé-Zammour-Z	504420	MAR	398071
2491	Mekncs	MAR	Mekncs-Tafilalet	460000	MAR	398071
2694	Monte-Carlo	MCO	NULL	13154	MCO	7194
2690	Chisinau	MDA	Chisinau	719900	MDA	298325
2455	Antananarivo	MDG	Antananarivo	675669	MDG	224632
2515	Ciudad de México	MEX	Distrito Federal	8591309	MEX	345390
2516	Guadalajara	MEX	Jalisco	1647720	MEX	345390
2517	Ecatepec de Morelos	MEX	México	1620303	MEX	345390
2518	Puebla	MEX	Puebla	1346176	MEX	345390
2519	Nezahualcóyotl	MEX	México	1224924	MEX	345390
2520	Juirez	MEX	Chihuahua	1217818	MEX	345390
2521	Tijuana	MEX	Baja California	1212232	MEX	345390
2522	León	MEX	Guanajuato	1133576	MEX	345390
2523	Monterrey	MEX	Nuevo León	1108499	MEX	345390
2524	Zapopan	MEX	Jalisco	1002239	MEX	345390
2525	Naucalpan de Juirez	MEX	México	857511	MEX	345390
2526	Mexicali	MEX	Baja California	764902	MEX	345390
2527	Culiacin	MEX	Sinaloa	744859	MEX	345390
2528	Acapulco de Juirez	MEX	Guerrero	721011	MEX	345390
2529	Tlalnepantla de Baz	MEX	México	720755	MEX	345390
2530	Mérida	MEX	Yucatin	703324	MEX	345390
2531	Chihuahua	MEX	Chihuahua	670208	MEX	345390
2532	San Luis Potosk	MEX	San Luis Potosk	669353	MEX	345390
2533	Guadalupe	MEX	Nuevo León	668780	MEX	345390
2534	Toluca	MEX	México	665617	MEX	345390
2535	Aguascalientes	MEX	Aguascalientes	643360	MEX	345390
2536	Querétaro	MEX	Querétaro de Arteaga	639839	MEX	345390
2537	Morelia	MEX	Michoacin de Ocampo	619958	MEX	345390
2538	Hermosillo	MEX	Sonora	608697	MEX	345390
2539	Saltillo	MEX	Coahuila de Zaragoza	577352	MEX	345390
2540	Torreón	MEX	Coahuila de Zaragoza	529093	MEX	345390
2541	Centro (Villahermosa)	MEX	Tabasco	519873	MEX	345390
2542	San Nicolis de los Garza	MEX	Nuevo León	495540	MEX	345390
2543	Durango	MEX	Durango	490524	MEX	345390
2544	Chimalhuacin	MEX	México	490245	MEX	345390
2545	Tlaquepaque	MEX	Jalisco	475472	MEX	345390
2546	Atizapin de Zaragoza	MEX	México	467262	MEX	345390
2547	Veracruz	MEX	Veracruz	457119	MEX	345390
2548	Cuautitlin Izcalli	MEX	México	452976	MEX	345390
2549	Irapuato	MEX	Guanajuato	440039	MEX	345390
2550	Tuxtla Gutiérrez	MEX	Chiapas	433544	MEX	345390
2551	Tultitlin	MEX	México	432411	MEX	345390
2552	Reynosa	MEX	Tamaulipas	419776	MEX	345390
2553	Benito Juirez	MEX	Quintana Roo	419276	MEX	345390
2554	Matamoros	MEX	Tamaulipas	416428	MEX	345390
2555	Xalapa	MEX	Veracruz	390058	MEX	345390
2556	Celaya	MEX	Guanajuato	382140	MEX	345390
2557	Mazatlin	MEX	Sinaloa	380265	MEX	345390
2558	Ensenada	MEX	Baja California	369573	MEX	345390
2559	Ahome	MEX	Sinaloa	358663	MEX	345390
2560	Cajeme	MEX	Sonora	355679	MEX	345390
2483	Birkirkara	MLT	Outer Harbour	21445	MLT	14259
2710	Rangoon (Yangon)	MMR	Rangoon [Yangon]	3361700	MMR	387687
2711	Mandalay	MMR	Mandalay	885300	MMR	387687
2698	Maputo	MOZ	Maputo	1018938	MOZ	261928
2699	Matola	MOZ	Maputo	424662	MOZ	261928
2700	Beira	MOZ	Sofala	397368	MOZ	261928
2701	Nampula	MOZ	Nampula	303346	MOZ	261928
2509	Nouakchott	MRT	Nouakchott	667300	MRT	382450
2511	Port-Louis	MUS	Port-Louis	138200	MUS	112426
2461	Blantyre	MWI	Blantyre	478155	MWI	457059
2464	Kuala Lumpur	MYS	Wilayah Persekutuan	1297526	MYS	255841
2465	Ipoh	MYS	Perak	382853	MYS	255841
2466	Johor Baharu	MYS	Johor	328436	MYS	255841
2738	Niamey	NER	Niamey	420000	NER	217952
2741	Lagos	NGA	Lagos	1518000	NGA	271357
2742	Ibadan	NGA	Oyo & Osun	1432000	NGA	271357
2743	Ogbomosho	NGA	Oyo & Osun	730000	NGA	271357
2744	Kano	NGA	Kano & Jigawa	674100	NGA	271357
2745	Oshogbo	NGA	Oyo & Osun	476800	NGA	271357
2746	Ilorin	NGA	Kwara & Kogi	475800	NGA	271357
2747	Abeokuta	NGA	Ogun	427400	NGA	271357
2748	Port Harcourt	NGA	Rivers & Bayelsa	410000	NGA	271357
2749	Zaria	NGA	Kaduna	379200	NGA	271357
2750	Ilesha	NGA	Oyo & Osun	378400	NGA	271357
2751	Onitsha	NGA	Anambra & Enugu & Eb	371900	NGA	271357
2752	Iwo	NGA	Oyo & Osun	362000	NGA	271357
2753	Ado-Ekiti	NGA	Ondo & Ekiti	359400	NGA	271357
2754	Abuja	NGA	Federal Capital Dist	350100	NGA	271357
2755	Kaduna	NGA	Kaduna	342200	NGA	271357
2756	Mushin	NGA	Lagos	333200	NGA	271357
2757	Maiduguri	NGA	Borno & Yobe	320000	NGA	271357
2758	Enugu	NGA	Anambra & Enugu & Eb	316100	NGA	271357
2759	Ede	NGA	Oyo & Osun	307100	NGA	271357
2760	Aba	NGA	Imo & Abia	298900	NGA	271357
2761	Ife	NGA	Oyo & Osun	296800	NGA	271357
2734	Managua	NIC	Managua	959000	NIC	317305
5	Amsterdam	NLD	Noord-Holland	731200	NLD	185001
6	Rotterdam	NLD	Zuid-Holland	593321	NLD	185001
7	Haag	NLD	Zuid-Holland	440900	NLD	185001
8	Utrecht	NLD	Utrecht	234323	NLD	185001
9	Eindhoven	NLD	Noord-Brabant	201843	NLD	185001
10	Tilburg	NLD	Noord-Brabant	193238	NLD	185001
2807	Oslo	NOR	Oslo	508726	NOR	220005
2808	Bergen	NOR	Hordaland	230948	NOR	220005
2729	Kathmandu	NPL	Central	591835	NPL	226480
2727	Yangor	NRU	NULL	4050	NRU	2304
3494	Auckland	NZL	Auckland	381800	NZL	205288
3495	Christchurch	NZL	Canterbury	324200	NZL	205288
3496	Manukau	NZL	Auckland	281800	NZL	205288
2817	al-Sib	OMN	Masqat	155000	OMN	107419
2818	Salala	OMN	Zufar	131813	OMN	107419
2819	Bawshar	OMN	Masqat	107500	OMN	107419
2822	Karachi	PAK	Sindh	9269265	PAK	534690
2823	Lahore	PAK	Punjab	5063499	PAK	534690
2824	Faisalabad	PAK	Punjab	1977246	PAK	534690
2825	Rawalpindi	PAK	Punjab	1406214	PAK	534690
2826	Multan	PAK	Punjab	1182441	PAK	534690
2827	Hyderabad	PAK	Sindh	1151274	PAK	534690
2828	Gujranwala	PAK	Punjab	1124749	PAK	534690
2829	Peshawar	PAK	Nothwest Border Prov	988005	PAK	534690
2830	Quetta	PAK	Baluchistan	560307	PAK	534690
2882	Ciudad de Panami	PAN	Panami	471373	PAN	393377
2890	Lima	PER	Lima	6464693	PER	552147
2891	Arequipa	PER	Arequipa	762000	PER	552147
2892	Trujillo	PER	La Libertad	652000	PER	552147
765	Quezon	PHL	National Capital Reg	2173831	PHL	227461
766	Manila	PHL	National Capital Reg	1581082	PHL	227461
767	Kalookan	PHL	National Capital Reg	1177604	PHL	227461
768	Davao	PHL	Southern Mindanao	1147116	PHL	227461
769	Cebu	PHL	Central Visayas	718821	PHL	227461
770	Zamboanga	PHL	Western Mindanao	601794	PHL	227461
771	Pasig	PHL	National Capital Reg	505058	PHL	227461
772	Valenzuela	PHL	National Capital Reg	485433	PHL	227461
773	Las Pinas	PHL	National Capital Reg	472780	PHL	227461
774	Antipolo	PHL	Southern Tagalog	470866	PHL	227461
775	Taguig	PHL	National Capital Reg	467375	PHL	227461
776	Cagayan de Oro	PHL	Northern Mindanao	461877	PHL	227461
777	Paranaque	PHL	National Capital Reg	449811	PHL	227461
778	Makati	PHL	National Capital Reg	444867	PHL	227461
779	Bacolod	PHL	Western Visayas	429076	PHL	227461
780	General Santos	PHL	Southern Mindanao	411822	PHL	227461
781	Marikina	PHL	National Capital Reg	391170	PHL	227461
782	Dasmarinas	PHL	Southern Tagalog	379520	PHL	227461
783	Muntinlupa	PHL	National Capital Reg	379310	PHL	227461
784	Iloilo	PHL	Western Visayas	365820	PHL	227461
785	Pasay	PHL	National Capital Reg	354908	PHL	227461
786	Malabon	PHL	National Capital Reg	338855	PHL	227461
787	San José del Monte	PHL	Central Luzon	315807	PHL	227461
788	Bacoor	PHL	Southern Tagalog	305699	PHL	227461
789	Iligan	PHL	Central Mindanao	285061	PHL	227461
790	Calamba	PHL	Southern Tagalog	281146	PHL	227461
791	Mandaluyong	PHL	National Capital Reg	278474	PHL	227461
792	Butuan	PHL	Caraga	267279	PHL	227461
793	Angeles	PHL	Central Luzon	263971	PHL	227461
794	Tarlac	PHL	Central Luzon	262481	PHL	227461
795	Mandaue	PHL	Central Visayas	259728	PHL	227461
796	Baguio	PHL	CAR	252386	PHL	227461
797	Batangas	PHL	Southern Tagalog	247588	PHL	227461
798	Cainta	PHL	Southern Tagalog	242511	PHL	227461
799	San Pedro	PHL	Southern Tagalog	231403	PHL	227461
800	Navotas	PHL	National Capital Reg	230403	PHL	227461
2928	Warszawa	POL	Mazowieckie	1615369	POL	265623
2929	Lódz	POL	Lodzkie	800110	POL	265623
2930	Kraków	POL	Malopolskie	738150	POL	265623
2931	Wroclaw	POL	Dolnoslaskie	636765	POL	265623
2932	Poznan	POL	Wielkopolskie	576899	POL	265623
2933	Gdansk	POL	Pomorskie	458988	POL	265623
2934	Szczecin	POL	Zachodnio-Pomorskie	416988	POL	265623
2935	Bydgoszcz	POL	Kujawsko-Pomorskie	386855	POL	265623
2936	Lublin	POL	Lubelskie	356251	POL	265623
2937	Katowice	POL	Slaskie	345934	POL	265623
2938	Bialystok	POL	Podlaskie	283937	POL	265623
2919	San Juan	PRI	San Juan	434374	PRI	173797
2920	Bayamón	PRI	Bayamón	224044	PRI	173797
2921	Ponce	PRI	Ponce	186475	PRI	173797
2922	Carolina	PRI	Carolina	186076	PRI	173797
2318	Pyongyang	PRK	Pyongyang-si	2484000	PRK	498211
2319	Hamhung	PRK	Hamgyong N	709730	PRK	498211
2320	Chongjin	PRK	Hamgyong P	582480	PRK	498211
2321	Nampo	PRK	Nampo-si	566200	PRK	498211
2914	Lisboa	PRT	Lisboa	563210	PRT	229002
2915	Porto	PRT	Porto	273060	PRT	229002
2885	Asunción	PRY	Asunción	557776	PRY	204004
4074	Gaza	PSE	Gaza	353632	PSE	150393
3015	Faaa	PYF	Tahiti	25888	PYF	25720
3018	Bucuresti	ROM	Bukarest	2016131	ROM	257551
3019	Iasi	ROM	Iasi	348070	ROM	257551
3020	Constanta	ROM	Constanta	342264	ROM	257551
3021	Cluj-Napoca	ROM	Cluj	332498	ROM	257551
3022	Galati	ROM	Galati	330276	ROM	257551
3023	Timisoara	ROM	Timis	324304	ROM	257551
3024	Brasov	ROM	Brasov	314225	ROM	257551
3025	Craiova	ROM	Dolj	313530	ROM	257551
3580	Moscow	RUS	Moscow (City)	8389200	RUS	365876
3581	St Petersburg	RUS	Pietari	4694000	RUS	365876
3582	Novosibirsk	RUS	Novosibirsk	1398800	RUS	365876
3583	Nizni Novgorod	RUS	Nizni Novgorod	1357000	RUS	365876
3584	Jekaterinburg	RUS	Sverdlovsk	1266300	RUS	365876
3585	Samara	RUS	Samara	1156100	RUS	365876
3586	Omsk	RUS	Omsk	1148900	RUS	365876
3587	Kazan	RUS	Tatarstan	1101000	RUS	365876
3588	Ufa	RUS	Baškortostan	1091200	RUS	365876
3589	Tšeljabinsk	RUS	Tšeljabinsk	1083200	RUS	365876
3590	Rostov-na-Donu	RUS	Rostov-na-Donu	1012700	RUS	365876
3591	Perm	RUS	Perm	1009700	RUS	365876
3592	Volgograd	RUS	Volgograd	993400	RUS	365876
3593	Voronez	RUS	Voronez	907700	RUS	365876
3594	Krasnojarsk	RUS	Krasnojarsk	875500	RUS	365876
3595	Saratov	RUS	Saratov	874000	RUS	365876
3596	Toljatti	RUS	Samara	722900	RUS	365876
3597	Uljanovsk	RUS	Uljanovsk	667400	RUS	365876
3598	Izevsk	RUS	Udmurtia	652800	RUS	365876
3599	Krasnodar	RUS	Krasnodar	639000	RUS	365876
3600	Jaroslavl	RUS	Jaroslavl	616700	RUS	365876
3601	Habarovsk	RUS	Habarovsk	609400	RUS	365876
3602	Vladivostok	RUS	Primorje	606200	RUS	365876
3603	Irkutsk	RUS	Irkutsk	593700	RUS	365876
3604	Barnaul	RUS	Altai	580100	RUS	365876
3605	Novokuznetsk	RUS	Kemerovo	561600	RUS	365876
3606	Penza	RUS	Penza	532200	RUS	365876
3607	Rjazan	RUS	Rjazan	529900	RUS	365876
3608	Orenburg	RUS	Orenburg	523600	RUS	365876
3609	Lipetsk	RUS	Lipetsk	521000	RUS	365876
3610	Nabereznyje Tšelny	RUS	Tatarstan	514700	RUS	365876
3611	Tula	RUS	Tula	506100	RUS	365876
3612	Tjumen	RUS	Tjumen	503400	RUS	365876
3613	Kemerovo	RUS	Kemerovo	492700	RUS	365876
3614	Astrahan	RUS	Astrahan	486100	RUS	365876
3615	Tomsk	RUS	Tomsk	482100	RUS	365876
3616	Kirov	RUS	Kirov	466200	RUS	365876
3617	Ivanovo	RUS	Ivanovo	459200	RUS	365876
3618	Tšeboksary	RUS	Tšuvassia	459200	RUS	365876
3619	Brjansk	RUS	Brjansk	457400	RUS	365876
3620	Tver	RUS	Tver	454900	RUS	365876
3621	Kursk	RUS	Kursk	443500	RUS	365876
3622	Magnitogorsk	RUS	Tšeljabinsk	427900	RUS	365876
3623	Kaliningrad	RUS	Kaliningrad	424400	RUS	365876
3624	Nizni Tagil	RUS	Sverdlovsk	390900	RUS	365876
3625	Murmansk	RUS	Murmansk	376300	RUS	365876
3626	Ulan-Ude	RUS	Burjatia	370400	RUS	365876
3173	Riyadh	SAU	Riyadh	3324000	SAU	443195
3174	Jedda	SAU	Mekka	2046300	SAU	443195
3175	Mekka	SAU	Mekka	965700	SAU	443195
3176	Medina	SAU	Medina	608300	SAU	443195
3177	al-Dammam	SAU	al-Sharqiya	482300	SAU	443195
3224	Omdurman	SDN	Khartum	1271403	SDN	396015
3225	Khartum	SDN	Khartum	947483	SDN	396015
3226	Sharq al-Nil	SDN	Khartum	700887	SDN	396015
3197	Pikine	SEN	Cap-Vert	855287	SEN	307828
3198	Dakar	SEN	Cap-Vert	785071	SEN	307828
645	San Salvador	SLV	San Salvador	415346	SLV	162604
3170	Serravalle	SMR	Serravalle/Dogano	4802	SMR	3548
3214	Mogadishu	SOM	Banaadir	997000	SOM	392333
3209	Bratislava	SVK	Bratislava	448292	SVK	261381
3212	Ljubljana	SVN	Osrednjeslovenska	270986	SVN	193259
3048	Stockholm	SWE	Lisboa	750348	SWE	192762
3049	Gothenburg [Göteborg]	SWE	West Götanmaan län	466990	SWE	192762
3050	Malmö	SWE	Skåne län	259579	SWE	192762
3250	Damascus	SYR	Damascus	1347000	SYR	407071
3251	Aleppo	SYR	Aleppo	1261983	SYR	407071
3252	Hims	SYR	Hims	507404	SYR	407071
3337	N´Djaména	TCD	Chari-Baguirmi	530965	TCD	315232
3320	Bangkok	THA	Bangkok	6320174	THA	662763
3261	Dushanbe	TJK	Karotegin	524000	TJK	342750
3419	Ashgabat	TKM	Ahal	540600	TKM	243150
3335	Chaguanas	TTO	Caroni	56601	TTO	49998
3349	Tunis	TUN	Tunis	690600	TUN	224812
3350	Sfax	TUN	Sfax	257800	TUN	224812
3357	Istanbul	TUR	Istanbul	8787958	TUR	456887
3358	Ankara	TUR	Ankara	3038159	TUR	456887
3359	Izmir	TUR	Izmir	2130359	TUR	456887
3360	Adana	TUR	Adana	1131198	TUR	456887
3361	Bursa	TUR	Bursa	1095842	TUR	456887
3362	Gaziantep	TUR	Gaziantep	789056	TUR	456887
3363	Konya	TUR	Konya	628364	TUR	456887
3364	Mersin (Ieel)	TUR	Ieel	587212	TUR	456887
3365	Antalya	TUR	Antalya	564914	TUR	456887
3366	Diyarbakir	TUR	Diyarbakir	479884	TUR	456887
3367	Kayseri	TUR	Kayseri	475657	TUR	456887
3368	Eskisehir	TUR	Eskisehir	470781	TUR	456887
3263	Taipei	TWN	Taipei	2641312	TWN	323079
3264	Kaohsiung	TWN	Kaohsiung	1475505	TWN	323079
3265	Taichung	TWN	Taichung	940589	TWN	323079
3266	Tainan	TWN	Tainan	728060	TWN	323079
3267	Panchiao	TWN	Taipei	523850	TWN	323079
3268	Chungho	TWN	Taipei	392176	TWN	323079
3269	Keelung (Chilung)	TWN	Keelung	385201	TWN	323079
3270	Sanchung	TWN	Taipei	380084	TWN	323079
3271	Hsinchuang	TWN	Taipei	365048	TWN	323079
3272	Hsinchu	TWN	Hsinchu	361958	TWN	323079
3305	Dar es Salaam	TZA	Dar es Salaam	1747000	TZA	294403
3426	Kyiv	UKR	Kiova	2624000	UKR	352175
3427	Harkova [Harkiv]	UKR	Harkova	1500000	UKR	352175
3428	Dnipropetrovsk	UKR	Dnipropetrovsk	1103000	UKR	352175
3429	Donetsk	UKR	Donetsk	1050000	UKR	352175
3430	Odesa	UKR	Odesa	1011000	UKR	352175
3431	Zaporizzja	UKR	Zaporizzja	848000	UKR	352175
3432	Lviv	UKR	Lviv	788000	UKR	352175
3433	Kryvyi Rig	UKR	Dnipropetrovsk	703000	UKR	352175
3434	Mykolajiv	UKR	Mykolajiv	508000	UKR	352175
3435	Mariupol	UKR	Donetsk	490000	UKR	352175
3436	Lugansk	UKR	Lugansk	469000	UKR	352175
3437	Vinnytsja	UKR	Vinnytsja	391000	UKR	352175
3438	Makijivka	UKR	Donetsk	384000	UKR	352175
3439	Herson	UKR	Herson	353000	UKR	352175
3793	New York	USA	New York	8008278	USA	286955
3794	Los Angeles	USA	California	3694820	USA	286955
3795	Chicago	USA	Illinois	2896016	USA	286955
3796	Houston	USA	Texas	1953631	USA	286955
3797	Philadelphia	USA	Pennsylvania	1517550	USA	286955
3798	Phoenix	USA	Arizona	1321045	USA	286955
3799	San Diego	USA	California	1223400	USA	286955
3800	Dallas	USA	Texas	1188580	USA	286955
3801	San Antonio	USA	Texas	1144646	USA	286955
3802	Detroit	USA	Michigan	951270	USA	286955
3803	San Jose	USA	California	894943	USA	286955
3804	Indianapolis	USA	Indiana	791926	USA	286955
3805	San Francisco	USA	California	776733	USA	286955
3806	Jacksonville	USA	Florida	735167	USA	286955
3807	Columbus	USA	Ohio	711470	USA	286955
3808	Austin	USA	Texas	656562	USA	286955
3809	Baltimore	USA	Maryland	651154	USA	286955
3810	Memphis	USA	Tennessee	650100	USA	286955
3811	Milwaukee	USA	Wisconsin	596974	USA	286955
3812	Boston	USA	Massachusetts	589141	USA	286955
3813	Washington	USA	District of Columbia	572059	USA	286955
3814	Nashville-Davidson	USA	Tennessee	569891	USA	286955
3815	El Paso	USA	Texas	563662	USA	286955
3816	Seattle	USA	Washington	563374	USA	286955
3817	Denver	USA	Colorado	554636	USA	286955
3818	Charlotte	USA	North Carolina	540828	USA	286955
3819	Fort Worth	USA	Texas	534694	USA	286955
3820	Portland	USA	Oregon	529121	USA	286955
3821	Oklahoma City	USA	Oklahoma	506132	USA	286955
3822	Tucson	USA	Arizona	486699	USA	286955
3823	New Orleans	USA	Louisiana	484674	USA	286955
3824	Las Vegas	USA	Nevada	478434	USA	286955
3825	Cleveland	USA	Ohio	478403	USA	286955
3826	Long Beach	USA	California	461522	USA	286955
3827	Albuquerque	USA	New Mexico	448607	USA	286955
3828	Kansas City	USA	Missouri	441545	USA	286955
3829	Fresno	USA	California	427652	USA	286955
3830	Virginia Beach	USA	Virginia	425257	USA	286955
3831	Atlanta	USA	Georgia	416474	USA	286955
3832	Sacramento	USA	California	407018	USA	286955
3833	Oakland	USA	California	399484	USA	286955
3834	Mesa	USA	Arizona	396375	USA	286955
3835	Tulsa	USA	Oklahoma	393049	USA	286955
3836	Omaha	USA	Nebraska	390007	USA	286955
3837	Minneapolis	USA	Minnesota	382618	USA	286955
3838	Honolulu	USA	Hawaii	371657	USA	286955
3839	Miami	USA	Florida	362470	USA	286955
3840	Colorado Springs	USA	Colorado	360890	USA	286955
3841	Saint Louis	USA	Missouri	348189	USA	286955
3842	Wichita	USA	Kansas	344284	USA	286955
3843	Santa Ana	USA	California	337977	USA	286955
3844	Pittsburgh	USA	Pennsylvania	334563	USA	286955
3845	Arlington	USA	Texas	332969	USA	286955
3846	Cincinnati	USA	Ohio	331285	USA	286955
3847	Anaheim	USA	California	328014	USA	286955
3848	Toledo	USA	Ohio	313619	USA	286955
3849	Tampa	USA	Florida	303447	USA	286955
3850	Buffalo	USA	New York	292648	USA	286955
3851	Saint Paul	USA	Minnesota	287151	USA	286955
3503	Toskent	UZB	Toskent Shahri	2117500	UZB	304935
3504	Namangan	UZB	Namangan	370500	UZB	304935
3505	Samarkand	UZB	Samarkand	361800	UZB	304935
3506	Andijon	UZB	Andijon	318600	UZB	304935
3539	Caracas	VEN	Distrito Federal	1975294	VEN	298807
3540	Maracakbo	VEN	Zulia	1304776	VEN	298807
3541	Barquisimeto	VEN	Lara	877239	VEN	298807
3542	Valencia	VEN	Carabobo	794246	VEN	298807
3543	Ciudad Guayana	VEN	Bolkvar	663713	VEN	298807
3544	Petare	VEN	Miranda	488868	VEN	298807
3545	Maracay	VEN	Aragua	444443	VEN	298807
3546	Barcelona	VEN	Anzoitegui	322267	VEN	298807
3547	Maturkn	VEN	Monagas	319726	VEN	298807
3548	San Cristóbal	VEN	Tichira	319373	VEN	298807
3549	Ciudad Bolkvar	VEN	Bolkvar	301107	VEN	298807
3769	Ho Chi Minh City	VNM	Ho Chi Minh City	3980000	VNM	425673
3770	Hanoi	VNM	Hanoi	1410000	VNM	425673
3771	Haiphong	VNM	Haiphong	783133	VNM	425673
1780	Sanaa	YEM	Sanaa	503600	YEM	290616
1781	Aden	YEM	Aden	398300	YEM	290616
1782	Taizz	YEM	Taizz	317600	YEM	290616
1783	Hodeida	YEM	Hodeida	298500	YEM	290616
1792	Beograd	YUG	Central Serbia	1204000	YUG	273688
712	Cape Town	ZAF	Western Cape	2352121	ZAF	345372
713	Soweto	ZAF	Gauteng	904165	ZAF	345372
714	Johannesburg	ZAF	Gauteng	756653	ZAF	345372
715	Port Elizabeth	ZAF	Eastern Cape	752319	ZAF	345372
716	Pretoria	ZAF	Gauteng	658630	ZAF	345372
717	Inanda	ZAF	KwaZulu-Natal	634065	ZAF	345372
718	Durban	ZAF	KwaZulu-Natal	566120	ZAF	345372
719	Vanderbijlpark	ZAF	Gauteng	468931	ZAF	345372
720	Kempton Park	ZAF	Gauteng	442633	ZAF	345372
721	Alberton	ZAF	Gauteng	410102	ZAF	345372
722	Pinetown	ZAF	KwaZulu-Natal	378810	ZAF	345372
723	Pietermaritzburg	ZAF	KwaZulu-Natal	370190	ZAF	345372
724	Benoni	ZAF	Gauteng	365467	ZAF	345372
3162	Lusaka	ZMB	Lusaka	1317000	ZMB	353357
4068	Harare	ZWE	Harare	1410000	ZWE	455070
4069	Bulawayo	ZWE	Bulawayo	621742	ZWE	455070

WITH Keskm AS
    (SELECT Countrycode, AVG(Population) as AVeragePopulation
    FROm tCity
    GROUP BY CountryCode)
SELECT *
FROM tCity 
WHERE Population > (SELECT AVeragePopulation  
                    FROM Keskm 
                    WHERE tCity.CountryCode= CountryCode )

(915 rows affected)

Total execution time: 00:00:00.083

ID	CityName	CountryCode	District	Population
1	Kabul	AFG	Kabol	1760000
56	Luanda	AGO	Luanda	2022000
61	South Hill	AIA	NULL	961
64	Dubai	ARE	Dubai	669181
65	Abu Dhabi	ARE	Abu Dhabi	398695
69	Buenos Aires	ARG	Distrito Federal	2982146
70	La Matanza	ARG	Buenos Aires	1266461
71	Córdoba	ARG	Córdoba	1157507
72	Rosario	ARG	Santa Fé	907718
73	Lomas de Zamora	ARG	Buenos Aires	622013
74	Quilmes	ARG	Buenos Aires	559249
75	Almirante Brown	ARG	Buenos Aires	538918
76	La Plata	ARG	Buenos Aires	521936
77	Mar del Plata	ARG	Buenos Aires	512880
78	San Miguel de Tucumin	ARG	Tucumin	470809
79	Lanss	ARG	Buenos Aires	469735
80	Merlo	ARG	Buenos Aires	463846
81	General San Martkn	ARG	Buenos Aires	422542
82	Salta	ARG	Salta	367550
83	Moreno	ARG	Buenos Aires	356993
84	Santa Fé	ARG	Santa Fé	353063
85	Avellaneda	ARG	Buenos Aires	353046
86	Tres de Febrero	ARG	Buenos Aires	352311
126	Yerevan	ARM	Yerevan	1248700
53	Tafuna	ASM	Tutuila	5200
130	Sydney	AUS	New South Wales	3276207
131	Melbourne	AUS	Victoria	2865329
132	Brisbane	AUS	Queensland	1291117
133	Perth	AUS	West Australia	1096829
134	Adelaide	AUS	South Australia	978100
1523	Wien	AUT	Wien	1608144
144	Baku	AZE	Baki	1787800
175	Antwerpen	BEL	Antwerpen	446525
176	Gent	BEL	East Flanderi	224180
177	Charleroi	BEL	Hainaut	200827
178	Licge	BEL	Licge	185639
186	Cotonou	BEN	Atlantique	536827
549	Ouagadougou	BFA	Kadiogo	824000
150	Dhaka	BGD	Dhaka	3612850
151	Chittagong	BGD	Chittagong	1392860
152	Khulna	BGD	Khulna	663340
539	Sofija	BGR	Grad Sofija	1122302
540	Plovdiv	BGR	Plovdiv	342584
541	Varna	BGR	Varna	299801
201	Sarajevo	BIH	Federaatio	360000
3520	Minsk	BLR	Horad Minsk	1674000
3521	Gomel	BLR	Gomel	475000
3522	Mogiljov	BLR	Mogiljov	356000
3523	Vitebsk	BLR	Vitebsk	340000
3524	Grodno	BLR	Grodno	302000
184	Belize City	BLZ	Belize City	55810
190	Saint George	BMU	Saint George´s	1800
193	Santa Cruz de la Sierra	BOL	Santa Cruz	935361
194	La Paz	BOL	La Paz	758141
195	El Alto	BOL	La Paz	534466
196	Cochabamba	BOL	Cochabamba	482800
206	Sco Paulo	BRA	Sco Paulo	9968485
207	Rio de Janeiro	BRA	Rio de Janeiro	5598953
208	Salvador	BRA	Bahia	2302832
209	Belo Horizonte	BRA	Minas Gerais	2139125
210	Fortaleza	BRA	Ceari	2097757
211	Brasklia	BRA	Distrito Federal	1969868
212	Curitiba	BRA	Parani	1584232
213	Recife	BRA	Pernambuco	1378087
214	Porto Alegre	BRA	Rio Grande do Sul	1314032
215	Manaus	BRA	Amazonas	1255049
216	Belém	BRA	Pari	1186926
217	Guarulhos	BRA	Sco Paulo	1095874
218	Goiania	BRA	Goiis	1056330
219	Campinas	BRA	Sco Paulo	950043
220	Sco Gonealo	BRA	Rio de Janeiro	869254
221	Nova Iguaeu	BRA	Rio de Janeiro	862225
222	Sco Luks	BRA	Maranhco	837588
223	Maceió	BRA	Alagoas	786288
224	Duque de Caxias	BRA	Rio de Janeiro	746758
225	Sco Bernardo do Campo	BRA	Sco Paulo	723132
226	Teresina	BRA	Piauk	691942
227	Natal	BRA	Rio Grande do Norte	688955
228	Osasco	BRA	Sco Paulo	659604
229	Campo Grande	BRA	Mato Grosso do Sul	649593
230	Santo André	BRA	Sco Paulo	630073
231	Joco Pessoa	BRA	Parakba	584029
232	Jaboatco dos Guararapes	BRA	Pernambuco	558680
233	Contagem	BRA	Minas Gerais	520801
234	Sco José dos Campos	BRA	Sco Paulo	515553
235	Uberlandia	BRA	Minas Gerais	487222
236	Feira de Santana	BRA	Bahia	479992
237	Ribeirco Preto	BRA	Sco Paulo	473276
238	Sorocaba	BRA	Sco Paulo	466823
239	Niterói	BRA	Rio de Janeiro	459884
240	Cuiabi	BRA	Mato Grosso	453813
241	Juiz de Fora	BRA	Minas Gerais	450288
242	Aracaju	BRA	Sergipe	445555
243	Sco Joco de Meriti	BRA	Rio de Janeiro	440052
244	Londrina	BRA	Parani	432257
245	Joinville	BRA	Santa Catarina	428011
246	Belford Roxo	BRA	Rio de Janeiro	425194
247	Santos	BRA	Sco Paulo	408748
248	Ananindeua	BRA	Pari	400940
249	Campos dos Goytacazes	BRA	Rio de Janeiro	398418
250	Maui	BRA	Sco Paulo	375055
251	Carapicukba	BRA	Sco Paulo	357552
252	Olinda	BRA	Pernambuco	354732
253	Campina Grande	BRA	Parakba	352497
254	Sco José do Rio Preto	BRA	Sco Paulo	351944
255	Caxias do Sul	BRA	Rio Grande do Sul	349581
204	Gaborone	BWA	Gaborone	213017
1810	Montréal	CAN	Québec	1016376
1811	Calgary	CAN	Alberta	768082
1812	Toronto	CAN	Ontario	688275
1813	North York	CAN	Ontario	622632
1814	Winnipeg	CAN	Manitoba	618477
1815	Edmonton	CAN	Alberta	616306
1816	Mississauga	CAN	Ontario	608072
1817	Scarborough	CAN	Ontario	594501
1818	Vancouver	CAN	British Colombia	514008
1819	Etobicoke	CAN	Ontario	348845
1820	London	CAN	Ontario	339917
1821	Hamilton	CAN	Ontario	335614
1822	Ottawa	CAN	Ontario	335277
1823	Laval	CAN	Québec	330393
1824	Surrey	CAN	British Colombia	304477
1825	Brampton	CAN	Ontario	296711
2316	Bantam	CCK	Home Island	503
3245	Zürich	CHE	Zürich	336800
554	Santiago de Chile	CHL	Santiago	4703954
555	Puente Alto	CHL	Santiago	386236
1890	Shanghai	CHN	Shanghai	9696300
1891	Peking	CHN	Peking	7472000
1892	Chongqing	CHN	Chongqing	6351600
1893	Tianjin	CHN	Tianjin	5286800
1894	Wuhan	CHN	Hubei	4344600
1895	Harbin	CHN	Heilongjiang	4289800
1896	Shenyang	CHN	Liaoning	4265200
1897	Kanton [Guangzhou]	CHN	Guangdong	4256300
1898	Chengdu	CHN	Sichuan	3361500
1899	Nanking [Nanjing]	CHN	Jiangsu	2870300
1900	Changchun	CHN	Jilin	2812000
1901	Xi´an	CHN	Shaanxi	2761400
1902	Dalian	CHN	Liaoning	2697000
1903	Qingdao	CHN	Shandong	2596000
1904	Jinan	CHN	Shandong	2278100
1905	Hangzhou	CHN	Zhejiang	2190500
1906	Zhengzhou	CHN	Henan	2107200
1907	Shijiazhuang	CHN	Hebei	2041500
1908	Taiyuan	CHN	Shanxi	1968400
1909	Kunming	CHN	Yunnan	1829500
1910	Changsha	CHN	Hunan	1809800
1911	Nanchang	CHN	Jiangxi	1691600
1912	Fuzhou	CHN	Fujian	1593800
1913	Lanzhou	CHN	Gansu	1565800
1914	Guiyang	CHN	Guizhou	1465200
1915	Ningbo	CHN	Zhejiang	1371200
1916	Hefei	CHN	Anhui	1369100
1917	Urumtši [Ürümqi]	CHN	Xinxiang	1310100
1918	Anshan	CHN	Liaoning	1200000
1919	Fushun	CHN	Liaoning	1200000
1920	Nanning	CHN	Guangxi	1161800
1921	Zibo	CHN	Shandong	1140000
1922	Qiqihar	CHN	Heilongjiang	1070000
1923	Jilin	CHN	Jilin	1040000
1924	Tangshan	CHN	Hebei	1040000
1925	Baotou	CHN	Inner Mongolia	980000
1926	Shenzhen	CHN	Guangdong	950500
1927	Hohhot	CHN	Inner Mongolia	916700
1928	Handan	CHN	Hebei	840000
1929	Wuxi	CHN	Jiangsu	830000
1930	Xuzhou	CHN	Jiangsu	810000
1931	Datong	CHN	Shanxi	800000
1932	Yichun	CHN	Heilongjiang	800000
1933	Benxi	CHN	Liaoning	770000
1934	Luoyang	CHN	Henan	760000
1935	Suzhou	CHN	Jiangsu	710000
1936	Xining	CHN	Qinghai	700200
1937	Huainan	CHN	Anhui	700000
1938	Jixi	CHN	Heilongjiang	683885
1939	Daqing	CHN	Heilongjiang	660000
1940	Fuxin	CHN	Liaoning	640000
1941	Amoy [Xiamen]	CHN	Fujian	627500
1942	Liuzhou	CHN	Guangxi	610000
1943	Shantou	CHN	Guangdong	580000
1944	Jinzhou	CHN	Liaoning	570000
1945	Mudanjiang	CHN	Heilongjiang	570000
1946	Yinchuan	CHN	Ningxia	544500
1947	Changzhou	CHN	Jiangsu	530000
1948	Zhangjiakou	CHN	Hebei	530000
1949	Dandong	CHN	Liaoning	520000
1950	Hegang	CHN	Heilongjiang	520000
1951	Kaifeng	CHN	Henan	510000
1952	Jiamusi	CHN	Heilongjiang	493409
1953	Liaoyang	CHN	Liaoning	492559
1954	Hengyang	CHN	Hunan	487148
2812	Abidjan	CIV	Abidjan	2500000
1803	Douala	CMR	Littoral	1448300
1804	Yaoundé	CMR	Centre	1372800
2298	Kinshasa	COD	Kinshasa	5064000
2299	Lubumbashi	COD	Shaba	851381
2300	Mbuji-Mayi	COD	East Kasai	806475
2296	Brazzaville	COG	Brazzaville	950000
2257	Santafé de Bogoti	COL	Santafé de Bogoti	6260862
2258	Cali	COL	Valle	2077386
2259	Medellkn	COL	Antioquia	1861265
2260	Barranquilla	COL	Atlintico	1223260
2261	Cartagena	COL	Bolkvar	805757
2262	Cscuta	COL	Norte de Santander	606932
2413	La Habana	CUB	La Habana	2256000
2414	Santiago de Cuba	CUB	Santiago de Cuba	433180
2430	Nicosia	CYP	Nicosia	195000
3339	Praha	CZE	Hlavnk mesto Praha	1181126
3340	Brno	CZE	Jiznk Morava	381862
3341	Ostrava	CZE	Severnk Morava	320041
3068	Berlin	DEU	Berliini	3386667
3069	Hamburg	DEU	Hamburg	1704735
3070	Munich [München]	DEU	Baijeri	1194560
3071	Köln	DEU	Nordrhein-Westfalen	962507
3072	Frankfurt am Main	DEU	Hessen	643821
3073	Essen	DEU	Nordrhein-Westfalen	599515
3074	Dortmund	DEU	Nordrhein-Westfalen	590213
3075	Stuttgart	DEU	Baden-Württemberg	582443
3076	Düsseldorf	DEU	Nordrhein-Westfalen	568855
3077	Bremen	DEU	Bremen	540330
3078	Duisburg	DEU	Nordrhein-Westfalen	519793
3079	Hannover	DEU	Niedersachsen	514718
3080	Leipzig	DEU	Saksi	489532
3081	Nürnberg	DEU	Baijeri	486628
3082	Dresden	DEU	Saksi	476668
3083	Bochum	DEU	Nordrhein-Westfalen	392830
3084	Wuppertal	DEU	Nordrhein-Westfalen	368993
3085	Bielefeld	DEU	Nordrhein-Westfalen	321125
3086	Mannheim	DEU	Baden-Württemberg	307730
3087	Bonn	DEU	Nordrhein-Westfalen	301048
3315	Kubenhavn	DNK	Kubenhavn	495699
3316	Århus	DNK	Århus	284846
587	Santo Domingo de Guzmin	DOM	Distrito Nacional	1609966
35	Alger	DZA	Alger	2168000
36	Oran	DZA	Oran	609823
37	Constantine	DZA	Constantine	443727
593	Guayaquil	ECU	Guayas	2070040
594	Quito	ECU	Pichincha	1573458
608	Cairo	EGY	Kairo	6789479
609	Alexandria	EGY	Aleksandria	3328196
610	Giza	EGY	Giza	2221868
611	Shubra al-Khayma	EGY	al-Qalyubiya	870716
653	Madrid	ESP	Madrid	2879052
654	Barcelona	ESP	Katalonia	1503451
655	Valencia	ESP	Valencia	739412
656	Sevilla	ESP	Andalusia	701927
657	Zaragoza	ESP	Aragonia	603367
658	Milaga	ESP	Andalusia	530553
659	Bilbao	ESP	Baskimaa	357589
660	Las Palmas de Gran Canaria	ESP	Canary Islands	354757
661	Murcia	ESP	Murcia	353504
662	Palma de Mallorca	ESP	Balears	326993
663	Valladolid	ESP	Castilla and León	319998
664	Córdoba	ESP	Andalusia	311708
665	Vigo	ESP	Galicia	283670
3791	Tallinn	EST	Harjumaa	403981
756	Addis Abeba	ETH	Addis Abeba	2495000
3236	Helsinki [Helsingfors]	FIN	Newmaa	555474
2974	Paris	FRA	Ile-de-France	2125246
2975	Marseille	FRA	Provence-Alpes-Cote	798430
2976	Lyon	FRA	Rhone-Alpes	445452
2977	Toulouse	FRA	Midi-Pyrénées	390350
2978	Nice	FRA	Provence-Alpes-Cote	342738
2979	Nantes	FRA	Pays de la Loire	270251
2980	Strasbourg	FRA	Alsace	264115
2688	Weno	FSM	Chuuk	22000
456	London	GBR	England	7285000
457	Birmingham	GBR	England	1013000
458	Glasgow	GBR	Scotland	619680
459	Liverpool	GBR	England	461000
460	Edinburgh	GBR	Scotland	450180
461	Sheffield	GBR	England	431607
462	Manchester	GBR	England	430000
463	Leeds	GBR	England	424194
464	Bristol	GBR	England	402000
465	Cardiff	GBR	Wales	321000
466	Coventry	GBR	England	304000
467	Leicester	GBR	England	294000
468	Bradford	GBR	England	289376
469	Belfast	GBR	North Ireland	287500
470	Nottingham	GBR	England	287000
905	Tbilisi	GEO	Tbilisi	1235200
910	Accra	GHA	Greater Accra	1070000
911	Kumasi	GHA	Ashanti	385192
918	Les Abymes	GLP	Grande-Terre	62947
903	Serekunda	GMB	Kombo St Mary	102600
2401	Athenai	GRC	Attika	772072
2402	Thessaloniki	GRC	Central Macedonia	383967
922	Ciudad de Guatemala	GTM	Guatemala	823301
920	Tamuning	GUM	NULL	9500
936	Kowloon and New Kowloon	HKG	Kowloon and New Kowl	1987996
933	Tegucigalpa	HND	Distrito Central	813900
2409	Zagreb	HRV	Grad Zagreb	706770
929	Port-au-Prince	HTI	Ouest	884472
3483	Budapest	HUN	Budapest	1811552
939	Jakarta	IDN	Jakarta Raya	9604900
940	Surabaya	IDN	East Java	2663820
941	Bandung	IDN	West Java	2429000
942	Medan	IDN	Sumatera Utara	1843919
943	Palembang	IDN	Sumatera Selatan	1222764
944	Tangerang	IDN	West Java	1198300
945	Semarang	IDN	Central Java	1104405
946	Ujung Pandang	IDN	Sulawesi Selatan	1060257
947	Malang	IDN	East Java	716862
948	Bandar Lampung	IDN	Lampung	680332
949	Bekasi	IDN	West Java	644300
950	Padang	IDN	Sumatera Barat	534474
951	Surakarta	IDN	Central Java	518600
952	Banjarmasin	IDN	Kalimantan Selatan	482931
1024	Mumbai (Bombay)	IND	Maharashtra	10500000
1025	Delhi	IND	Delhi	7206704
1026	Calcutta [Kolkata]	IND	West Bengali	4399819
1027	Chennai (Madras)	IND	Tamil Nadu	3841396
1028	Hyderabad	IND	Andhra Pradesh	2964638
1029	Ahmedabad	IND	Gujarat	2876710
1030	Bangalore	IND	Karnataka	2660088
1031	Kanpur	IND	Uttar Pradesh	1874409
1032	Nagpur	IND	Maharashtra	1624752
1033	Lucknow	IND	Uttar Pradesh	1619115
1034	Pune	IND	Maharashtra	1566651
1035	Surat	IND	Gujarat	1498817
1036	Jaipur	IND	Rajasthan	1458483
1037	Indore	IND	Madhya Pradesh	1091674
1038	Bhopal	IND	Madhya Pradesh	1062771
1039	Ludhiana	IND	Punjab	1042740
1040	Vadodara (Baroda)	IND	Gujarat	1031346
1041	Kalyan	IND	Maharashtra	1014557
1042	Madurai	IND	Tamil Nadu	977856
1043	Haora (Howrah)	IND	West Bengali	950435
1044	Varanasi (Benares)	IND	Uttar Pradesh	929270
1045	Patna	IND	Bihar	917243
1046	Srinagar	IND	Jammu and Kashmir	892506
1047	Agra	IND	Uttar Pradesh	891790
1048	Coimbatore	IND	Tamil Nadu	816321
1049	Thane (Thana)	IND	Maharashtra	803389
1050	Allahabad	IND	Uttar Pradesh	792858
1051	Meerut	IND	Uttar Pradesh	753778
1052	Vishakhapatnam	IND	Andhra Pradesh	752037
1053	Jabalpur	IND	Madhya Pradesh	741927
1054	Amritsar	IND	Punjab	708835
1055	Faridabad	IND	Haryana	703592
1056	Vijayawada	IND	Andhra Pradesh	701827
1057	Gwalior	IND	Madhya Pradesh	690765
1058	Jodhpur	IND	Rajasthan	666279
1059	Nashik (Nasik)	IND	Maharashtra	656925
1060	Hubli-Dharwad	IND	Karnataka	648298
1061	Solapur (Sholapur)	IND	Maharashtra	604215
1062	Ranchi	IND	Jharkhand	599306
1063	Bareilly	IND	Uttar Pradesh	587211
1064	Guwahati (Gauhati)	IND	Assam	584342
1065	Shambajinagar (Aurangabad)	IND	Maharashtra	573272
1066	Cochin (Kochi)	IND	Kerala	564589
1067	Rajkot	IND	Gujarat	559407
1068	Kota	IND	Rajasthan	537371
1069	Thiruvananthapuram (Trivandrum	IND	Kerala	524006
1070	Pimpri-Chinchwad	IND	Maharashtra	517083
1071	Jalandhar (Jullundur)	IND	Punjab	509510
1072	Gorakhpur	IND	Uttar Pradesh	505566
1073	Chandigarh	IND	Chandigarh	504094
1074	Mysore	IND	Karnataka	480692
1075	Aligarh	IND	Uttar Pradesh	480520
1076	Guntur	IND	Andhra Pradesh	471051
1077	Jamshedpur	IND	Jharkhand	460577
1078	Ghaziabad	IND	Uttar Pradesh	454156
1079	Warangal	IND	Andhra Pradesh	447657
1080	Raipur	IND	Chhatisgarh	438639
1081	Moradabad	IND	Uttar Pradesh	429214
1082	Durgapur	IND	West Bengali	425836
1083	Amravati	IND	Maharashtra	421576
1084	Calicut (Kozhikode)	IND	Kerala	419831
1085	Bikaner	IND	Rajasthan	416289
1086	Bhubaneswar	IND	Orissa	411542
1087	Kolhapur	IND	Maharashtra	406370
1088	Kataka (Cuttack)	IND	Orissa	403418
1089	Ajmer	IND	Rajasthan	402700
1090	Bhavnagar	IND	Gujarat	402338
1091	Tiruchirapalli	IND	Tamil Nadu	387223
1092	Bhilai	IND	Chhatisgarh	386159
1093	Bhiwandi	IND	Maharashtra	379070
1094	Saharanpur	IND	Uttar Pradesh	374945
1095	Ulhasnagar	IND	Maharashtra	369077
1096	Salem	IND	Tamil Nadu	366712
1097	Ujjain	IND	Madhya Pradesh	362266
1447	Dublin	IRL	Leinster	481854
1380	Teheran	IRN	Teheran	6758845
1381	Mashhad	IRN	Khorasan	1887405
1382	Esfahan	IRN	Esfahan	1266072
1383	Tabriz	IRN	East Azerbaidzan	1191043
1384	Shiraz	IRN	Fars	1053025
1385	Karaj	IRN	Teheran	940968
1386	Ahvaz	IRN	Khuzestan	804980
1387	Qom	IRN	Qom	777677
1388	Kermanshah	IRN	Kermanshah	692986
1389	Urmia	IRN	West Azerbaidzan	435200
1390	Zahedan	IRN	Sistan va Baluchesta	419518
1391	Rasht	IRN	Gilan	417748
1392	Hamadan	IRN	Hamadan	401281
1365	Baghdad	IRQ	Baghdad	4336000
1366	Mosul	IRQ	Ninawa	879000
1450	Jerusalem	ISR	Jerusalem	633700
1451	Tel Aviv-Jaffa	ISR	Tel Aviv	348100
1452	Haifa	ISR	Haifa	265700
1464	Roma	ITA	Latium	2643581
1465	Milano	ITA	Lombardia	1300977
1466	Napoli	ITA	Campania	1002619
1467	Torino	ITA	Piemonte	903705
1468	Palermo	ITA	Sisilia	683794
1469	Genova	ITA	Liguria	636104
1470	Bologna	ITA	Emilia-Romagna	381161
1471	Firenze	ITA	Toscana	376662
1472	Catania	ITA	Sisilia	337862
1473	Bari	ITA	Apulia	331848
1474	Venezia	ITA	Veneto	277305
1529	Spanish Town	JAM	St. Catherine	110379
1786	Amman	JOR	Amman	1000000
1787	al-Zarqa	JOR	al-Zarqa	389815
1532	Tokyo	JPN	Tokyo-to	7980230
1533	Jokohama [Yokohama]	JPN	Kanagawa	3339594
1534	Osaka	JPN	Osaka	2595674
1535	Nagoya	JPN	Aichi	2154376
1536	Sapporo	JPN	Hokkaido	1790886
1537	Kioto	JPN	Kyoto	1461974
1538	Kobe	JPN	Hyogo	1425139
1539	Fukuoka	JPN	Fukuoka	1308379
1540	Kawasaki	JPN	Kanagawa	1217359
1541	Hiroshima	JPN	Hiroshima	1119117
1542	Kitakyushu	JPN	Fukuoka	1016264
1543	Sendai	JPN	Miyagi	989975
1544	Chiba	JPN	Chiba	863930
1545	Sakai	JPN	Osaka	797735
1546	Kumamoto	JPN	Kumamoto	656734
1547	Okayama	JPN	Okayama	624269
1548	Sagamihara	JPN	Kanagawa	586300
1549	Hamamatsu	JPN	Shizuoka	568796
1550	Kagoshima	JPN	Kagoshima	549977
1551	Funabashi	JPN	Chiba	545299
1552	Higashiosaka	JPN	Osaka	517785
1553	Hachioji	JPN	Tokyo-to	513451
1554	Niigata	JPN	Niigata	497464
1555	Amagasaki	JPN	Hyogo	481434
1556	Himeji	JPN	Hyogo	475167
1557	Shizuoka	JPN	Shizuoka	473854
1558	Urawa	JPN	Saitama	469675
1559	Matsuyama	JPN	Ehime	466133
1560	Matsudo	JPN	Chiba	461126
1561	Kanazawa	JPN	Ishikawa	455386
1562	Kawaguchi	JPN	Saitama	452155
1563	Ichikawa	JPN	Chiba	441893
1564	Omiya	JPN	Saitama	441649
1565	Utsunomiya	JPN	Tochigi	440353
1566	Oita	JPN	Oita	433401
1567	Nagasaki	JPN	Nagasaki	432759
1568	Yokosuka	JPN	Kanagawa	430200
1569	Kurashiki	JPN	Okayama	425103
1570	Gifu	JPN	Gifu	408007
1571	Hirakata	JPN	Osaka	403151
1572	Nishinomiya	JPN	Hyogo	397618
1573	Toyonaka	JPN	Osaka	396689
1574	Wakayama	JPN	Wakayama	391233
1575	Fukuyama	JPN	Hiroshima	376921
1576	Fujisawa	JPN	Kanagawa	372840
1577	Asahikawa	JPN	Hokkaido	364813
1578	Machida	JPN	Tokyo-to	364197
1579	Nara	JPN	Nara	362812
1580	Takatsuki	JPN	Osaka	361747
1581	Iwaki	JPN	Fukushima	361737
1582	Nagano	JPN	Nagano	361391
1583	Toyohashi	JPN	Aichi	360066
1584	Toyota	JPN	Aichi	346090
1585	Suita	JPN	Osaka	345750
1586	Takamatsu	JPN	Kagawa	332471
1587	Koriyama	JPN	Fukushima	330335
1588	Okazaki	JPN	Aichi	328711
1589	Kawagoe	JPN	Saitama	327211
1590	Tokorozawa	JPN	Saitama	325809
1591	Toyama	JPN	Toyama	325790
1592	Kochi	JPN	Kochi	324710
1593	Kashiwa	JPN	Chiba	320296
1594	Akita	JPN	Akita	314440
1860	Almaty	KAZ	Almaty Qalasy	1129400
1861	Qaraghandy	KAZ	Qaraghandy	436900
1862	Shymkent	KAZ	South Kazakstan	360100
1863	Taraz	KAZ	Taraz	330100
1864	Astana	KAZ	Astana	311200
1865	Öskemen	KAZ	East Kazakstan	311000
1866	Pavlodar	KAZ	Pavlodar	300500
1867	Semey	KAZ	East Kazakstan	269600
1881	Nairobi	KEN	Nairobi	2290000
1882	Mombasa	KEN	Coast	461753
2253	Bishkek	KGZ	Bishkek shaary	589400
1800	Phnom Penh	KHM	Phnom Penh	570155
2255	Bikenibeu	KIR	South Tarawa	5055
2331	Seoul	KOR	Seoul	9981619
2332	Pusan	KOR	Pusan	3804522
2333	Inchon	KOR	Inchon	2559424
2334	Taegu	KOR	Taegu	2548568
2335	Taejon	KOR	Taejon	1425835
2336	Kwangju	KOR	Kwangju	1368341
2337	Ulsan	KOR	Kyongsangnam	1084891
2338	Songnam	KOR	Kyonggi	869094
2339	Puchon	KOR	Kyonggi	779412
2340	Suwon	KOR	Kyonggi	755550
2341	Anyang	KOR	Kyonggi	591106
2342	Chonju	KOR	Chollabuk	563153
2427	al-Salimiya	KWT	Hawalli	130215
2428	Jalib al-Shuyukh	KWT	Hawalli	102178
2432	Vientiane	LAO	Viangchan	531800
2438	Beirut	LBN	Beirut	1100000
2441	Tripoli	LBY	Tripoli	1682000
2442	Bengasi	LBY	Bengasi	804000
2445	Schaan	LIE	Schaan	5346
3217	Colombo	LKA	Western	645000
2447	Vilnius	LTU	Vilna	577969
2448	Kaunas	LTU	Kaunas	412639
2434	Riga	LVA	Riika	764328
2485	Casablanca	MAR	Casablanca	2940623
2486	Rabat	MAR	Rabat-Salé-Zammour-Z	623457
2487	Marrakech	MAR	Marrakech-Tensift-Al	621914
2488	Fcs	MAR	Fcs-Boulemane	541162
2489	Tanger	MAR	Tanger-Tétouan	521735
2490	Salé	MAR	Rabat-Salé-Zammour-Z	504420
2491	Mekncs	MAR	Mekncs-Tafilalet	460000
2694	Monte-Carlo	MCO	NULL	13154
2690	Chisinau	MDA	Chisinau	719900
2455	Antananarivo	MDG	Antananarivo	675669
2515	Ciudad de México	MEX	Distrito Federal	8591309
2516	Guadalajara	MEX	Jalisco	1647720
2517	Ecatepec de Morelos	MEX	México	1620303
2518	Puebla	MEX	Puebla	1346176
2519	Nezahualcóyotl	MEX	México	1224924
2520	Juirez	MEX	Chihuahua	1217818
2521	Tijuana	MEX	Baja California	1212232
2522	León	MEX	Guanajuato	1133576
2523	Monterrey	MEX	Nuevo León	1108499
2524	Zapopan	MEX	Jalisco	1002239
2525	Naucalpan de Juirez	MEX	México	857511
2526	Mexicali	MEX	Baja California	764902
2527	Culiacin	MEX	Sinaloa	744859
2528	Acapulco de Juirez	MEX	Guerrero	721011
2529	Tlalnepantla de Baz	MEX	México	720755
2530	Mérida	MEX	Yucatin	703324
2531	Chihuahua	MEX	Chihuahua	670208
2532	San Luis Potosk	MEX	San Luis Potosk	669353
2533	Guadalupe	MEX	Nuevo León	668780
2534	Toluca	MEX	México	665617
2535	Aguascalientes	MEX	Aguascalientes	643360
2536	Querétaro	MEX	Querétaro de Arteaga	639839
2537	Morelia	MEX	Michoacin de Ocampo	619958
2538	Hermosillo	MEX	Sonora	608697
2539	Saltillo	MEX	Coahuila de Zaragoza	577352
2540	Torreón	MEX	Coahuila de Zaragoza	529093
2541	Centro (Villahermosa)	MEX	Tabasco	519873
2542	San Nicolis de los Garza	MEX	Nuevo León	495540
2543	Durango	MEX	Durango	490524
2544	Chimalhuacin	MEX	México	490245
2545	Tlaquepaque	MEX	Jalisco	475472
2546	Atizapin de Zaragoza	MEX	México	467262
2547	Veracruz	MEX	Veracruz	457119
2548	Cuautitlin Izcalli	MEX	México	452976
2549	Irapuato	MEX	Guanajuato	440039
2550	Tuxtla Gutiérrez	MEX	Chiapas	433544
2551	Tultitlin	MEX	México	432411
2552	Reynosa	MEX	Tamaulipas	419776
2553	Benito Juirez	MEX	Quintana Roo	419276
2554	Matamoros	MEX	Tamaulipas	416428
2555	Xalapa	MEX	Veracruz	390058
2556	Celaya	MEX	Guanajuato	382140
2557	Mazatlin	MEX	Sinaloa	380265
2558	Ensenada	MEX	Baja California	369573
2559	Ahome	MEX	Sinaloa	358663
2560	Cajeme	MEX	Sonora	355679
2483	Birkirkara	MLT	Outer Harbour	21445
2710	Rangoon (Yangon)	MMR	Rangoon [Yangon]	3361700
2711	Mandalay	MMR	Mandalay	885300
2698	Maputo	MOZ	Maputo	1018938
2699	Matola	MOZ	Maputo	424662
2700	Beira	MOZ	Sofala	397368
2701	Nampula	MOZ	Nampula	303346
2509	Nouakchott	MRT	Nouakchott	667300
2511	Port-Louis	MUS	Port-Louis	138200
2461	Blantyre	MWI	Blantyre	478155
2464	Kuala Lumpur	MYS	Wilayah Persekutuan	1297526
2465	Ipoh	MYS	Perak	382853
2466	Johor Baharu	MYS	Johor	328436
2738	Niamey	NER	Niamey	420000
2741	Lagos	NGA	Lagos	1518000
2742	Ibadan	NGA	Oyo & Osun	1432000
2743	Ogbomosho	NGA	Oyo & Osun	730000
2744	Kano	NGA	Kano & Jigawa	674100
2745	Oshogbo	NGA	Oyo & Osun	476800
2746	Ilorin	NGA	Kwara & Kogi	475800
2747	Abeokuta	NGA	Ogun	427400
2748	Port Harcourt	NGA	Rivers & Bayelsa	410000
2749	Zaria	NGA	Kaduna	379200
2750	Ilesha	NGA	Oyo & Osun	378400
2751	Onitsha	NGA	Anambra & Enugu & Eb	371900
2752	Iwo	NGA	Oyo & Osun	362000
2753	Ado-Ekiti	NGA	Ondo & Ekiti	359400
2754	Abuja	NGA	Federal Capital Dist	350100
2755	Kaduna	NGA	Kaduna	342200
2756	Mushin	NGA	Lagos	333200
2757	Maiduguri	NGA	Borno & Yobe	320000
2758	Enugu	NGA	Anambra & Enugu & Eb	316100
2759	Ede	NGA	Oyo & Osun	307100
2760	Aba	NGA	Imo & Abia	298900
2761	Ife	NGA	Oyo & Osun	296800
2734	Managua	NIC	Managua	959000
5	Amsterdam	NLD	Noord-Holland	731200
6	Rotterdam	NLD	Zuid-Holland	593321
7	Haag	NLD	Zuid-Holland	440900
8	Utrecht	NLD	Utrecht	234323
9	Eindhoven	NLD	Noord-Brabant	201843
10	Tilburg	NLD	Noord-Brabant	193238
2807	Oslo	NOR	Oslo	508726
2808	Bergen	NOR	Hordaland	230948
2729	Kathmandu	NPL	Central	591835
2727	Yangor	NRU	NULL	4050
3494	Auckland	NZL	Auckland	381800
3495	Christchurch	NZL	Canterbury	324200
3496	Manukau	NZL	Auckland	281800
2817	al-Sib	OMN	Masqat	155000
2818	Salala	OMN	Zufar	131813
2819	Bawshar	OMN	Masqat	107500
2822	Karachi	PAK	Sindh	9269265
2823	Lahore	PAK	Punjab	5063499
2824	Faisalabad	PAK	Punjab	1977246
2825	Rawalpindi	PAK	Punjab	1406214
2826	Multan	PAK	Punjab	1182441
2827	Hyderabad	PAK	Sindh	1151274
2828	Gujranwala	PAK	Punjab	1124749
2829	Peshawar	PAK	Nothwest Border Prov	988005
2830	Quetta	PAK	Baluchistan	560307
2882	Ciudad de Panami	PAN	Panami	471373
2890	Lima	PER	Lima	6464693
2891	Arequipa	PER	Arequipa	762000
2892	Trujillo	PER	La Libertad	652000
765	Quezon	PHL	National Capital Reg	2173831
766	Manila	PHL	National Capital Reg	1581082
767	Kalookan	PHL	National Capital Reg	1177604
768	Davao	PHL	Southern Mindanao	1147116
769	Cebu	PHL	Central Visayas	718821
770	Zamboanga	PHL	Western Mindanao	601794
771	Pasig	PHL	National Capital Reg	505058
772	Valenzuela	PHL	National Capital Reg	485433
773	Las Pinas	PHL	National Capital Reg	472780
774	Antipolo	PHL	Southern Tagalog	470866
775	Taguig	PHL	National Capital Reg	467375
776	Cagayan de Oro	PHL	Northern Mindanao	461877
777	Paranaque	PHL	National Capital Reg	449811
778	Makati	PHL	National Capital Reg	444867
779	Bacolod	PHL	Western Visayas	429076
780	General Santos	PHL	Southern Mindanao	411822
781	Marikina	PHL	National Capital Reg	391170
782	Dasmarinas	PHL	Southern Tagalog	379520
783	Muntinlupa	PHL	National Capital Reg	379310
784	Iloilo	PHL	Western Visayas	365820
785	Pasay	PHL	National Capital Reg	354908
786	Malabon	PHL	National Capital Reg	338855
787	San José del Monte	PHL	Central Luzon	315807
788	Bacoor	PHL	Southern Tagalog	305699
789	Iligan	PHL	Central Mindanao	285061
790	Calamba	PHL	Southern Tagalog	281146
791	Mandaluyong	PHL	National Capital Reg	278474
792	Butuan	PHL	Caraga	267279
793	Angeles	PHL	Central Luzon	263971
794	Tarlac	PHL	Central Luzon	262481
795	Mandaue	PHL	Central Visayas	259728
796	Baguio	PHL	CAR	252386
797	Batangas	PHL	Southern Tagalog	247588
798	Cainta	PHL	Southern Tagalog	242511
799	San Pedro	PHL	Southern Tagalog	231403
800	Navotas	PHL	National Capital Reg	230403
2928	Warszawa	POL	Mazowieckie	1615369
2929	Lódz	POL	Lodzkie	800110
2930	Kraków	POL	Malopolskie	738150
2931	Wroclaw	POL	Dolnoslaskie	636765
2932	Poznan	POL	Wielkopolskie	576899
2933	Gdansk	POL	Pomorskie	458988
2934	Szczecin	POL	Zachodnio-Pomorskie	416988
2935	Bydgoszcz	POL	Kujawsko-Pomorskie	386855
2936	Lublin	POL	Lubelskie	356251
2937	Katowice	POL	Slaskie	345934
2938	Bialystok	POL	Podlaskie	283937
2919	San Juan	PRI	San Juan	434374
2920	Bayamón	PRI	Bayamón	224044
2921	Ponce	PRI	Ponce	186475
2922	Carolina	PRI	Carolina	186076
2318	Pyongyang	PRK	Pyongyang-si	2484000
2319	Hamhung	PRK	Hamgyong N	709730
2320	Chongjin	PRK	Hamgyong P	582480
2321	Nampo	PRK	Nampo-si	566200
2914	Lisboa	PRT	Lisboa	563210
2915	Porto	PRT	Porto	273060
2885	Asunción	PRY	Asunción	557776
4074	Gaza	PSE	Gaza	353632
3015	Faaa	PYF	Tahiti	25888
3018	Bucuresti	ROM	Bukarest	2016131
3019	Iasi	ROM	Iasi	348070
3020	Constanta	ROM	Constanta	342264
3021	Cluj-Napoca	ROM	Cluj	332498
3022	Galati	ROM	Galati	330276
3023	Timisoara	ROM	Timis	324304
3024	Brasov	ROM	Brasov	314225
3025	Craiova	ROM	Dolj	313530
3580	Moscow	RUS	Moscow (City)	8389200
3581	St Petersburg	RUS	Pietari	4694000
3582	Novosibirsk	RUS	Novosibirsk	1398800
3583	Nizni Novgorod	RUS	Nizni Novgorod	1357000
3584	Jekaterinburg	RUS	Sverdlovsk	1266300
3585	Samara	RUS	Samara	1156100
3586	Omsk	RUS	Omsk	1148900
3587	Kazan	RUS	Tatarstan	1101000
3588	Ufa	RUS	Baškortostan	1091200
3589	Tšeljabinsk	RUS	Tšeljabinsk	1083200
3590	Rostov-na-Donu	RUS	Rostov-na-Donu	1012700
3591	Perm	RUS	Perm	1009700
3592	Volgograd	RUS	Volgograd	993400
3593	Voronez	RUS	Voronez	907700
3594	Krasnojarsk	RUS	Krasnojarsk	875500
3595	Saratov	RUS	Saratov	874000
3596	Toljatti	RUS	Samara	722900
3597	Uljanovsk	RUS	Uljanovsk	667400
3598	Izevsk	RUS	Udmurtia	652800
3599	Krasnodar	RUS	Krasnodar	639000
3600	Jaroslavl	RUS	Jaroslavl	616700
3601	Habarovsk	RUS	Habarovsk	609400
3602	Vladivostok	RUS	Primorje	606200
3603	Irkutsk	RUS	Irkutsk	593700
3604	Barnaul	RUS	Altai	580100
3605	Novokuznetsk	RUS	Kemerovo	561600
3606	Penza	RUS	Penza	532200
3607	Rjazan	RUS	Rjazan	529900
3608	Orenburg	RUS	Orenburg	523600
3609	Lipetsk	RUS	Lipetsk	521000
3610	Nabereznyje Tšelny	RUS	Tatarstan	514700
3611	Tula	RUS	Tula	506100
3612	Tjumen	RUS	Tjumen	503400
3613	Kemerovo	RUS	Kemerovo	492700
3614	Astrahan	RUS	Astrahan	486100
3615	Tomsk	RUS	Tomsk	482100
3616	Kirov	RUS	Kirov	466200
3617	Ivanovo	RUS	Ivanovo	459200
3618	Tšeboksary	RUS	Tšuvassia	459200
3619	Brjansk	RUS	Brjansk	457400
3620	Tver	RUS	Tver	454900
3621	Kursk	RUS	Kursk	443500
3622	Magnitogorsk	RUS	Tšeljabinsk	427900
3623	Kaliningrad	RUS	Kaliningrad	424400
3624	Nizni Tagil	RUS	Sverdlovsk	390900
3625	Murmansk	RUS	Murmansk	376300
3626	Ulan-Ude	RUS	Burjatia	370400
3173	Riyadh	SAU	Riyadh	3324000
3174	Jedda	SAU	Mekka	2046300
3175	Mekka	SAU	Mekka	965700
3176	Medina	SAU	Medina	608300
3177	al-Dammam	SAU	al-Sharqiya	482300
3224	Omdurman	SDN	Khartum	1271403
3225	Khartum	SDN	Khartum	947483
3226	Sharq al-Nil	SDN	Khartum	700887
3197	Pikine	SEN	Cap-Vert	855287
3198	Dakar	SEN	Cap-Vert	785071
645	San Salvador	SLV	San Salvador	415346
3170	Serravalle	SMR	Serravalle/Dogano	4802
3214	Mogadishu	SOM	Banaadir	997000
3209	Bratislava	SVK	Bratislava	448292
3212	Ljubljana	SVN	Osrednjeslovenska	270986
3048	Stockholm	SWE	Lisboa	750348
3049	Gothenburg [Göteborg]	SWE	West Götanmaan län	466990
3050	Malmö	SWE	Skåne län	259579
3250	Damascus	SYR	Damascus	1347000
3251	Aleppo	SYR	Aleppo	1261983
3252	Hims	SYR	Hims	507404
3337	N´Djaména	TCD	Chari-Baguirmi	530965
3320	Bangkok	THA	Bangkok	6320174
3261	Dushanbe	TJK	Karotegin	524000
3419	Ashgabat	TKM	Ahal	540600
3335	Chaguanas	TTO	Caroni	56601
3349	Tunis	TUN	Tunis	690600
3350	Sfax	TUN	Sfax	257800
3357	Istanbul	TUR	Istanbul	8787958
3358	Ankara	TUR	Ankara	3038159
3359	Izmir	TUR	Izmir	2130359
3360	Adana	TUR	Adana	1131198
3361	Bursa	TUR	Bursa	1095842
3362	Gaziantep	TUR	Gaziantep	789056
3363	Konya	TUR	Konya	628364
3364	Mersin (Ieel)	TUR	Ieel	587212
3365	Antalya	TUR	Antalya	564914
3366	Diyarbakir	TUR	Diyarbakir	479884
3367	Kayseri	TUR	Kayseri	475657
3368	Eskisehir	TUR	Eskisehir	470781
3263	Taipei	TWN	Taipei	2641312
3264	Kaohsiung	TWN	Kaohsiung	1475505
3265	Taichung	TWN	Taichung	940589
3266	Tainan	TWN	Tainan	728060
3267	Panchiao	TWN	Taipei	523850
3268	Chungho	TWN	Taipei	392176
3269	Keelung (Chilung)	TWN	Keelung	385201
3270	Sanchung	TWN	Taipei	380084
3271	Hsinchuang	TWN	Taipei	365048
3272	Hsinchu	TWN	Hsinchu	361958
3305	Dar es Salaam	TZA	Dar es Salaam	1747000
3426	Kyiv	UKR	Kiova	2624000
3427	Harkova [Harkiv]	UKR	Harkova	1500000
3428	Dnipropetrovsk	UKR	Dnipropetrovsk	1103000
3429	Donetsk	UKR	Donetsk	1050000
3430	Odesa	UKR	Odesa	1011000
3431	Zaporizzja	UKR	Zaporizzja	848000
3432	Lviv	UKR	Lviv	788000
3433	Kryvyi Rig	UKR	Dnipropetrovsk	703000
3434	Mykolajiv	UKR	Mykolajiv	508000
3435	Mariupol	UKR	Donetsk	490000
3436	Lugansk	UKR	Lugansk	469000
3437	Vinnytsja	UKR	Vinnytsja	391000
3438	Makijivka	UKR	Donetsk	384000
3439	Herson	UKR	Herson	353000
3793	New York	USA	New York	8008278
3794	Los Angeles	USA	California	3694820
3795	Chicago	USA	Illinois	2896016
3796	Houston	USA	Texas	1953631
3797	Philadelphia	USA	Pennsylvania	1517550
3798	Phoenix	USA	Arizona	1321045
3799	San Diego	USA	California	1223400
3800	Dallas	USA	Texas	1188580
3801	San Antonio	USA	Texas	1144646
3802	Detroit	USA	Michigan	951270
3803	San Jose	USA	California	894943
3804	Indianapolis	USA	Indiana	791926
3805	San Francisco	USA	California	776733
3806	Jacksonville	USA	Florida	735167
3807	Columbus	USA	Ohio	711470
3808	Austin	USA	Texas	656562
3809	Baltimore	USA	Maryland	651154
3810	Memphis	USA	Tennessee	650100
3811	Milwaukee	USA	Wisconsin	596974
3812	Boston	USA	Massachusetts	589141
3813	Washington	USA	District of Columbia	572059
3814	Nashville-Davidson	USA	Tennessee	569891
3815	El Paso	USA	Texas	563662
3816	Seattle	USA	Washington	563374
3817	Denver	USA	Colorado	554636
3818	Charlotte	USA	North Carolina	540828
3819	Fort Worth	USA	Texas	534694
3820	Portland	USA	Oregon	529121
3821	Oklahoma City	USA	Oklahoma	506132
3822	Tucson	USA	Arizona	486699
3823	New Orleans	USA	Louisiana	484674
3824	Las Vegas	USA	Nevada	478434
3825	Cleveland	USA	Ohio	478403
3826	Long Beach	USA	California	461522
3827	Albuquerque	USA	New Mexico	448607
3828	Kansas City	USA	Missouri	441545
3829	Fresno	USA	California	427652
3830	Virginia Beach	USA	Virginia	425257
3831	Atlanta	USA	Georgia	416474
3832	Sacramento	USA	California	407018
3833	Oakland	USA	California	399484
3834	Mesa	USA	Arizona	396375
3835	Tulsa	USA	Oklahoma	393049
3836	Omaha	USA	Nebraska	390007
3837	Minneapolis	USA	Minnesota	382618
3838	Honolulu	USA	Hawaii	371657
3839	Miami	USA	Florida	362470
3840	Colorado Springs	USA	Colorado	360890
3841	Saint Louis	USA	Missouri	348189
3842	Wichita	USA	Kansas	344284
3843	Santa Ana	USA	California	337977
3844	Pittsburgh	USA	Pennsylvania	334563
3845	Arlington	USA	Texas	332969
3846	Cincinnati	USA	Ohio	331285
3847	Anaheim	USA	California	328014
3848	Toledo	USA	Ohio	313619
3849	Tampa	USA	Florida	303447
3850	Buffalo	USA	New York	292648
3851	Saint Paul	USA	Minnesota	287151
3503	Toskent	UZB	Toskent Shahri	2117500
3504	Namangan	UZB	Namangan	370500
3505	Samarkand	UZB	Samarkand	361800
3506	Andijon	UZB	Andijon	318600
3539	Caracas	VEN	Distrito Federal	1975294
3540	Maracakbo	VEN	Zulia	1304776
3541	Barquisimeto	VEN	Lara	877239
3542	Valencia	VEN	Carabobo	794246
3543	Ciudad Guayana	VEN	Bolkvar	663713
3544	Petare	VEN	Miranda	488868
3545	Maracay	VEN	Aragua	444443
3546	Barcelona	VEN	Anzoitegui	322267
3547	Maturkn	VEN	Monagas	319726
3548	San Cristóbal	VEN	Tichira	319373
3549	Ciudad Bolkvar	VEN	Bolkvar	301107
3769	Ho Chi Minh City	VNM	Ho Chi Minh City	3980000
3770	Hanoi	VNM	Hanoi	1410000
3771	Haiphong	VNM	Haiphong	783133
1780	Sanaa	YEM	Sanaa	503600
1781	Aden	YEM	Aden	398300
1782	Taizz	YEM	Taizz	317600
1783	Hodeida	YEM	Hodeida	298500
1792	Beograd	YUG	Central Serbia	1204000
712	Cape Town	ZAF	Western Cape	2352121
713	Soweto	ZAF	Gauteng	904165
714	Johannesburg	ZAF	Gauteng	756653
715	Port Elizabeth	ZAF	Eastern Cape	752319
716	Pretoria	ZAF	Gauteng	658630
717	Inanda	ZAF	KwaZulu-Natal	634065
718	Durban	ZAF	KwaZulu-Natal	566120
719	Vanderbijlpark	ZAF	Gauteng	468931
720	Kempton Park	ZAF	Gauteng	442633
721	Alberton	ZAF	Gauteng	410102
722	Pinetown	ZAF	KwaZulu-Natal	378810
723	Pietermaritzburg	ZAF	KwaZulu-Natal	370190
724	Benoni	ZAF	Gauteng	365467
3162	Lusaka	ZMB	Lusaka	1317000
4068	Harare	ZWE	Harare	1410000
4069	Bulawayo	ZWE	Bulawayo	621742