• Andmetabelite tCity ja tCountry põhjal statistika (Nt, riikide, linnade, kontinentide, ... arvud, keskmised, max, min väärtused, ...) --UNION
  • Riigid, mille keeled on määramata
  • Riigid, mille nimetus on langeb kokku pealinna nimetusega
In [14]:
--Relatsiooniline summa ehk UNION
SELECT 'Linnade arv' AS Kirjeldus, COUNT(*) AS Kokku
FROM tCity
UNION
SELECT 'Riikide arv',COUNT(*)
FROM tCountry
UNION
SELECT 'Kontinendid', COUNT(DISTINCT Continent)
FROM tCountry
UNION
SELECT 'Keskmine riikide Population',AVG(CAST(Population AS bigint)) 
FROM tCountry
UNION
SELECT 'Väiksem riikide Population',MIN(CAST(Population AS bigint)) 
FROM tCountry
(5 rows affected)
Total execution time: 00:00:00.007
Out[14]:
KirjeldusKokku
Keskmine riikide Population25434098
Kontinendid7
Linnade arv4079
Riikide arv239
Väiksem riikide Population0
In [16]:
--Riigid, mille keeled on määramata

SELECT Code 
FROM tCountry
EXCEPT --Realtsiooniline miinus ehk vahe
SELECT CountryCode
FROM tLanguage
(6 rows affected)
Total execution time: 00:00:00.049
Out[16]:
Code
ATF
IOT
BVT
HMD
SGS
ATA
In [21]:
--Riigid, mille nimetus on langeb kokku pealinna nimetusega
SELECT CountryName --riikide nimetused
FROM tCountry
INTERSECT --ühisosa
SELECT CityName --pealinnade nimetused
FROM tCity INNER JOIN tCountry
    ON ID=Capital
(6 rows affected)
Total execution time: 00:00:00.038
Out[21]:
CountryName
Djibouti
Gibraltar
Kuwait
Macao
San Marino
Singapore
In [24]:
--Riigid, mille keeled on määramata
SELECT *
FROM tCountry
WHERE Code IN
    (SELECT Code  --alampäring
    FROM tCountry
    EXCEPT --Realtsiooniline miinus ehk vahe
    SELECT CountryCode
    FROM tLanguage)
(6 rows affected)
Total execution time: 00:00:00.043
Out[24]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
ATAAntarcticaAntarcticaAntarctica13120000,00NULL0NULL0,00NULLCo-administratedNULLNULL
ATFFrench Southern territoriesAntarcticaAntarctica7780,00NULL0NULL0,00NULLTerres australes fran?aisesNonmetropolitan Territory of FranceJacques ChiracNULL
BVTBouvet IslandAntarcticaAntarctica59,00NULL0NULL0,00NULLBouvet¸yaDependent Territory of NorwayHarald VNULL
HMDHeard Island and McDonald IslandsAntarcticaAntarctica359,00NULL0NULL0,00NULLHeard and McDonald IslandsTerritory of AustraliaElisabeth IINULL
IOTBritish Indian Ocean TerritoryAfricaEastern Africa78,00NULL0NULL0,00NULLBritish Indian Ocean TerritoryDependent Territory of the UKElisabeth IINULL
SGSSouth Georgia and the South Sandwich IslandsAntarcticaAntarctica3903,00NULL0NULL0,00NULLSouth Georgia and the South Sandwich IslandsDependent Territory of the UKElisabeth IINULL
In [27]:
SELECT *
FROM tCountry
WHERE Population >
(SELECT AVG(CAST(Population as bigint)) FROM tCountry)
(38 rows affected)
Total execution time: 00:00:00.045
Out[27]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
ARGArgentinaSouth AmericaSouth America2780400,0018163703200075,1340238,00323310,00ArgentinaFederal RepublicFernando de la R?a69
BGDBangladeshAsiaSouthern and Central Asia143998,00197112915500060,232852,0031966,00BangladeshRepublicShahabuddin Ahmad150
BRABrazilSouth AmericaSouth America8547403,00182217011500062,9776739,00804108,00BrasilFederal RepublicFernando Henrique Cardoso211
CANCanadaNorth AmericaNorth America9970610,0018673114700079,4598862,00625626,00CanadaConstitutional Monarchy, FederationElisabeth II1822
CHNChinaAsiaEastern Asia9572900,00-1523127755800071,4982268,00917719,00ZhongquoRepublicJiang Zemin1891
CODCongo, The Democratic Republic of theAfricaCentral Africa2344858,0019605165400048,86964,002474,00République Démocratique du CongoRepublicJoseph Kabila2298
COLColombiaSouth AmericaSouth America1138914,0018104232100070,3102896,00105116,00ColombiaRepublicAndrés Pastrana Arango2257
DEUGermanyEuropeWestern Europe357022,0019558216470077,42133367,002102826,00DeutschlandFederal RepublicJohannes Rau3068
DZAAlgeriaAfricaNorthern Africa2381741,0019623147100069,749982,0046966,00Al-Jaza’’ir/AlgérieRepublicAbdelaziz Bouteflika35
EGYEgyptAfricaNorthern Africa1001449,0019226847000063,382710,0075617,00MisrRepublicHosni Mubarak608
ESPSpainEuropeSouthern Europe505992,0014923944170078,8553233,00532031,00Espa?aConstitutional MonarchyJuan Carlos I653
ETHEthiopiaAfricaEastern Africa1104300,00-10006256500045,26353,006180,00YeItyop´iyaRepublicNegasso Gidada756
FRAFranceEuropeWestern Europe551500,008435922570078,81424285,001392448,00FranceRepublicJacques Chirac2974
GBRUnited KingdomEuropeBritish Islands242900,0010665962340077,71378330,001296830,00United KingdomConstitutional MonarchyElisabeth II456
IDNIndonesiaAsiaSoutheast Asia1904569,00194521210700068,084982,00215002,00IndonesiaRepublicAbdurrahman Wahid939
INDIndiaAsiaSouthern and Central Asia3287263,001947101366200062,5447114,00430572,00Bharat/IndiaFederal RepublicKocheril Raman Narayanan1109
IRNIranAsiaSouthern and Central Asia1648195,0019066770200069,7195746,00160151,00IranIslamic RepublicAli Mohammad Khatami-Ardakani1380
ITAItalyEuropeSouthern Europe301316,0018615768000079,01161755,001145372,00ItaliaRepublicCarlo Azeglio Ciampi1464
JPNJapanAsiaEastern Asia377829,00-66012671400080,73787042,004192638,00Nihon/NipponConstitutional MonarchyAkihito1532
KENKenyaAfricaEastern Africa580367,0019633008000048,09217,0010241,00KenyaRepublicDaniel arap Moi1881
KORSouth KoreaAsiaEastern Asia99434,0019484684400074,4320749,00442544,00Taehan Min’guk (Namhan)RepublicKim Dae-jung2331
MARMoroccoAfricaNorthern Africa446550,0019562835100069,136124,0033514,00Al-MaghribConstitutional MonarchyMohammed VI2486
MEXMexicoNorth AmericaCentral America1958201,0018109888100071,5414972,00401461,00MéxicoFederal RepublicVicente Fox Quesada2515
MMRMyanmarAsiaSoutheast Asia676578,0019484561100054,9180375,00171028,00Myanma PyeRepublickenraali Than Shwe2710
NGANigeriaAfricaWestern Africa923768,00196011150600051,665707,0058623,00NigeriaFederal RepublicOlusegun Obasanjo2754
PAKPakistanAsiaSouthern and Central Asia796095,00194715648300061,161289,0058549,00PakistanRepublicMohammad Rafiq Tarar2831
PERPeruSouth AmericaSouth America1285216,0018212566200070,064140,0065186,00Perú/PiruwRepublicValentin Paniagua Corazao2890
PHLPhilippinesAsiaSoutheast Asia300000,0019467596700067,565107,0082239,00PilipinasRepublicGloria Macapagal-Arroyo766
POLPolandEuropeEastern Europe323250,0019183865360073,2151697,00135636,00PolskaRepublicAleksander Kwasniewski2928
RUSRussian FederationEuropeEastern Europe17075400,00199114693400067,2276608,00442989,00RossijaFederal RepublicVladimir Putin3580
SDNSudanAfricaNorthern Africa2505813,0019562949000056,610162,00NULLAs-SudanIslamic RepublicOmar Hassan Ahmad al-Bashir3225
THAThailandAsiaSoutheast Asia513115,0013506139900068,6116416,00153907,00Prathet ThaiConstitutional MonarchyBhumibol Adulyadej3320
TURTurkeyAsiaMiddle East774815,0019236659100071,0210721,00189122,00TürkiyeRepublicAhmet Necdet Sezer3358
TZATanzaniaAfricaEastern Africa883749,0019613351700052,38005,007388,00TanzaniaRepublicBenjamin William Mkapa3306
UKRUkraineEuropeEastern Europe603700,0019915045600066,042168,0049677,00UkrajinaRepublicLeonid Kut?ma3426
USAUnited StatesNorth AmericaNorth America9363520,00177627835700077,18510700,008110900,00United StatesFederal RepublicGeorge W. Bush3813
VNMVietnamAsiaSoutheast Asia331689,0019457983200069,321929,0022834,00Vi?t NamSocialistic RepublicTr?n Duc Luong3770
ZAFSouth AfricaAfricaSouthern Africa1221037,0019104037700051,1116729,00129092,00South AfricaRepublicThabo Mbeki716
In [37]:
--10.	Riigid kus elanikud räägivad keeltes, mis on Belgia (BEL) ametlikud keeled
SELECT * --Riikide info
FROM tCountry
WHERE Code IN 
    (SELECT DISTINCT CountryCode --Riikide koodid kus on samad ametl.keeled
    FROM tLanguage
    WHERE IsOfficial =1 AND [Language] IN
        (SELECT [Language] -- Belgia (BEL) ametlikud keeled
        FROM tLanguage
        WHERE CountryCode LIKE 'BEL' AND IsOfficial=1))
(24 rows affected)
Total execution time: 00:00:00.052
Out[37]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
ABWArubaNorth AmericaCaribbean193,00NULL10300078,4828,00793,00ArubaNonmetropolitan Territory of The NetherlandsBeatrix129
ANTNetherlands AntillesNorth AmericaCaribbean800,00NULL21700074,71941,00NULLNederlandse AntillenNonmetropolitan Territory of The NetherlandsBeatrix33
AUTAustriaEuropeWestern Europe83859,001918809180077,7211860,00206025,00ÖsterreichFederal RepublicThomas Klestil1523
BDIBurundiAfricaEastern Africa27834,001962669500046,2903,00982,00Burundi/UburundiRepublicPierre Buyoya552
BELBelgiumEuropeWestern Europe30518,0018301023900077,8249704,00243948,00België/BelgiqueConstitutional Monarchy, FederationAlbert II179
CANCanadaNorth AmericaNorth America9970610,0018673114700079,4598862,00625626,00CanadaConstitutional Monarchy, FederationElisabeth II1822
CHESwitzerlandEuropeWestern Europe41284,001499716040079,6264478,00256092,00Schweiz/Suisse/Svizzera/SvizraFederationAdolf Ogi3248
DEUGermanyEuropeWestern Europe357022,0019558216470077,42133367,002102826,00DeutschlandFederal RepublicJohannes Rau3068
FRAFranceEuropeWestern Europe551500,008435922570078,81424285,001392448,00FranceRepublicJacques Chirac2974
GLPGuadeloupeNorth AmericaCaribbean1705,00NULL45600077,03501,00NULLGuadeloupeOverseas Department of FranceJacques Chirac919
HTIHaitiNorth AmericaCaribbean27750,001804822200049,23459,003107,00Ha?ti/DaytiRepublicJean-Bertrand Aristide929
LIELiechtensteinEuropeWestern Europe160,0018063230078,81119,001084,00LiechtensteinConstitutional MonarchyHans-Adam II2446
LUXLuxembourgEuropeWestern Europe2586,00186743570077,116321,0015519,00Luxembourg/L?tzebuergConstitutional MonarchyHenri2452
MCOMonacoEuropeWestern Europe1,5018613400078,8776,00NULLMonacoConstitutional MonarchyRainier III2695
MDGMadagascarAfricaEastern Africa587041,0019601594200055,03750,003545,00Madagasikara/MadagascarFederal RepublicDidier Ratsiraka2455
MTQMartiniqueNorth AmericaCaribbean1102,00NULL39500078,32731,002559,00MartiniqueOverseas Department of FranceJacques Chirac2508
MYTMayotteAfricaEastern Africa373,00NULL14900059,50,00NULLMayotteTerritorial Collectivity of FranceJacques Chirac2514
NCLNew CaledoniaOceaniaMelanesia18575,00NULL21400072,83563,00NULLNouvelle-CalédonieNonmetropolitan Territory of FranceJacques Chirac3493
NLDNetherlandsEuropeWestern Europe41526,0015811586400078,3371362,00360478,00NederlandConstitutional MonarchyBeatrix5
PYFFrench PolynesiaOceaniaPolynesia4000,00NULL23500074,8818,00781,00Polynésie FrançaiseNonmetropolitan Territory of FranceJacques Chirac3016
RWARwandaAfricaEastern Africa26338,001962773300039,32036,001863,00Rwanda/UrwandaRepublicPaul Kagame3047
SPMSaint Pierre and MiquelonNorth AmericaNorth America242,00NULL700077,60,00NULLSaint-Pierre-et-MiquelonTerritorial Collectivity of FranceJacques Chirac3067
SYCSeychellesAfricaEastern Africa455,0019767700070,4536,00539,00Sesel/SeychellesRepublicFrance-Albert René3206
VUTVanuatuOceaniaMelanesia12189,00198019000060,6261,00246,00VanuatuRepublicJohn Bani3537
In [50]:
--1. Riigid, kus elanikud räägivad kõige laiemalt levinud maailmas keeles
-- (riikide arvu järgi, kus keel on ametlik)

SELECT *
FROM tCountry
WHERE Code IN
(SELECT DISTINCT CountryCode --Riikide koodid kus on samad ametl.keeled
    FROM tLanguage
    WHERE IsOfficial=1 AND [Language] IN
(SELECT TOP 1 [Language]--, COUNT(CountryCode) --kõige laiemalt levinud maailmas keel
FROM tLanguage
WHERE IsOfficial=1
GROUP BY [Language]
ORDER BY COUNT(CountryCode)  DESC))
(44 rows affected)
Total execution time: 00:00:00.069
Out[50]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
AIAAnguillaNorth AmericaCaribbean96,00NULL800076,163,20NULLAnguillaDependent Territory of the UKElisabeth II62
ASMAmerican SamoaOceaniaPolynesia199,00NULL6800075,1334,00NULLAmerika SamoaUS TerritoryGeorge W. Bush54
ATGAntigua and BarbudaNorth AmericaCaribbean442,0019816800070,5612,00584,00Antigua and BarbudaConstitutional MonarchyElisabeth II63
AUSAustraliaOceaniaAustralia and New Zealand7741220,0019011888600079,8351182,00392911,00AustraliaConstitutional Monarchy, FederationElisabeth II135
BLZBelizeNorth AmericaCentral America22696,00198124100070,9630,00616,00BelizeConstitutional MonarchyElisabeth II185
BMUBermudaNorth AmericaNorth America53,00NULL6500076,92328,002190,00BermudaDependent Territory of the UKElisabeth II191
BRBBarbadosNorth AmericaCaribbean430,00196627000073,02223,002186,00BarbadosConstitutional MonarchyElisabeth II174
CANCanadaNorth AmericaNorth America9970610,0018673114700079,4598862,00625626,00CanadaConstitutional Monarchy, FederationElisabeth II1822
CCKCocos (Keeling) IslandsOceaniaAustralia and New Zealand14,00NULL600NULL0,00NULLCocos (Keeling) IslandsTerritory of AustraliaElisabeth II2317
CXRChristmas IslandOceaniaAustralia and New Zealand135,00NULL2500NULL0,00NULLChristmas IslandTerritory of AustraliaElisabeth II1791
CYMCayman IslandsNorth AmericaCaribbean264,00NULL3800078,91263,001186,00Cayman IslandsDependent Territory of the UKElisabeth II553
FLKFalkland IslandsSouth AmericaSouth America12173,00NULL2000NULL0,00NULLFalkland IslandsDependent Territory of the UKElisabeth II763
GBRUnited KingdomEuropeBritish Islands242900,0010665962340077,71378330,001296830,00United KingdomConstitutional MonarchyElisabeth II456
GIBGibraltarEuropeSouthern Europe6,00NULL2500079,0258,00NULLGibraltarDependent Territory of the UKElisabeth II915
GUMGuamOceaniaMicronesia549,00NULL16800077,81197,001136,00GuamUS TerritoryGeorge W. Bush921
HKGHong KongAsiaEastern Asia1075,00NULL678200079,5166448,00173610,00Xianggang/Hong KongSpecial Administrative Region of ChinaJiang Zemin937
IRLIrelandEuropeBritish Islands70273,001921377510076,875921,0073132,00Ireland/ÉireRepublicMary McAleese1447
KNASaint Kitts and NevisNorth AmericaCaribbean261,0019833800070,7299,00NULLSaint Kitts and NevisConstitutional MonarchyElisabeth II3064
LCASaint LuciaNorth AmericaCaribbean622,00197915400072,3571,00NULLSaint LuciaConstitutional MonarchyElisabeth II3065
LSOLesothoAfricaSouthern Africa30355,001966215300050,81061,001161,00LesothoConstitutional MonarchyLetsie III2437
MHLMarshall IslandsOceaniaMicronesia181,0019906400065,597,00NULLMarshall Islands/MajolRepublicKessai Note2507
MLTMaltaEuropeSouthern Europe316,00196438020077,93512,003338,00MaltaRepublicGuido de Marco2484
MNPNorthern Mariana IslandsOceaniaMicronesia464,00NULL7800075,50,00NULLNorthern Mariana IslandsCommonwealth of the USGeorge W. Bush2913
MSRMontserratNorth AmericaCaribbean102,00NULL1100078,0109,00NULLMontserratDependent Territory of the UKElisabeth II2697
NFKNorfolk IslandOceaniaAustralia and New Zealand36,00NULL2000NULL0,00NULLNorfolk IslandTerritory of AustraliaElisabeth II2806
NIUNiueOceaniaPolynesia260,00NULL2000NULL0,00NULLNiueNonmetropolitan Territory of New ZealandElisabeth II2805
NRUNauruOceaniaMicronesia21,0019681200060,8197,00NULLNaoero/NauruRepublicBernard Dowiyogo2728
NZLNew ZealandOceaniaAustralia and New Zealand270534,001907386200077,854669,0064960,00New Zealand/AotearoaConstitutional MonarchyElisabeth II3499
PLWPalauOceaniaMicronesia459,0019941900068,6105,00NULLBelau/PalauRepublicKuniwo Nakamura2881
SHNSaint HelenaAfricaWestern Africa314,00NULL600076,80,00NULLSaint HelenaDependent Territory of the UKElisabeth II3063
SYCSeychellesAfricaEastern Africa455,0019767700070,4536,00539,00Sesel/SeychellesRepublicFrance-Albert René3206
TCATurks and Caicos IslandsNorth AmericaCaribbean430,00NULL1700073,396,00NULLThe Turks and Caicos IslandsDependent Territory of the UKElisabeth II3423
TKLTokelauOceaniaPolynesia12,00NULL2000NULL0,00NULLTokelauNonmetropolitan Territory of New ZealandElisabeth II3333
TONTongaOceaniaPolynesia650,0019709900067,9146,00170,00TongaMonarchyTaufa ahau Tupou IV3334
TUVTuvaluOceaniaPolynesia26,0019781200066,36,00NULLTuvaluConstitutional MonarchyElisabeth II3424
UMIUnited States Minor Outlying IslandsOceaniaMicronesia/Caribbean16,00NULL0NULL0,00NULLUnited States Minor Outlying IslandsDependent Territory of the USGeorge W. BushNULL
USAUnited StatesNorth AmericaNorth America9363520,00177627835700077,18510700,008110900,00United StatesFederal RepublicGeorge W. Bush3813
VCTSaint Vincent and the GrenadinesNorth AmericaCaribbean388,00197911400072,3285,00NULLSaint Vincent and the GrenadinesConstitutional MonarchyElisabeth II3066
VGBVirgin Islands, BritishNorth AmericaCaribbean151,00NULL2100075,4612,00573,00British Virgin IslandsDependent Territory of the UKElisabeth II537
VIRVirgin Islands, U.S.North AmericaCaribbean347,00NULL9300078,10,00NULLVirgin Islands of the United StatesUS TerritoryGeorge W. Bush4067
VUTVanuatuOceaniaMelanesia12189,00198019000060,6261,00246,00VanuatuRepublicJohn Bani3537
WSMSamoaOceaniaPolynesia2831,00196218000069,2141,00157,00SamoaParlementary MonarchyMalietoa Tanumafili II3169
ZAFSouth AfricaAfricaSouthern Africa1221037,0019104037700051,1116729,00129092,00South AfricaRepublicThabo Mbeki716
ZWEZimbabweAfricaEastern Africa390757,0019801166900037,85951,008670,00ZimbabweRepublicRobert G. Mugabe4068
In [51]:
--Teine variant
SELECT CountryCode
FROM tLanguage
WHERE isOfficial=1 AND [Language] IN(
    SELECT Language FROM (
        SELECT TOP 1 Language AS Lang, COUNT(*) AS Total
        FROM tLanguage
        WHERE IsOfficial=1
        GROUP BY [Language]
        ORDER BY COUNT(*) DESC) a 
        )
(238 rows affected)
Total execution time: 00:00:00.015
Out[51]:
CountryCode
ABW
AFG
AFG
AIA
ALB
AND
ANT
ANT
ARE
ARG
ARM
ASM
ASM
ATG
AUS
AUT
AZE
BDI
BDI
BEL
BEL
BEL
BGD
BGR
BHR
BIH
BLR
BLR
BLZ
BMU
BOL
BOL
BOL
BRA
BRB
BRN
BTN
CAN
CAN
CCK
CHE
CHE
CHE
CHE
CHL
CHN
COK
COL
COM
CPV
CRI
CUB
CXR
CYM
CYP
CYP
CZE
DEU
DJI
DNK
DOM
DZA
ECU
EGY
ERI
ESH
ESP
EST
FIN
FIN
FJI
FLK
FRA
FRO
FRO
GBR
GEO
GIB
GLP
GNB
GRC
GRL
GRL
GTM
GUM
GUM
HKG
HND
HRV
HTI
HUN
IDN
IND
IRL
IRL
IRN
IRQ
ISL
ISR
ISR
ITA
JOR
JPN
KAZ
KGZ
KGZ
KHM
KIR
KNA
KOR
KWT
LAO
LBN
LBY
LCA
LIE
LKA
LKA
LSO
LSO
LTU
LUX
LUX
LUX
LVA
MAC
MAR
MCO
MDA
MDG
MDG
MDV
MEX
MHL
MHL
MKD
MLT
MLT
MMR
MNG
MNP
MSR
MTQ
MWI
MYS
MYT
NCL
NFK
NIC
NIU
NLD
NOR
NPL
NRU
NRU
NZL
OMN
PAK
PAN
PER
PER
PER
PHL
PLW
PLW
POL
PRI
PRK
PRT
PRY
PRY
PYF
QAT
ROM
ROM
RUS
RWA
RWA
SAU
SDN
SEN
SGP
SGP
SGP
SHN
SJM
SLV
SMR
SOM
SOM
SPM
SVK
SVN
SWE
SWZ
SYC
SYC
SYR
TCA
TCD
TGO
TGO
THA
TJK
TKL
TKM
TMP
TON
TON
TUN
TUR
TUV
TUV
TWN
TZA
UKR
UMI
URY
USA
UZB
VAT
VCT
VEN
VGB
VIR
VNM
VUT
VUT
VUT
WSM
WSM
YEM
YUG
ZAF
ZAF
ZAF
ZAF
ZWE
In [54]:
--2 Riigid, mis asuvad kõige väiksema pindalaga kontinendil

SELECT *
FROM tCountry
WHERE Continent =
(SELECT TOP 1 Continent--, SUM(SurfaceArea) as Total
FROM tCountry
GROUP BY Continent
ORDER BY  SUM(SurfaceArea) ASC)
(28 rows affected)
Total execution time: 00:00:00.029
Out[54]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
ASMAmerican SamoaOceaniaPolynesia199,00NULL6800075,1334,00NULLAmerika SamoaUS TerritoryGeorge W. Bush54
AUSAustraliaOceaniaAustralia and New Zealand7741220,0019011888600079,8351182,00392911,00AustraliaConstitutional Monarchy, FederationElisabeth II135
CCKCocos (Keeling) IslandsOceaniaAustralia and New Zealand14,00NULL600NULL0,00NULLCocos (Keeling) IslandsTerritory of AustraliaElisabeth II2317
COKCook IslandsOceaniaPolynesia236,00NULL2000071,1100,00NULLThe Cook IslandsNonmetropolitan Territory of New ZealandElisabeth II583
CXRChristmas IslandOceaniaAustralia and New Zealand135,00NULL2500NULL0,00NULLChristmas IslandTerritory of AustraliaElisabeth II1791
FJIFiji IslandsOceaniaMelanesia18274,00197081700067,91536,002149,00Fiji IslandsRepublicJosefa Iloilo764
FSMMicronesia, Federated States ofOceaniaMicronesia702,00199011900068,6212,00NULLMicronesiaFederal RepublicLeo A. Falcam2689
GUMGuamOceaniaMicronesia549,00NULL16800077,81197,001136,00GuamUS TerritoryGeorge W. Bush921
KIRKiribatiOceaniaMicronesia726,0019798300059,840,70NULLKiribatiRepublicTeburoro Tito2256
MHLMarshall IslandsOceaniaMicronesia181,0019906400065,597,00NULLMarshall Islands/MajolRepublicKessai Note2507
MNPNorthern Mariana IslandsOceaniaMicronesia464,00NULL7800075,50,00NULLNorthern Mariana IslandsCommonwealth of the USGeorge W. Bush2913
NCLNew CaledoniaOceaniaMelanesia18575,00NULL21400072,83563,00NULLNouvelle-CalédonieNonmetropolitan Territory of FranceJacques Chirac3493
NFKNorfolk IslandOceaniaAustralia and New Zealand36,00NULL2000NULL0,00NULLNorfolk IslandTerritory of AustraliaElisabeth II2806
NIUNiueOceaniaPolynesia260,00NULL2000NULL0,00NULLNiueNonmetropolitan Territory of New ZealandElisabeth II2805
NRUNauruOceaniaMicronesia21,0019681200060,8197,00NULLNaoero/NauruRepublicBernard Dowiyogo2728
NZLNew ZealandOceaniaAustralia and New Zealand270534,001907386200077,854669,0064960,00New Zealand/AotearoaConstitutional MonarchyElisabeth II3499
PCNPitcairnOceaniaPolynesia49,00NULL50NULL0,00NULLPitcairnDependent Territory of the UKElisabeth II2912
PLWPalauOceaniaMicronesia459,0019941900068,6105,00NULLBelau/PalauRepublicKuniwo Nakamura2881
PNGPapua New GuineaOceaniaMelanesia462840,001975480700063,14988,006328,00Papua New Guinea/Papua NiuginiConstitutional MonarchyElisabeth II2884
PYFFrench PolynesiaOceaniaPolynesia4000,00NULL23500074,8818,00781,00Polynésie FrançaiseNonmetropolitan Territory of FranceJacques Chirac3016
SLBSolomon IslandsOceaniaMelanesia28896,00197844400071,3182,00220,00Solomon IslandsConstitutional MonarchyElisabeth II3161
TKLTokelauOceaniaPolynesia12,00NULL2000NULL0,00NULLTokelauNonmetropolitan Territory of New ZealandElisabeth II3333
TONTongaOceaniaPolynesia650,0019709900067,9146,00170,00TongaMonarchyTaufa ahau Tupou IV3334
TUVTuvaluOceaniaPolynesia26,0019781200066,36,00NULLTuvaluConstitutional MonarchyElisabeth II3424
UMIUnited States Minor Outlying IslandsOceaniaMicronesia/Caribbean16,00NULL0NULL0,00NULLUnited States Minor Outlying IslandsDependent Territory of the USGeorge W. BushNULL
VUTVanuatuOceaniaMelanesia12189,00198019000060,6261,00246,00VanuatuRepublicJohn Bani3537
WLFWallis and FutunaOceaniaPolynesia200,00NULL15000NULL0,00NULLWallis-et-FutunaNonmetropolitan Territory of FranceJacques Chirac3536
WSMSamoaOceaniaPolynesia2831,00196218000069,2141,00157,00SamoaParlementary MonarchyMalietoa Tanumafili II3169
In [55]:
SELECT *
FROM tCity AS A
WHERE A.Population >= 
    (SELECT AVG(Population)
        FROM tCity
        WHERE CountryCode = A.CountryCode
        GROUP By CountryCode
    )
(1000 rows affected)
Total execution time: 00:00:00.058
Out[55]:
IDCityNameCountryCodeDistrictPopulation
129OranjestadABWNULL29034
1KabulAFGKabol 1760000
56LuandaAGOLuanda 2022000
61South HillAIANULL961
34TiranaALBTirana 270000
55Andorra la VellaANDAndorra la Vella 21189
33WillemstadANTCuraeao 2345
64DubaiAREDubai 669181
65Abu DhabiAREAbu Dhabi 398695
69Buenos AiresARGDistrito Federal 2982146
70La MatanzaARGBuenos Aires 1266461
71CórdobaARGCórdoba 1157507
72RosarioARGSanta Fé 907718
73Lomas de ZamoraARGBuenos Aires 622013
74QuilmesARGBuenos Aires 559249
75Almirante BrownARGBuenos Aires 538918
76La PlataARGBuenos Aires 521936
77Mar del PlataARGBuenos Aires 512880
78San Miguel de TucuminARGTucumin 470809
79LanssARGBuenos Aires 469735
80MerloARGBuenos Aires 463846
81General San MartknARGBuenos Aires 422542
82SaltaARGSalta 367550
83MorenoARGBuenos Aires 356993
84Santa FéARGSanta Fé 353063
85AvellanedaARGBuenos Aires 353046
86Tres de FebreroARGBuenos Aires 352311
126YerevanARMYerevan 1248700
53TafunaASMTutuila 5200
63Saint John´sATGSt John 24000
130SydneyAUSNew South Wales 3276207
131MelbourneAUSVictoria 2865329
132BrisbaneAUSQueensland 1291117
133PerthAUSWest Australia 1096829
134AdelaideAUSSouth Australia 978100
1523WienAUTWien 1608144
144BakuAZEBaki 1787800
552BujumburaBDIBujumbura 300000
175AntwerpenBELAntwerpen 446525
176GentBELEast Flanderi 224180
177CharleroiBELHainaut 200827
178LicgeBELLicge 185639
186CotonouBENAtlantique 536827
549OuagadougouBFAKadiogo 824000
150DhakaBGDDhaka 3612850
151ChittagongBGDChittagong 1392860
152KhulnaBGDKhulna 663340
539SofijaBGRGrad Sofija 1122302
540PlovdivBGRPlovdiv 342584
541VarnaBGRVarna 299801
149al-ManamaBHRal-Manama 148000
148NassauBHSNew Providence 172000
201SarajevoBIHFederaatio 360000
3520MinskBLRHorad Minsk 1674000
3521GomelBLRGomel 475000
3522MogiljovBLRMogiljov 356000
3523VitebskBLRVitebsk 340000
3524GrodnoBLRGrodno 302000
184Belize CityBLZBelize City 55810
190Saint GeorgeBMUSaint George´s 1800
193Santa Cruz de la SierraBOLSanta Cruz 935361
194La PazBOLLa Paz 758141
195El AltoBOLLa Paz 534466
196CochabambaBOLCochabamba 482800
206Sco PauloBRASco Paulo 9968485
207Rio de JaneiroBRARio de Janeiro 5598953
208SalvadorBRABahia 2302832
209Belo HorizonteBRAMinas Gerais 2139125
210FortalezaBRACeari 2097757
211BraskliaBRADistrito Federal 1969868
212CuritibaBRAParani 1584232
213RecifeBRAPernambuco 1378087
214Porto AlegreBRARio Grande do Sul 1314032
215ManausBRAAmazonas 1255049
216BelémBRAPari 1186926
217GuarulhosBRASco Paulo 1095874
218GoianiaBRAGoiis 1056330
219CampinasBRASco Paulo 950043
220Sco GonealoBRARio de Janeiro 869254
221Nova IguaeuBRARio de Janeiro 862225
222Sco LuksBRAMaranhco 837588
223MaceióBRAAlagoas 786288
224Duque de CaxiasBRARio de Janeiro 746758
225Sco Bernardo do CampoBRASco Paulo 723132
226TeresinaBRAPiauk 691942
227NatalBRARio Grande do Norte 688955
228OsascoBRASco Paulo 659604
229Campo GrandeBRAMato Grosso do Sul 649593
230Santo AndréBRASco Paulo 630073
231Joco PessoaBRAParakba 584029
232Jaboatco dos GuararapesBRAPernambuco 558680
233ContagemBRAMinas Gerais 520801
234Sco José dos CamposBRASco Paulo 515553
235UberlandiaBRAMinas Gerais 487222
236Feira de SantanaBRABahia 479992
237Ribeirco PretoBRASco Paulo 473276
238SorocabaBRASco Paulo 466823
239NiteróiBRARio de Janeiro 459884
240CuiabiBRAMato Grosso 453813
241Juiz de ForaBRAMinas Gerais 450288
242AracajuBRASergipe 445555
243Sco Joco de MeritiBRARio de Janeiro 440052
244LondrinaBRAParani 432257
245JoinvilleBRASanta Catarina 428011
246Belford RoxoBRARio de Janeiro 425194
247SantosBRASco Paulo 408748
248AnanindeuaBRAPari 400940
249Campos dos GoytacazesBRARio de Janeiro 398418
250MauiBRASco Paulo 375055
251CarapicukbaBRASco Paulo 357552
252OlindaBRAPernambuco 354732
253Campina GrandeBRAParakba 352497
254Sco José do Rio PretoBRASco Paulo 351944
255Caxias do SulBRARio Grande do Sul 349581
174BridgetownBRBSt Michael 6070
538Bandar Seri BegawanBRNBrunei and Muara 21484
192ThimphuBTNThimphu 22000
204GaboroneBWAGaborone 213017
1889BanguiCAFBangui 524000
1810MontréalCANQuébec 1016376
1811CalgaryCANAlberta 768082
1812TorontoCANOntario 688275
1813North YorkCANOntario 622632
1814WinnipegCANManitoba 618477
1815EdmontonCANAlberta 616306
1816MississaugaCANOntario 608072
1817ScarboroughCANOntario 594501
1818VancouverCANBritish Colombia 514008
1819EtobicokeCANOntario 348845
1820LondonCANOntario 339917
1821HamiltonCANOntario 335614
1822OttawaCANOntario 335277
1823LavalCANQuébec 330393
1824SurreyCANBritish Colombia 304477
1825BramptonCANOntario 296711
2316BantamCCKHome Island 503
3245ZürichCHEZürich 336800
554Santiago de ChileCHLSantiago 4703954
555Puente AltoCHLSantiago 386236
1890ShanghaiCHNShanghai 9696300
1891PekingCHNPeking 7472000
1892ChongqingCHNChongqing 6351600
1893TianjinCHNTianjin 5286800
1894WuhanCHNHubei 4344600
1895HarbinCHNHeilongjiang 4289800
1896ShenyangCHNLiaoning 4265200
1897Kanton [Guangzhou]CHNGuangdong 4256300
1898ChengduCHNSichuan 3361500
1899Nanking [Nanjing]CHNJiangsu 2870300
1900ChangchunCHNJilin 2812000
1901Xi´anCHNShaanxi 2761400
1902DalianCHNLiaoning 2697000
1903QingdaoCHNShandong 2596000
1904JinanCHNShandong 2278100
1905HangzhouCHNZhejiang 2190500
1906ZhengzhouCHNHenan 2107200
1907ShijiazhuangCHNHebei 2041500
1908TaiyuanCHNShanxi 1968400
1909KunmingCHNYunnan 1829500
1910ChangshaCHNHunan 1809800
1911NanchangCHNJiangxi 1691600
1912FuzhouCHNFujian 1593800
1913LanzhouCHNGansu 1565800
1914GuiyangCHNGuizhou 1465200
1915NingboCHNZhejiang 1371200
1916HefeiCHNAnhui 1369100
1917Urumtši [Ürümqi]CHNXinxiang 1310100
1918AnshanCHNLiaoning 1200000
1919FushunCHNLiaoning 1200000
1920NanningCHNGuangxi 1161800
1921ZiboCHNShandong 1140000
1922QiqiharCHNHeilongjiang 1070000
1923JilinCHNJilin 1040000
1924TangshanCHNHebei 1040000
1925BaotouCHNInner Mongolia 980000
1926ShenzhenCHNGuangdong 950500
1927HohhotCHNInner Mongolia 916700
1928HandanCHNHebei 840000
1929WuxiCHNJiangsu 830000
1930XuzhouCHNJiangsu 810000
1931DatongCHNShanxi 800000
1932YichunCHNHeilongjiang 800000
1933BenxiCHNLiaoning 770000
1934LuoyangCHNHenan 760000
1935SuzhouCHNJiangsu 710000
1936XiningCHNQinghai 700200
1937HuainanCHNAnhui 700000
1938JixiCHNHeilongjiang 683885
1939DaqingCHNHeilongjiang 660000
1940FuxinCHNLiaoning 640000
1941Amoy [Xiamen]CHNFujian 627500
1942LiuzhouCHNGuangxi 610000
1943ShantouCHNGuangdong 580000
1944JinzhouCHNLiaoning 570000
1945MudanjiangCHNHeilongjiang 570000
1946YinchuanCHNNingxia 544500
1947ChangzhouCHNJiangsu 530000
1948ZhangjiakouCHNHebei 530000
1949DandongCHNLiaoning 520000
1950HegangCHNHeilongjiang 520000
1951KaifengCHNHenan 510000
1952JiamusiCHNHeilongjiang 493409
1953LiaoyangCHNLiaoning 492559
1954HengyangCHNHunan 487148
2812AbidjanCIVAbidjan 2500000
1803DoualaCMRLittoral 1448300
1804YaoundéCMRCentre 1372800
2298KinshasaCODKinshasa 5064000
2299LubumbashiCODShaba 851381
2300Mbuji-MayiCODEast Kasai 806475
2296BrazzavilleCOGBrazzaville 950000
583AvaruaCOKRarotonga 11900
2257Santafé de BogotiCOLSantafé de Bogoti 6260862
2258CaliCOLValle 2077386
2259MedellknCOLAntioquia 1861265
2260BarranquillaCOLAtlintico 1223260
2261CartagenaCOLBolkvar 805757
2262CscutaCOLNorte de Santander 606932
2295MoroniCOMNjazidja 36000
1859PraiaCPVSco Tiago 94800
584San JoséCRISan José 339131
2413La HabanaCUBLa Habana 2256000
2414Santiago de CubaCUBSantiago de Cuba 433180
1791Flying Fish CoveCXRNULL700
553George TownCYMGrand Cayman 19600
2430NicosiaCYPNicosia 195000
3339PrahaCZEHlavnk mesto Praha 1181126
3340BrnoCZEJiznk Morava 381862
3341OstravaCZESevernk Morava 320041
3068BerlinDEUBerliini 3386667
3069HamburgDEUHamburg 1704735
3070Munich [München]DEUBaijeri 1194560
3071KölnDEUNordrhein-Westfalen 962507
3072Frankfurt am MainDEUHessen 643821
3073EssenDEUNordrhein-Westfalen 599515
3074DortmundDEUNordrhein-Westfalen 590213
3075StuttgartDEUBaden-Württemberg 582443
3076DüsseldorfDEUNordrhein-Westfalen 568855
3077BremenDEUBremen 540330
3078DuisburgDEUNordrhein-Westfalen 519793
3079HannoverDEUNiedersachsen 514718
3080LeipzigDEUSaksi 489532
3081NürnbergDEUBaijeri 486628
3082DresdenDEUSaksi 476668
3083BochumDEUNordrhein-Westfalen 392830
3084WuppertalDEUNordrhein-Westfalen 368993
3085BielefeldDEUNordrhein-Westfalen 321125
3086MannheimDEUBaden-Württemberg 307730
3087BonnDEUNordrhein-Westfalen 301048
585DjiboutiDJIDjibouti 383000
586RoseauDMASt George 16243
3315KubenhavnDNKKubenhavn 495699
3316ÅrhusDNKÅrhus 284846
587Santo Domingo de GuzminDOMDistrito Nacional 1609966
35AlgerDZAAlger 2168000
36OranDZAOran 609823
37ConstantineDZAConstantine 443727
593GuayaquilECUGuayas 2070040
594QuitoECUPichincha 1573458
608CairoEGYKairo 6789479
609AlexandriaEGYAleksandria 3328196
610GizaEGYGiza 2221868
611Shubra al-KhaymaEGYal-Qalyubiya 870716
652AsmaraERIMaekel 431000
2453El-AaisnESHEl-Aaisn 169000
653MadridESPMadrid 2879052
654BarcelonaESPKatalonia 1503451
655ValenciaESPValencia 739412
656SevillaESPAndalusia 701927
657ZaragozaESPAragonia 603367
658MilagaESPAndalusia 530553
659BilbaoESPBaskimaa 357589
660Las Palmas de Gran CanariaESPCanary Islands 354757
661MurciaESPMurcia 353504
662Palma de MallorcaESPBalears 326993
663ValladolidESPCastilla and León 319998
664CórdobaESPAndalusia 311708
665VigoESPGalicia 283670
3791TallinnESTHarjumaa 403981
756Addis AbebaETHAddis Abeba 2495000
3236Helsinki [Helsingfors]FINNewmaa 555474
764SuvaFJICentral 77366
763StanleyFLKEast Falkland 1636
2974ParisFRAIle-de-France 2125246
2975MarseilleFRAProvence-Alpes-Cote 798430
2976LyonFRARhone-Alpes 445452
2977ToulouseFRAMidi-Pyrénées 390350
2978NiceFRAProvence-Alpes-Cote 342738
2979NantesFRAPays de la Loire 270251
2980StrasbourgFRAAlsace 264115
901TórshavnFROStreymoyar 14542
2688WenoFSMChuuk 22000
902LibrevilleGABEstuaire 419000
456LondonGBREngland 7285000
457BirminghamGBREngland 1013000
458GlasgowGBRScotland 619680
459LiverpoolGBREngland 461000
460EdinburghGBRScotland 450180
461SheffieldGBREngland 431607
462ManchesterGBREngland 430000
463LeedsGBREngland 424194
464BristolGBREngland 402000
465CardiffGBRWales 321000
466CoventryGBREngland 304000
467LeicesterGBREngland 294000
468BradfordGBREngland 289376
469BelfastGBRNorth Ireland 287500
470NottinghamGBREngland 287000
905TbilisiGEOTbilisi 1235200
910AccraGHAGreater Accra 1070000
911KumasiGHAAshanti 385192
915GibraltarGIBNULL27025
926ConakryGINConakry 1090610
918Les AbymesGLPGrande-Terre 62947
903SerekundaGMBKombo St Mary 102600
927BissauGNBBissau 241000
2972MalaboGNQBioko 40000
2401AthenaiGRCAttika 772072
2402ThessalonikiGRCCentral Macedonia 383967
916Saint George´sGRDSt George 4621
917NuukGRLKitaa 13445
922Ciudad de GuatemalaGTMGuatemala 823301
3014CayenneGUFCayenne 50699
920TamuningGUMNULL9500
928GeorgetownGUYGeorgetown 254000
936Kowloon and New KowloonHKGKowloon and New Kowl1987996
933TegucigalpaHNDDistrito Central 813900
2409ZagrebHRVGrad Zagreb 706770
929Port-au-PrinceHTIOuest 884472
3483BudapestHUNBudapest 1811552
939JakartaIDNJakarta Raya 9604900
940SurabayaIDNEast Java 2663820
941BandungIDNWest Java 2429000
942MedanIDNSumatera Utara 1843919
943PalembangIDNSumatera Selatan 1222764
944TangerangIDNWest Java 1198300
945SemarangIDNCentral Java 1104405
946Ujung PandangIDNSulawesi Selatan 1060257
947MalangIDNEast Java 716862
948Bandar LampungIDNLampung 680332
949BekasiIDNWest Java 644300
950PadangIDNSumatera Barat 534474
951SurakartaIDNCentral Java 518600
952BanjarmasinIDNKalimantan Selatan 482931
1024Mumbai (Bombay)INDMaharashtra 10500000
1025DelhiINDDelhi 7206704
1026Calcutta [Kolkata]INDWest Bengali 4399819
1027Chennai (Madras)INDTamil Nadu 3841396
1028HyderabadINDAndhra Pradesh 2964638
1029AhmedabadINDGujarat 2876710
1030BangaloreINDKarnataka 2660088
1031KanpurINDUttar Pradesh 1874409
1032NagpurINDMaharashtra 1624752
1033LucknowINDUttar Pradesh 1619115
1034PuneINDMaharashtra 1566651
1035SuratINDGujarat 1498817
1036JaipurINDRajasthan 1458483
1037IndoreINDMadhya Pradesh 1091674
1038BhopalINDMadhya Pradesh 1062771
1039LudhianaINDPunjab 1042740
1040Vadodara (Baroda)INDGujarat 1031346
1041KalyanINDMaharashtra 1014557
1042MaduraiINDTamil Nadu 977856
1043Haora (Howrah)INDWest Bengali 950435
1044Varanasi (Benares)INDUttar Pradesh 929270
1045PatnaINDBihar 917243
1046SrinagarINDJammu and Kashmir 892506
1047AgraINDUttar Pradesh 891790
1048CoimbatoreINDTamil Nadu 816321
1049Thane (Thana)INDMaharashtra 803389
1050AllahabadINDUttar Pradesh 792858
1051MeerutINDUttar Pradesh 753778
1052VishakhapatnamINDAndhra Pradesh 752037
1053JabalpurINDMadhya Pradesh 741927
1054AmritsarINDPunjab 708835
1055FaridabadINDHaryana 703592
1056VijayawadaINDAndhra Pradesh 701827
1057GwaliorINDMadhya Pradesh 690765
1058JodhpurINDRajasthan 666279
1059Nashik (Nasik)INDMaharashtra 656925
1060Hubli-DharwadINDKarnataka 648298
1061Solapur (Sholapur)INDMaharashtra 604215
1062RanchiINDJharkhand 599306
1063BareillyINDUttar Pradesh 587211
1064Guwahati (Gauhati)INDAssam 584342
1065Shambajinagar (Aurangabad)INDMaharashtra 573272
1066Cochin (Kochi)INDKerala 564589
1067RajkotINDGujarat 559407
1068KotaINDRajasthan 537371
1069Thiruvananthapuram (TrivandrumINDKerala 524006
1070Pimpri-ChinchwadINDMaharashtra 517083
1071Jalandhar (Jullundur)INDPunjab 509510
1072GorakhpurINDUttar Pradesh 505566
1073ChandigarhINDChandigarh 504094
1074MysoreINDKarnataka 480692
1075AligarhINDUttar Pradesh 480520
1076GunturINDAndhra Pradesh 471051
1077JamshedpurINDJharkhand 460577
1078GhaziabadINDUttar Pradesh 454156
1079WarangalINDAndhra Pradesh 447657
1080RaipurINDChhatisgarh 438639
1081MoradabadINDUttar Pradesh 429214
1082DurgapurINDWest Bengali 425836
1083AmravatiINDMaharashtra 421576
1084Calicut (Kozhikode)INDKerala 419831
1085BikanerINDRajasthan 416289
1086BhubaneswarINDOrissa 411542
1087KolhapurINDMaharashtra 406370
1088Kataka (Cuttack)INDOrissa 403418
1089AjmerINDRajasthan 402700
1090BhavnagarINDGujarat 402338
1091TiruchirapalliINDTamil Nadu 387223
1092BhilaiINDChhatisgarh 386159
1093BhiwandiINDMaharashtra 379070
1094SaharanpurINDUttar Pradesh 374945
1095UlhasnagarINDMaharashtra 369077
1096SalemINDTamil Nadu 366712
1097UjjainINDMadhya Pradesh 362266
1447DublinIRLLeinster 481854
1380TeheranIRNTeheran 6758845
1381MashhadIRNKhorasan 1887405
1382EsfahanIRNEsfahan 1266072
1383TabrizIRNEast Azerbaidzan 1191043
1384ShirazIRNFars 1053025
1385KarajIRNTeheran 940968
1386AhvazIRNKhuzestan 804980
1387QomIRNQom 777677
1388KermanshahIRNKermanshah 692986
1389UrmiaIRNWest Azerbaidzan 435200
1390ZahedanIRNSistan va Baluchesta419518
1391RashtIRNGilan 417748
1392HamadanIRNHamadan 401281
1365BaghdadIRQBaghdad 4336000
1366MosulIRQNinawa 879000
1449ReykjavkkISLHöfušborgarsveši 109184
1450JerusalemISRJerusalem 633700
1451Tel Aviv-JaffaISRTel Aviv 348100
1452HaifaISRHaifa 265700
1464RomaITALatium 2643581
1465MilanoITALombardia 1300977
1466NapoliITACampania 1002619
1467TorinoITAPiemonte 903705
1468PalermoITASisilia 683794
1469GenovaITALiguria 636104
1470BolognaITAEmilia-Romagna 381161
1471FirenzeITAToscana 376662
1472CataniaITASisilia 337862
1473BariITAApulia 331848
1474VeneziaITAVeneto 277305
1529Spanish TownJAMSt. Catherine 110379
1786AmmanJORAmman 1000000
1787al-ZarqaJORal-Zarqa 389815
1532TokyoJPNTokyo-to 7980230
1533Jokohama [Yokohama]JPNKanagawa 3339594
1534OsakaJPNOsaka 2595674
1535NagoyaJPNAichi 2154376
1536SapporoJPNHokkaido 1790886
1537KiotoJPNKyoto 1461974
1538KobeJPNHyogo 1425139
1539FukuokaJPNFukuoka 1308379
1540KawasakiJPNKanagawa 1217359
1541HiroshimaJPNHiroshima 1119117
1542KitakyushuJPNFukuoka 1016264
1543SendaiJPNMiyagi 989975
1544ChibaJPNChiba 863930
1545SakaiJPNOsaka 797735
1546KumamotoJPNKumamoto 656734
1547OkayamaJPNOkayama 624269
1548SagamiharaJPNKanagawa 586300
1549HamamatsuJPNShizuoka 568796
1550KagoshimaJPNKagoshima 549977
1551FunabashiJPNChiba 545299
1552HigashiosakaJPNOsaka 517785
1553HachiojiJPNTokyo-to 513451
1554NiigataJPNNiigata 497464
1555AmagasakiJPNHyogo 481434
1556HimejiJPNHyogo 475167
1557ShizuokaJPNShizuoka 473854
1558UrawaJPNSaitama 469675
1559MatsuyamaJPNEhime 466133
1560MatsudoJPNChiba 461126
1561KanazawaJPNIshikawa 455386
1562KawaguchiJPNSaitama 452155
1563IchikawaJPNChiba 441893
1564OmiyaJPNSaitama 441649
1565UtsunomiyaJPNTochigi 440353
1566OitaJPNOita 433401
1567NagasakiJPNNagasaki 432759
1568YokosukaJPNKanagawa 430200
1569KurashikiJPNOkayama 425103
1570GifuJPNGifu 408007
1571HirakataJPNOsaka 403151
1572NishinomiyaJPNHyogo 397618
1573ToyonakaJPNOsaka 396689
1574WakayamaJPNWakayama 391233
1575FukuyamaJPNHiroshima 376921
1576FujisawaJPNKanagawa 372840
1577AsahikawaJPNHokkaido 364813
1578MachidaJPNTokyo-to 364197
1579NaraJPNNara 362812
1580TakatsukiJPNOsaka 361747
1581IwakiJPNFukushima 361737
1582NaganoJPNNagano 361391
1583ToyohashiJPNAichi 360066
1584ToyotaJPNAichi 346090
1585SuitaJPNOsaka 345750
1586TakamatsuJPNKagawa 332471
1587KoriyamaJPNFukushima 330335
1588OkazakiJPNAichi 328711
1589KawagoeJPNSaitama 327211
1590TokorozawaJPNSaitama 325809
1591ToyamaJPNToyama 325790
1592KochiJPNKochi 324710
1593KashiwaJPNChiba 320296
1594AkitaJPNAkita 314440
1860AlmatyKAZAlmaty Qalasy 1129400
1861QaraghandyKAZQaraghandy 436900
1862ShymkentKAZSouth Kazakstan 360100
1863TarazKAZTaraz 330100
1864AstanaKAZAstana 311200
1865ÖskemenKAZEast Kazakstan 311000
1866PavlodarKAZPavlodar 300500
1867SemeyKAZEast Kazakstan 269600
1881NairobiKENNairobi 2290000
1882MombasaKENCoast 461753
2253BishkekKGZBishkek shaary 589400
1800Phnom PenhKHMPhnom Penh 570155
2255BikenibeuKIRSouth Tarawa 5055
3064BasseterreKNASt George Basseterre11600
2331SeoulKORSeoul 9981619
2332PusanKORPusan 3804522
2333InchonKORInchon 2559424
2334TaeguKORTaegu 2548568
2335TaejonKORTaejon 1425835
2336KwangjuKORKwangju 1368341
2337UlsanKORKyongsangnam 1084891
2338SongnamKORKyonggi 869094
2339PuchonKORKyonggi 779412
2340SuwonKORKyonggi 755550
2341AnyangKORKyonggi 591106
2342ChonjuKORChollabuk 563153
2427al-SalimiyaKWTHawalli 130215
2428Jalib al-ShuyukhKWTHawalli 102178
2432VientianeLAOViangchan 531800
2438BeirutLBNBeirut 1100000
2440MonroviaLBRMontserrado 850000
2441TripoliLBYTripoli 1682000
2442BengasiLBYBengasi 804000
3065CastriesLCACastries 2301
2445SchaanLIESchaan 5346
3217ColomboLKAWestern 645000
2437MaseruLSOMaseru 297000
2447VilniusLTUVilna 577969
2448KaunasLTUKaunas 412639
2452Luxembourg [Luxemburg/Letzebuerg]LUXLuxembourg 80700
2434RigaLVARiika 764328
2454MacaoMACMacau 437500
2485CasablancaMARCasablanca 2940623
2486RabatMARRabat-Salé-Zammour-Z623457
2487MarrakechMARMarrakech-Tensift-Al621914
2488FcsMARFcs-Boulemane 541162
2489TangerMARTanger-Tétouan 521735
2490SaléMARRabat-Salé-Zammour-Z504420
2491MekncsMARMekncs-Tafilalet 460000
2694Monte-CarloMCONULL13154
2690ChisinauMDAChisinau 719900
2455AntananarivoMDGAntananarivo 675669
2463MaleMDVMaale 71000
2515Ciudad de MéxicoMEXDistrito Federal 8591309
2516GuadalajaraMEXJalisco 1647720
2517Ecatepec de MorelosMEXMéxico 1620303
2518PueblaMEXPuebla 1346176
2519NezahualcóyotlMEXMéxico 1224924
2520JuirezMEXChihuahua 1217818
2521TijuanaMEXBaja California 1212232
2522LeónMEXGuanajuato 1133576
2523MonterreyMEXNuevo León 1108499
2524ZapopanMEXJalisco 1002239
2525Naucalpan de JuirezMEXMéxico 857511
2526MexicaliMEXBaja California 764902
2527CuliacinMEXSinaloa 744859
2528Acapulco de JuirezMEXGuerrero 721011
2529Tlalnepantla de BazMEXMéxico 720755
2530MéridaMEXYucatin 703324
2531ChihuahuaMEXChihuahua 670208
2532San Luis PotoskMEXSan Luis Potosk 669353
2533GuadalupeMEXNuevo León 668780
2534TolucaMEXMéxico 665617
2535AguascalientesMEXAguascalientes 643360
2536QuerétaroMEXQuerétaro de Arteaga639839
2537MoreliaMEXMichoacin de Ocampo 619958
2538HermosilloMEXSonora 608697
2539SaltilloMEXCoahuila de Zaragoza577352
2540TorreónMEXCoahuila de Zaragoza529093
2541Centro (Villahermosa)MEXTabasco 519873
2542San Nicolis de los GarzaMEXNuevo León 495540
2543DurangoMEXDurango 490524
2544ChimalhuacinMEXMéxico 490245
2545TlaquepaqueMEXJalisco 475472
2546Atizapin de ZaragozaMEXMéxico 467262
2547VeracruzMEXVeracruz 457119
2548Cuautitlin IzcalliMEXMéxico 452976
2549IrapuatoMEXGuanajuato 440039
2550Tuxtla GutiérrezMEXChiapas 433544
2551TultitlinMEXMéxico 432411
2552ReynosaMEXTamaulipas 419776
2553Benito JuirezMEXQuintana Roo 419276
2554MatamorosMEXTamaulipas 416428
2555XalapaMEXVeracruz 390058
2556CelayaMEXGuanajuato 382140
2557MazatlinMEXSinaloa 380265
2558EnsenadaMEXBaja California 369573
2559AhomeMEXSinaloa 358663
2560CajemeMEXSonora 355679
2507Dalap-Uliga-DarritMHLMajuro 28000
2460SkopjeMKDSkopje 444299
2482BamakoMLIBamako 809552
2483BirkirkaraMLTOuter Harbour 21445
2710Rangoon (Yangon)MMRRangoon [Yangon] 3361700
2711MandalayMMRMandalay 885300
2696Ulan BatorMNGUlaanbaatar 773700
2913GarapanMNPSaipan 9200
2698MaputoMOZMaputo 1018938
2699MatolaMOZMaputo 424662
2700BeiraMOZSofala 397368
2701NampulaMOZNampula 303346
2509NouakchottMRTNouakchott 667300
2697PlymouthMSRPlymouth 2000
2508Fort-de-FranceMTQFort-de-France 94050
2511Port-LouisMUSPort-Louis 138200
2461BlantyreMWIBlantyre 478155
2464Kuala LumpurMYSWilayah Persekutuan 1297526
2465IpohMYSPerak 382853
2466Johor BaharuMYSJohor 328436
2514MamoutzouMYTMamoutzou 12000
2726WindhoekNAMKhomas 169000
3493NouméaNCLNULL76293
2738NiameyNERNiamey 420000
2806KingstonNFKNULL800
2741LagosNGALagos 1518000
2742IbadanNGAOyo & Osun 1432000
2743OgbomoshoNGAOyo & Osun 730000
2744KanoNGAKano & Jigawa 674100
2745OshogboNGAOyo & Osun 476800
2746IlorinNGAKwara & Kogi 475800
2747AbeokutaNGAOgun 427400
2748Port HarcourtNGARivers & Bayelsa 410000
2749ZariaNGAKaduna 379200
2750IleshaNGAOyo & Osun 378400
2751OnitshaNGAAnambra & Enugu & Eb371900
2752IwoNGAOyo & Osun 362000
2753Ado-EkitiNGAOndo & Ekiti 359400
2754AbujaNGAFederal Capital Dist350100
2755KadunaNGAKaduna 342200
2756MushinNGALagos 333200
2757MaiduguriNGABorno & Yobe 320000
2758EnuguNGAAnambra & Enugu & Eb316100
2759EdeNGAOyo & Osun 307100
2760AbaNGAImo & Abia 298900
2761IfeNGAOyo & Osun 296800
2734ManaguaNICManagua 959000
2805AlofiNIUNULL682
5AmsterdamNLDNoord-Holland 731200
6RotterdamNLDZuid-Holland 593321
7HaagNLDZuid-Holland 440900
8UtrechtNLDUtrecht 234323
9EindhovenNLDNoord-Brabant 201843
10TilburgNLDNoord-Brabant 193238
2807OsloNOROslo 508726
2808BergenNORHordaland 230948
2729KathmanduNPLCentral 591835
2727YangorNRUNULL4050
3494AucklandNZLAuckland 381800
3495ChristchurchNZLCanterbury 324200
3496ManukauNZLAuckland 281800
2817al-SibOMNMasqat 155000
2818SalalaOMNZufar 131813
2819BawsharOMNMasqat 107500
2822KarachiPAKSindh 9269265
2823LahorePAKPunjab 5063499
2824FaisalabadPAKPunjab 1977246
2825RawalpindiPAKPunjab 1406214
2826MultanPAKPunjab 1182441
2827HyderabadPAKSindh 1151274
2828GujranwalaPAKPunjab 1124749
2829PeshawarPAKNothwest Border Prov988005
2830QuettaPAKBaluchistan 560307
2882Ciudad de PanamiPANPanami 471373
2912AdamstownPCNNULL42
2890LimaPERLima 6464693
2891ArequipaPERArequipa 762000
2892TrujilloPERLa Libertad 652000
765QuezonPHLNational Capital Reg2173831
766ManilaPHLNational Capital Reg1581082
767KalookanPHLNational Capital Reg1177604
768DavaoPHLSouthern Mindanao 1147116
769CebuPHLCentral Visayas 718821
770ZamboangaPHLWestern Mindanao 601794
771PasigPHLNational Capital Reg505058
772ValenzuelaPHLNational Capital Reg485433
773Las PinasPHLNational Capital Reg472780
774AntipoloPHLSouthern Tagalog 470866
775TaguigPHLNational Capital Reg467375
776Cagayan de OroPHLNorthern Mindanao 461877
777ParanaquePHLNational Capital Reg449811
778MakatiPHLNational Capital Reg444867
779BacolodPHLWestern Visayas 429076
780General SantosPHLSouthern Mindanao 411822
781MarikinaPHLNational Capital Reg391170
782DasmarinasPHLSouthern Tagalog 379520
783MuntinlupaPHLNational Capital Reg379310
784IloiloPHLWestern Visayas 365820
785PasayPHLNational Capital Reg354908
786MalabonPHLNational Capital Reg338855
787San José del MontePHLCentral Luzon 315807
788BacoorPHLSouthern Tagalog 305699
789IliganPHLCentral Mindanao 285061
790CalambaPHLSouthern Tagalog 281146
791MandaluyongPHLNational Capital Reg278474
792ButuanPHLCaraga 267279
793AngelesPHLCentral Luzon 263971
794TarlacPHLCentral Luzon 262481
795MandauePHLCentral Visayas 259728
796BaguioPHLCAR 252386
797BatangasPHLSouthern Tagalog 247588
798CaintaPHLSouthern Tagalog 242511
799San PedroPHLSouthern Tagalog 231403
800NavotasPHLNational Capital Reg230403
2881KororPLWKoror 12000
2884Port MoresbyPNGNational Capital Dis247000
2928WarszawaPOLMazowieckie 1615369
2929LódzPOLLodzkie 800110
2930KrakówPOLMalopolskie 738150
2931WroclawPOLDolnoslaskie 636765
2932PoznanPOLWielkopolskie 576899
2933GdanskPOLPomorskie 458988
2934SzczecinPOLZachodnio-Pomorskie 416988
2935BydgoszczPOLKujawsko-Pomorskie 386855
2936LublinPOLLubelskie 356251
2937KatowicePOLSlaskie 345934
2938BialystokPOLPodlaskie 283937
2919San JuanPRISan Juan 434374
2920BayamónPRIBayamón 224044
2921PoncePRIPonce 186475
2922CarolinaPRICarolina 186076
2318PyongyangPRKPyongyang-si 2484000
2319HamhungPRKHamgyong N 709730
2320ChongjinPRKHamgyong P 582480
2321NampoPRKNampo-si 566200
2914LisboaPRTLisboa 563210
2915PortoPRTPorto 273060
2885AsunciónPRYAsunción 557776
4074GazaPSEGaza 353632
3015FaaaPYFTahiti 25888
2973DohaQATDoha 355000
3017Saint-DenisREUSaint-Denis 131480
3018BucurestiROMBukarest 2016131
3019IasiROMIasi 348070
3020ConstantaROMConstanta 342264
3021Cluj-NapocaROMCluj 332498
3022GalatiROMGalati 330276
3023TimisoaraROMTimis 324304
3024BrasovROMBrasov 314225
3025CraiovaROMDolj 313530
3580MoscowRUSMoscow (City) 8389200
3581St PetersburgRUSPietari 4694000
3582NovosibirskRUSNovosibirsk 1398800
3583Nizni NovgorodRUSNizni Novgorod 1357000
3584JekaterinburgRUSSverdlovsk 1266300
3585SamaraRUSSamara 1156100
3586OmskRUSOmsk 1148900
3587KazanRUSTatarstan 1101000
3588UfaRUSBaškortostan 1091200
3589TšeljabinskRUSTšeljabinsk 1083200
3590Rostov-na-DonuRUSRostov-na-Donu 1012700
3591PermRUSPerm 1009700
3592VolgogradRUSVolgograd 993400
3593VoronezRUSVoronez 907700
3594KrasnojarskRUSKrasnojarsk 875500
3595SaratovRUSSaratov 874000
3596ToljattiRUSSamara 722900
3597UljanovskRUSUljanovsk 667400
3598IzevskRUSUdmurtia 652800
3599KrasnodarRUSKrasnodar 639000
3600JaroslavlRUSJaroslavl 616700
3601HabarovskRUSHabarovsk 609400
3602VladivostokRUSPrimorje 606200
3603IrkutskRUSIrkutsk 593700
3604BarnaulRUSAltai 580100
3605NovokuznetskRUSKemerovo 561600
3606PenzaRUSPenza 532200
3607RjazanRUSRjazan 529900
3608OrenburgRUSOrenburg 523600
3609LipetskRUSLipetsk 521000
3610Nabereznyje TšelnyRUSTatarstan 514700
3611TulaRUSTula 506100
3612TjumenRUSTjumen 503400
3613KemerovoRUSKemerovo 492700
3614AstrahanRUSAstrahan 486100
3615TomskRUSTomsk 482100
3616KirovRUSKirov 466200
3617IvanovoRUSIvanovo 459200
3618TšeboksaryRUSTšuvassia 459200
3619BrjanskRUSBrjansk 457400
3620TverRUSTver 454900
3621KurskRUSKursk 443500
3622MagnitogorskRUSTšeljabinsk 427900
3623KaliningradRUSKaliningrad 424400
3624Nizni TagilRUSSverdlovsk 390900
3625MurmanskRUSMurmansk 376300
3626Ulan-UdeRUSBurjatia 370400
3047KigaliRWAKigali 286000
3173RiyadhSAURiyadh 3324000
3174JeddaSAUMekka 2046300
3175MekkaSAUMekka 965700
3176MedinaSAUMedina 608300
3177al-DammamSAUal-Sharqiya 482300
3224OmdurmanSDNKhartum 1271403
3225KhartumSDNKhartum 947483
3226Sharq al-NilSDNKhartum 700887
3197PikineSENCap-Vert 855287
3198DakarSENCap-Vert 785071
3208SingaporeSGPNULL4017733
3063JamestownSHNSaint Helena 1500
938LongyearbyenSJMLänsimaa 1438
3161HoniaraSLBHoniara 50100
3207FreetownSLEWestern 850000
645San SalvadorSLVSan Salvador 415346
3170SerravalleSMRSerravalle/Dogano 4802
3214MogadishuSOMBanaadir 997000
3067Saint-PierreSPMSaint-Pierre 5808
3172Sco ToméSTPAqua Grande 49541
3243ParamariboSURParamaribo 112000
3209BratislavaSVKBratislava 448292
3212LjubljanaSVNOsrednjeslovenska 270986
3048StockholmSWELisboa 750348
3049Gothenburg [Göteborg]SWEWest Götanmaan län 466990
3050MalmöSWESkåne län 259579
3244MbabaneSWZHhohho 61000
3206VictoriaSYCMahé 41000
3250DamascusSYRDamascus 1347000
3251AleppoSYRAleppo 1261983
3252HimsSYRHims 507404
3423Cockburn TownTCAGrand Turk 4800
3337N´DjaménaTCDChari-Baguirmi 530965
3332LoméTGOMaritime 375000
3320BangkokTHABangkok 6320174
3261DushanbeTJKKarotegin 524000
3333FakaofoTKLFakaofo 300
3419AshgabatTKMAhal 540600
1522DiliTMPDili 47900
3334Nuku´alofaTONTongatapu 22400
3335ChaguanasTTOCaroni 56601
3349TunisTUNTunis 690600
3350SfaxTUNSfax 257800
3357IstanbulTURIstanbul 8787958
3358AnkaraTURAnkara 3038159
3359IzmirTURIzmir 2130359
3360AdanaTURAdana 1131198
3361BursaTURBursa 1095842
3362GaziantepTURGaziantep 789056
3363KonyaTURKonya 628364
3364Mersin (Ieel)TURIeel 587212
3365AntalyaTURAntalya 564914
3366DiyarbakirTURDiyarbakir 479884
3367KayseriTURKayseri 475657
3368EskisehirTUREskisehir 470781
3424FunafutiTUVFunafuti 4600
3263TaipeiTWNTaipei 2641312
3264KaohsiungTWNKaohsiung 1475505
3265TaichungTWNTaichung 940589
3266TainanTWNTainan 728060
3267PanchiaoTWNTaipei 523850
3268ChunghoTWNTaipei 392176
3269Keelung (Chilung)TWNKeelung 385201
3270SanchungTWNTaipei 380084
3271HsinchuangTWNTaipei 365048
3272HsinchuTWNHsinchu 361958
3305Dar es SalaamTZADar es Salaam 1747000
3425KampalaUGACentral 890800
3426KyivUKRKiova 2624000
3427Harkova [Harkiv]UKRHarkova 1500000
3428DnipropetrovskUKRDnipropetrovsk 1103000
3429DonetskUKRDonetsk 1050000
3430OdesaUKROdesa 1011000
3431ZaporizzjaUKRZaporizzja 848000
3432LvivUKRLviv 788000
3433Kryvyi RigUKRDnipropetrovsk 703000
3434MykolajivUKRMykolajiv 508000
3435MariupolUKRDonetsk 490000
3436LuganskUKRLugansk 469000
3437VinnytsjaUKRVinnytsja 391000
3438MakijivkaUKRDonetsk 384000
3439HersonUKRHerson 353000
3492MontevideoURYMontevideo 1236000
3793New YorkUSANew York 8008278
3794Los AngelesUSACalifornia 3694820
3795ChicagoUSAIllinois 2896016
3796HoustonUSATexas 1953631
3797PhiladelphiaUSAPennsylvania 1517550
3798PhoenixUSAArizona 1321045
3799San DiegoUSACalifornia 1223400
3800DallasUSATexas 1188580
3801San AntonioUSATexas 1144646
3802DetroitUSAMichigan 951270
3803San JoseUSACalifornia 894943
3804IndianapolisUSAIndiana 791926
3805San FranciscoUSACalifornia 776733
3806JacksonvilleUSAFlorida 735167
3807ColumbusUSAOhio 711470
3808AustinUSATexas 656562
3809BaltimoreUSAMaryland 651154
3810MemphisUSATennessee 650100
3811MilwaukeeUSAWisconsin 596974
3812BostonUSAMassachusetts 589141
3813WashingtonUSADistrict of Columbia572059
3814Nashville-DavidsonUSATennessee 569891
3815El PasoUSATexas 563662
3816SeattleUSAWashington 563374
3817DenverUSAColorado 554636
3818CharlotteUSANorth Carolina 540828
3819Fort WorthUSATexas 534694
3820PortlandUSAOregon 529121
3821Oklahoma CityUSAOklahoma 506132
3822TucsonUSAArizona 486699
3823New OrleansUSALouisiana 484674
3824Las VegasUSANevada 478434
3825ClevelandUSAOhio 478403
3826Long BeachUSACalifornia 461522
3827AlbuquerqueUSANew Mexico 448607
3828Kansas CityUSAMissouri 441545
3829FresnoUSACalifornia 427652
3830Virginia BeachUSAVirginia 425257
3831AtlantaUSAGeorgia 416474
3832SacramentoUSACalifornia 407018
3833OaklandUSACalifornia 399484
3834MesaUSAArizona 396375
3835TulsaUSAOklahoma 393049
3836OmahaUSANebraska 390007
3837MinneapolisUSAMinnesota 382618
3838HonoluluUSAHawaii 371657
3839MiamiUSAFlorida 362470
3840Colorado SpringsUSAColorado 360890
3841Saint LouisUSAMissouri 348189
3842WichitaUSAKansas 344284
3843Santa AnaUSACalifornia 337977
3844PittsburghUSAPennsylvania 334563
3845ArlingtonUSATexas 332969
3846CincinnatiUSAOhio 331285
3847AnaheimUSACalifornia 328014
3848ToledoUSAOhio 313619
3849TampaUSAFlorida 303447
3850BuffaloUSANew York 292648
3851Saint PaulUSAMinnesota 287151
3503ToskentUZBToskent Shahri 2117500
3504NamanganUZBNamangan 370500
3505SamarkandUZBSamarkand 361800
3506AndijonUZBAndijon 318600
3538Citta del VaticanoVATNULL455
3066KingstownVCTSt George 17100
3539CaracasVENDistrito Federal 1975294
3540MaracakboVENZulia 1304776
3541BarquisimetoVENLara 877239
3542ValenciaVENCarabobo 794246
3543Ciudad GuayanaVENBolkvar 663713
3544PetareVENMiranda 488868
3545MaracayVENAragua 444443
3546BarcelonaVENAnzoitegui 322267
3547MaturknVENMonagas 319726
3548San CristóbalVENTichira 319373
3549Ciudad BolkvarVENBolkvar 301107
537Road TownVGBTortola 8000
4067Charlotte AmalieVIRSt Thomas 13000
3769Ho Chi Minh CityVNMHo Chi Minh City 3980000
3770HanoiVNMHanoi 1410000
3771HaiphongVNMHaiphong 783133
3537Port-VilaVUTShefa 33700
3536Mata-UtuWLFWallis 1137
3169ApiaWSMUpolu 35900
1780SanaaYEMSanaa 503600
1781AdenYEMAden 398300
1782TaizzYEMTaizz 317600
1783HodeidaYEMHodeida 298500
1792BeogradYUGCentral Serbia 1204000
712Cape TownZAFWestern Cape 2352121
713SowetoZAFGauteng 904165
714JohannesburgZAFGauteng 756653
715Port ElizabethZAFEastern Cape 752319
716PretoriaZAFGauteng 658630
717InandaZAFKwaZulu-Natal 634065
718DurbanZAFKwaZulu-Natal 566120
719VanderbijlparkZAFGauteng 468931
720Kempton ParkZAFGauteng 442633
721AlbertonZAFGauteng 410102
722PinetownZAFKwaZulu-Natal 378810
723PietermaritzburgZAFKwaZulu-Natal 370190
724BenoniZAFGauteng 365467
3162LusakaZMBLusaka 1317000
4068HarareZWEHarare 1410000
4069BulawayoZWEBulawayo 621742
In [60]:
--Riigid, kus on riigi asuva kontinendi laiemalt levinud juhtimisvorm
SELECT  * 
FROM tCountry A
WHERE A.GovernmentForm =
(SELECT TOP 1 GovernmentForm
FROM tCountry
WHERE Continent =A.Continent
GROUP BY GovernmentForm
Order by COUNT(GovernmentForm) DESC )
(124 rows affected)
Total execution time: 00:00:00.020
Out[60]:
CodeCountryNameContinentRegionSurfaceAreaIndepYearPopulationLifeExpectancyGNPGNPOldLocalNameGovernmentFormHeadOfStateCapital
AGOAngolaAfricaCentral Africa1246700,0019751287800038,36648,007984,00AngolaRepublicJosé Eduardo dos Santos56
ALBAlbaniaEuropeSouthern Europe28748,001912340120071,63205,002500,00ShqiptarëtRepublicRexhep Mejdani34
ARMArmeniaAsiaMiddle East29800,001991352000066,41813,001627,00HajastanRepublicRobert Kot?arjan126
BDIBurundiAfricaEastern Africa27834,001962669500046,2903,00982,00Burundi/UburundiRepublicPierre Buyoya552
BENBeninAfricaWestern Africa112622,001960609700050,22357,002141,00BéninRepublicMathieu Kérékou187
BFABurkina FasoAfricaWestern Africa274000,0019601193700046,72425,002201,00Burkina FasoRepublicBlaise Compaoré549
BGDBangladeshAsiaSouthern and Central Asia143998,00197112915500060,232852,0031966,00BangladeshRepublicShahabuddin Ahmad150
BGRBulgariaEuropeEastern Europe110994,001908819090070,912178,0010169,00BalgarijaRepublicPetar Stojanov539
BLRBelarusEuropeEastern Europe207600,0019911023600068,013714,00NULLBelarusRepublicAljaksandr Luka?enka3520
BOLBoliviaSouth AmericaSouth America1098581,001825832900063,78571,007967,00BoliviaRepublicHugo B?nzer Su?rez194
BVTBouvet IslandAntarcticaAntarctica59,00NULL0NULL0,00NULLBouvet¸yaDependent Territory of NorwayHarald VNULL
BWABotswanaAfricaSouthern Africa581730,001966162200039,34834,004935,00BotswanaRepublicFestus G. Mogae204
CAFCentral African RepublicAfricaCentral Africa622984,001960361500044,01054,00993,00Centrafrique/B?-Afr?kaRepublicAnge-Félix Patassé1889
CHLChileSouth AmericaSouth America756626,0018101521100075,772949,0075780,00ChileRepublicRicardo Lagos Escobar554
CHNChinaAsiaEastern Asia9572900,00-1523127755800071,4982268,00917719,00ZhongquoRepublicJiang Zemin1891
CIVC?te d’IvoireAfricaWestern Africa322463,0019601478600045,211345,0010285,00C?te d’IvoireRepublicLaurent Gbagbo2814
CMRCameroonAfricaCentral Africa475442,0019601508500054,89174,008596,00Cameroun/CameroonRepublicPaul Biya1804
CODCongo, The Democratic Republic of theAfricaCentral Africa2344858,0019605165400048,86964,002474,00République Démocratique du CongoRepublicJoseph Kabila2298
COGCongoAfricaCentral Africa342000,001960294300047,42108,002287,00CongoRepublicDenis Sassou-Nguesso2296
COLColombiaSouth AmericaSouth America1138914,0018104232100070,3102896,00105116,00ColombiaRepublicAndrés Pastrana Arango2257
COMComorosAfricaEastern Africa1862,00197557800060,04401,004361,00Komori/ComoresRepublicAzali Assoumani2295
CPVCape VerdeAfricaWestern Africa4033,00197542800068,9435,00420,00Cabo VerdeRepublicAntónio Mascarenhas Monteiro1859
CRICosta RicaNorth AmericaCentral America51100,001821402300075,810226,009757,00Costa RicaRepublicMiguel ?ngel Rodr?guez Echeverr?a584
CYPCyprusAsiaMiddle East9251,00196075470076,79333,008246,00Κύπρος/KıbrısRepublicGlafkos Klerides2430
CZECzech RepublicEuropeEastern Europe78866,0019931027810074,555017,0052037,00ČeskáRepublicV?clav Havel3339
DJIDjiboutiAfricaEastern Africa23200,00197763800050,8382,00373,00Djibouti/JibutiRepublicIsmail Omar Guelleh585
DMADominicaNorth AmericaCaribbean751,0019787100073,4256,00243,00DominicaRepublicVernon Shaw586
DOMDominican RepublicNorth AmericaCaribbean48511,001844849500073,215846,0015076,00Rep?blica DominicanaRepublicHipólito Mej?a Dom?nguez587
DZAAlgeriaAfricaNorthern Africa2381741,0019623147100069,749982,0046966,00Al-Jaza’’ir/AlgérieRepublicAbdelaziz Bouteflika35
ECUEcuadorSouth AmericaSouth America283561,0018221264600071,119770,0019769,00EcuadorRepublicGustavo Noboa Bejarano594
EGYEgyptAfricaNorthern Africa1001449,0019226847000063,382710,0075617,00MisrRepublicHosni Mubarak608
ERIEritreaAfricaEastern Africa117600,001993385000055,8650,00755,00ErtraRepublicIsayas Afewerki [Isaias Afwerki]652
ESTEstoniaEuropeBaltic Countries45227,001991143920069,55328,003371,00EestiRepublicLennart Meri3791
ETHEthiopiaAfricaEastern Africa1104300,00-10006256500045,26353,006180,00YeItyop´iyaRepublicNegasso Gidada756
FINFinlandEuropeNordic Countries338145,001917517130077,4121914,00119833,00SuomiRepublicTarja Halonen3236
FJIFiji IslandsOceaniaMelanesia18274,00197081700067,91536,002149,00Fiji IslandsRepublicJosefa Iloilo764
FRAFranceEuropeWestern Europe551500,008435922570078,81424285,001392448,00FranceRepublicJacques Chirac2974
GABGabonAfricaCentral Africa267668,001960122600050,15493,005279,00Le GabonRepublicOmar Bongo902
GEOGeorgiaAsiaMiddle East69700,001991496800064,56064,005924,00SakartveloRepublicEduard ?evardnadze905
GHAGhanaAfricaWestern Africa238533,0019572021200057,47137,006884,00GhanaRepublicJohn Kufuor910
GINGuineaAfricaWestern Africa245857,001958743000045,62352,002383,00GuinéeRepublicLansana Conté926
GMBGambiaAfricaWestern Africa11295,001965130500053,2320,00325,00The GambiaRepublicYahya Jammeh904
GNBGuinea-BissauAfricaWestern Africa36125,001974121300049,0293,00272,00Guiné-BissauRepublicKumba Ial?927
GNQEquatorial GuineaAfricaCentral Africa28051,00196845300053,6283,00542,00Guinea EcuatorialRepublicTeodoro Obiang Nguema Mbasogo2972
GRCGreeceEuropeSouthern Europe131626,0018301054570078,4120724,00119946,00ΕλλάςRepublicKostis Stefanopoulos2401
GTMGuatemalaNorth AmericaCentral America108889,0018211138500066,219008,0017797,00GuatemalaRepublicAlfonso Portillo Cabrera922
GUYGuyanaSouth AmericaSouth America214969,00196686100064,0722,00743,00GuyanaRepublicBharrat Jagdeo928
HNDHondurasNorth AmericaCentral America112088,001838648500069,95333,004697,00HondurasRepublicCarlos Roberto Flores Facussé933
HRVCroatiaEuropeSouthern Europe56538,001991447300073,720208,0019300,00HrvatskaRepublic?tipe Mesic2409
HTIHaitiNorth AmericaCaribbean27750,001804822200049,23459,003107,00Ha?ti/DaytiRepublicJean-Bertrand Aristide929
HUNHungaryEuropeEastern Europe93030,0019181004320071,448267,0045914,00Magyarorsz?gRepublicFerenc M?dl3483
IDNIndonesiaAsiaSoutheast Asia1904569,00194521210700068,084982,00215002,00IndonesiaRepublicAbdurrahman Wahid939
IRLIrelandEuropeBritish Islands70273,001921377510076,875921,0073132,00Ireland/ÉireRepublicMary McAleese1447
IRQIraqAsiaMiddle East438317,0019322311500066,511500,00NULLAl-´IraqRepublicSaddam Hussein al-Takriti1365
ISLIcelandEuropeNordic Countries103000,00194427900079,48255,007474,00ÍslandRepublicÓlafur Ragnar Gr?msson1449
ISRIsraelAsiaMiddle East21056,001948621700078,697477,0098577,00Yīsraʾel/Isra’’ilRepublicMoshe Katzav1450
ITAItalyEuropeSouthern Europe301316,0018615768000079,01161755,001145372,00ItaliaRepublicCarlo Azeglio Ciampi1464
KAZKazakstanAsiaSouthern and Central Asia2724900,0019911622300063,224375,0023383,00QazaqstanRepublicNursultan Nazarbajev1864
KENKenyaAfricaEastern Africa580367,0019633008000048,09217,0010241,00KenyaRepublicDaniel arap Moi1881
KGZKyrgyzstanAsiaSouthern and Central Asia199900,001991469900063,41626,001767,00KyrgyzstanRepublicAskar Akajev2253
KIRKiribatiOceaniaMicronesia726,0019798300059,840,70NULLKiribatiRepublicTeburoro Tito2256
KORSouth KoreaAsiaEastern Asia99434,0019484684400074,4320749,00442544,00Taehan Min’guk (Namhan)RepublicKim Dae-jung2331
LAOLaosAsiaSoutheast Asia236800,001953543300053,11292,001746,00LaoRepublicKhamtay Siphandone2432
LBNLebanonAsiaMiddle East10400,001941328200071,317121,0015129,00LubnanRepublicÉmile Lahoud2438
LBRLiberiaAfricaWestern Africa111369,001847315400051,02012,00NULLLiberiaRepublicCharles Taylor2440
LKASri LankaAsiaSouthern and Central Asia65610,0019481882700071,815706,0015091,00Sri Lanka/IlankaiRepublicChandrika Kumaratunga3217
LTULithuaniaEuropeBaltic Countries65301,001991369850069,110692,009585,00LietuvaRepublicValdas Adamkus2447
LVALatviaEuropeBaltic Countries64589,001991242420068,46398,005639,00LatvijaRepublicVaira Vike-Freiberga2434
MDAMoldovaEuropeEastern Europe33851,001991438000064,51579,001872,00MoldovaRepublicVladimir Voronin2690
MDVMaldivesAsiaSouthern and Central Asia298,00196528600062,2199,00NULLDhivehi Raajje/MaldivesRepublicMaumoon Abdul Gayoom2463
MHLMarshall IslandsOceaniaMicronesia181,0019906400065,597,00NULLMarshall Islands/MajolRepublicKessai Note2507
MKDMacedoniaEuropeSouthern Europe25713,001991202400073,81694,001915,00MakedonijaRepublicBoris Trajkovski2460
MLIMaliAfricaWestern Africa1240192,0019601123400046,72642,002453,00MaliRepublicAlpha Oumar Konaré2482
MLTMaltaEuropeSouthern Europe316,00196438020077,93512,003338,00MaltaRepublicGuido de Marco2484
MMRMyanmarAsiaSoutheast Asia676578,0019484561100054,9180375,00171028,00Myanma PyeRepublickenraali Than Shwe2710
MNGMongoliaAsiaEastern Asia1566500,001921266200067,31043,00933,00Mongol UlsRepublicNatsagiin Bagabandi2696
MOZMozambiqueAfricaEastern Africa801590,0019751968000037,52891,002711,00Mo?ambiqueRepublicJoaqu?m A. Chissano2698
MRTMauritaniaAfricaWestern Africa1025520,001960267000050,8998,001081,00Muritaniya/MauritanieRepublicMaaouiya Ould Sid´Ahmad Taya2509
MUSMauritiusAfricaEastern Africa2040,001968115800071,04251,004186,00MauritiusRepublicCassam Uteem2511
MWIMalawiAfricaEastern Africa118484,0019641092500037,61687,002527,00MalawiRepublicBakili Muluzi2462
NAMNamibiaAfricaSouthern Africa824292,001990172600042,53101,003384,00NamibiaRepublicSam Nujoma2726
NERNigerAfricaWestern Africa1267000,0019601073000041,31706,001580,00NigerRepublicMamadou Tandja2738
NICNicaraguaNorth AmericaCentral America130000,001838507400068,71988,002023,00NicaraguaRepublicArnoldo Alem?n Lacayo2734
NRUNauruOceaniaMicronesia21,0019681200060,8197,00NULLNaoero/NauruRepublicBernard Dowiyogo2728
PAKPakistanAsiaSouthern and Central Asia796095,00194715648300061,161289,0058549,00PakistanRepublicMohammad Rafiq Tarar2831
PANPanamaNorth AmericaCentral America75517,001903285600075,59131,008700,00PanamáRepublicMireya Elisa Moscoso Rodr?guez2882
PERPeruSouth AmericaSouth America1285216,0018212566200070,064140,0065186,00Perú/PiruwRepublicValentin Paniagua Corazao2890
PHLPhilippinesAsiaSoutheast Asia300000,0019467596700067,565107,0082239,00PilipinasRepublicGloria Macapagal-Arroyo766
PLWPalauOceaniaMicronesia459,0019941900068,6105,00NULLBelau/PalauRepublicKuniwo Nakamura2881
POLPolandEuropeEastern Europe323250,0019183865360073,2151697,00135636,00PolskaRepublicAleksander Kwasniewski2928
PRTPortugalEuropeSouthern Europe91982,001143999760075,8105954,00102133,00PortugalRepublicJorge Samp?io2914
PRYParaguaySouth AmericaSouth America406752,001811549600073,78444,009555,00ParaguayRepublicLuis ?ngel Gonz?lez Macchi2885
ROMRomaniaEuropeEastern Europe238391,0018782245550069,938158,0034843,00RomâniaRepublicIon Iliescu3018
RWARwandaAfricaEastern Africa26338,001962773300039,32036,001863,00Rwanda/UrwandaRepublicPaul Kagame3047
SENSenegalAfricaWestern Africa196722,001960948100062,24787,004542,00Sénégal/SounougalRepublicAbdoulaye Wade3198
SGPSingaporeAsiaSoutheast Asia618,001965356700080,186503,0096318,00Singapore/Singapura/Xinjiapo/SingapurRepublicSellapan Rama Nathan3208
SLESierra LeoneAfricaWestern Africa71740,001961485400045,3746,00858,00Sierra LeoneRepublicAhmed Tejan Kabbah3207
SLVEl SalvadorNorth AmericaCentral America21041,001841627600069,711863,0011203,00El SalvadorRepublicFrancisco Guillermo Flores Pérez645
SMRSan MarinoEuropeSouthern Europe61,008852700081,1510,00NULLSan MarinoRepublicNULL3171
SOMSomaliaAfricaEastern Africa637657,0019601009700046,2935,00NULLSoomaaliyaRepublicAbdiqassim Salad Hassan3214
STPSao Tome and PrincipeAfricaCentral Africa964,00197514700065,36,00NULLS?o Tomé e Pr?ncipeRepublicMiguel Trovoada3172
SURSurinameSouth AmericaSouth America163265,00197541700071,4870,00706,00SurinameRepublicRonald Venetiaan3243
SVKSlovakiaEuropeEastern Europe49012,001993539870073,720594,0019452,00SlovenskoRepublicRudolf Schuster3209
SVNSloveniaEuropeSouthern Europe20256,001991198780074,919756,0018202,00SlovenijaRepublicMilan Kucan3212
SYCSeychellesAfricaEastern Africa455,0019767700070,4536,00539,00Sesel/SeychellesRepublicFrance-Albert René3206
SYRSyriaAsiaMiddle East185180,0019411612500068,565984,0064926,00SuriyaRepublicBashar al-Assad3250
TCDChadAfricaCentral Africa1284000,001960765100050,51208,001102,00Tchad/TshadRepublicIdriss Déby3337
TGOTogoAfricaWestern Africa56785,001960462900054,71449,001400,00TogoRepublicGnassingbé Eyadéma3332
TJKTajikistanAsiaSouthern and Central Asia143100,001991618800064,11990,001056,00To?ikistonRepublicEmomali Rahmonov3261
TKMTurkmenistanAsiaSouthern and Central Asia488100,001991445900060,94397,002000,00TürkmenostanRepublicSaparmurad Nijazov3419
TTOTrinidad and TobagoNorth AmericaCaribbean5130,001962129500068,06232,005867,00Trinidad and TobagoRepublicArthur N. R. Robinson3336
TUNTunisiaAfricaNorthern Africa163610,001956958600073,720026,0018898,00Tunis/TunisieRepublicZine al-Abidine Ben Ali3349
TURTurkeyAsiaMiddle East774815,0019236659100071,0210721,00189122,00TürkiyeRepublicAhmet Necdet Sezer3358
TWNTaiwanAsiaEastern Asia36188,0019452225600076,4256254,00263451,00T’ai-wanRepublicChen Shui-bian3263
TZATanzaniaAfricaEastern Africa883749,0019613351700052,38005,007388,00TanzaniaRepublicBenjamin William Mkapa3306
UGAUgandaAfricaEastern Africa241038,0019622177800042,96313,006887,00UgandaRepublicYoweri Museveni3425
UKRUkraineEuropeEastern Europe603700,0019915045600066,042168,0049677,00UkrajinaRepublicLeonid Kut?ma3426
URYUruguaySouth AmericaSouth America175016,001828333700075,220831,0019967,00UruguayRepublicJorge Batlle Ib??ez3492
UZBUzbekistanAsiaSouthern and Central Asia447400,0019912431800063,714194,0021300,00UzbekistonRepublicIslam Karimov3503
VUTVanuatuOceaniaMelanesia12189,00198019000060,6261,00246,00VanuatuRepublicJohn Bani3537
YEMYemenAsiaMiddle East527968,0019181811200059,86041,005729,00Al-YamanRepublicAli Abdallah Salih1780
ZAFSouth AfricaAfricaSouthern Africa1221037,0019104037700051,1116729,00129092,00South AfricaRepublicThabo Mbeki716
ZMBZambiaAfricaEastern Africa752618,001964916900037,23377,003922,00ZambiaRepublicFrederick Chiluba3162
ZWEZimbabweAfricaEastern Africa390757,0019801166900037,85951,008670,00ZimbabweRepublicRobert G. Mugabe4068