%%capture
%load_ext sql
%sql sqlite:///factbook.db
'Connected: None@factbook.db'
%%sql
SELECT *
FROM sqlite_master
WHERE type='table';
Done.
type | name | tbl_name | rootpage | sql |
---|---|---|---|---|
table | sqlite_sequence | sqlite_sequence | 3 | CREATE TABLE sqlite_sequence(name,seq) |
table | facts | facts | 47 | CREATE TABLE "facts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "name" varchar(255) NOT NULL, "area" integer, "area_land" integer, "area_water" integer, "population" integer, "population_growth" float, "birth_rate" float, "death_rate" float, "migration_rate" float) |
%%sql
SELECT *
FROM facts
LIMIT 5;
Done.
id | code | name | area | area_land | area_water | population | population_growth | birth_rate | death_rate | migration_rate |
---|---|---|---|---|---|---|---|---|---|---|
1 | af | Afghanistan | 652230 | 652230 | 0 | 32564342 | 2.32 | 38.57 | 13.89 | 1.51 |
2 | al | Albania | 28748 | 27398 | 1350 | 3029278 | 0.3 | 12.92 | 6.58 | 3.3 |
3 | ag | Algeria | 2381741 | 2381741 | 0 | 39542166 | 1.84 | 23.67 | 4.31 | 0.92 |
4 | an | Andorra | 468 | 468 | 0 | 85580 | 0.12 | 8.13 | 6.96 | 0.0 |
5 | ao | Angola | 1246700 | 1246700 | 0 | 19625353 | 2.78 | 38.78 | 11.49 | 0.46 |
%%sql
SELECT MIN(population), MAX(population), MIN(population_growth),MAX(population_growth)
FROM facts;
Done.
MIN(population) | MAX(population) | MIN(population_growth) | MAX(population_growth) |
---|---|---|---|
0 | 7256490011 | 0.0 | 4.02 |
%%sql
SELECT
name, MIN(population)
FROM facts;
Done.
name | MIN(population) |
---|---|
Antarctica | 0 |
%%sql
SELECT
name, MAX(population)
FROM facts;
Done.
name | MAX(population) |
---|---|
World | 7256490011 |
%%sql
SELECT MIN(population), MAX(population), MIN(population_growth),MAX(population_growth)
FROM facts
WHERE name <> 'World';
Done.
MIN(population) | MAX(population) | MIN(population_growth) | MAX(population_growth) |
---|---|---|---|
0 | 1367485388 | 0.0 | 4.02 |
%%sql
SELECT
AVG(population), AVG(area)
FROM facts
WHERE name <> 'World';
Done.
AVG(population) | AVG(area) |
---|---|
32242666.56846473 | 555093.546184739 |
%%sql
SELECT
name, population, area
FROM facts
WHERE population > (SELECT
AVG(population)
FROM facts WHERE name <> 'World')
AND area < (SELECT
AVG(area)
FROM facts WHERE name <> 'World');
Done.
name | population | area |
---|---|---|
Bangladesh | 168957745 | 148460 |
Germany | 80854408 | 357022 |
Iraq | 37056169 | 438317 |
Italy | 61855120 | 301340 |
Japan | 126919659 | 377915 |
Korea, South | 49115196 | 99720 |
Morocco | 33322699 | 446550 |
Philippines | 100998376 | 300000 |
Poland | 38562189 | 312685 |
Spain | 48146134 | 505370 |
Thailand | 67976405 | 513120 |
Uganda | 37101745 | 241038 |
United Kingdom | 64088222 | 243610 |
Vietnam | 94348835 | 331210 |
%%sql
SELECT name, MAX(population)
FROM facts
WHERE name <> 'World';
Done.
name | MAX(population) |
---|---|
China | 1367485388 |
%%sql
SELECT name, MAX(population_growth)
FROM facts
WHERE name <> 'World';
Done.
name | MAX(population_growth) |
---|---|
South Sudan | 4.02 |
%%sql
SELECT
name, CAST(area_water AS Float) / CAST(area_land AS Float) AS 'ration_water_to_land'
FROM facts
ORDER BY ration_water_to_land DESC;
Done.
name | ration_water_to_land |
---|---|
British Indian Ocean Territory | 905.6666666666666 |
Virgin Islands | 4.520231213872832 |
Puerto Rico | 0.5547914317925592 |
Bahamas, The | 0.3866133866133866 |
Guinea-Bissau | 0.2846728307254623 |
Malawi | 0.25939625850340137 |
Netherlands | 0.22571032366565366 |
Uganda | 0.22292237442922375 |
Eritrea | 0.16435643564356436 |
Liberia | 0.15623961794019933 |
Bangladesh | 0.1405085657217485 |
Gambia, The | 0.116600790513834 |
Taiwan | 0.1153130812151271 |
Finland | 0.11299639583299047 |
India | 0.10563390940312317 |
Canada | 0.09799992456155804 |
Sweden | 0.09738384490720996 |
Colombia | 0.09647636468662751 |
Brunei | 0.0949667616334283 |
Guyana | 0.09205025171578214 |
French Polynesia | 0.08884243532793311 |
Nicaragua | 0.08650720893407784 |
Burundi | 0.0837227414330218 |
Iran | 0.07612978626856316 |
United States | 0.07255091319919764 |
Tanzania | 0.06942876495822985 |
Vietnam | 0.06817815332021801 |
Rwanda | 0.06769904329495703 |
Estonia | 0.06700009436633009 |
Norway | 0.06415101780585115 |
Armenia | 0.054604120129064286 |
Tunisia | 0.05310247167868177 |
Uzbekistan | 0.051716031969910675 |
Indonesia | 0.0513367141963679 |
Suriname | 0.05012820512820513 |
Albania | 0.04927366961092051 |
Ghana | 0.048344635723169826 |
Azerbaijan | 0.048058187803313605 |
Togo | 0.044129815206398824 |
Russia | 0.04399263341674328 |
Kyrgyzstan | 0.04249195781043894 |
Tonga | 0.04184100418410042 |
Ukraine | 0.04180691488443547 |
Lithuania | 0.041799617102744095 |
West Bank | 0.03900709219858156 |
Gabon | 0.03880978161735884 |
Turkmenistan | 0.038665333134722195 |
Hungary | 0.038166235157575217 |
Latvia | 0.03759096531671192 |
Romania | 0.03697404422095689 |
Japan | 0.036846509458551106 |
Burma | 0.03530178666519767 |
Congo, Democratic Republic of the | 0.03432216697661452 |
Venezuela | 0.034011677342554274 |
Pakistan | 0.03271606940165397 |
Hong Kong | 0.032618825722273995 |
Solomon Islands | 0.03251625812906453 |
Switzerland | 0.032002400180013504 |
Moldova | 0.029187315679061143 |
China | 0.029009018475490568 |
Korea, South | 0.028889806025588115 |
Poland | 0.027707022070302872 |
Iceland | 0.02743142144638404 |
Montenegro | 0.026761819803746655 |
Nepal | 0.02671763712844696 |
Botswana | 0.026467630088401885 |
Laos | 0.025996533795493933 |
Cambodia | 0.025606888932951873 |
Italy | 0.024478139661385734 |
Ecuador | 0.02427386116940771 |
Germany | 0.023948008443465493 |
Paraguay | 0.023785432743857318 |
Belarus | 0.023164120256283883 |
Papua New Guinea | 0.022037715850373184 |
Bulgaria | 0.022029883213966393 |
Senegal | 0.02177323014595128 |
Israel | 0.02164289227742253 |
Czech Republic | 0.02097168822090178 |
Ireland | 0.02017914434621024 |
Kenya | 0.019726253645851635 |
Chad | 0.019695044472681066 |
Slovakia | 0.01933270969753664 |
Brazil | 0.018859459161966657 |
Tajikistan | 0.018302593456292843 |
Turkey | 0.018099559269884827 |
Benin | 0.018079586339064563 |
Austria | 0.017296379404451452 |
Lebanon | 0.016617790811339198 |
Mozambique | 0.016531447900506115 |
Chile | 0.01652299236903949 |
Saint Lucia | 0.0165016501650165 |
Somalia | 0.016450488334021428 |
New Caledonia | 0.016415868673050615 |
Mali | 0.016392529032363812 |
Guatemala | 0.016144234268703515 |
Argentina | 0.015971849204696183 |
Denmark | 0.015553565537069332 |
El Salvador | 0.015443270112446311 |
Sri Lanka | 0.01516323688689463 |
Jamaica | 0.01477241251961961 |
Singapore | 0.01455604075691412 |
Panama | 0.014527845036319613 |
Nigeria | 0.014273667937389104 |
Bolivia | 0.014105036365700761 |
Cote d'Ivoire | 0.014025024921148543 |
Spain | 0.012806124493967693 |
Zambia | 0.012402508481324943 |
Croatia | 0.011076571265230286 |
Macedonia | 0.011009318601816538 |
Mexico | 0.010509556597537481 |
Zimbabwe | 0.010107355104214328 |
Greece | 0.010027019372813766 |
Cuba | 0.00947004188672373 |
Madagascar | 0.009459366509612408 |
Kazakhstan | 0.009334370485609512 |
Swaziland | 0.009300162752848175 |
Syria | 0.008440886565376027 |
Belgium | 0.008256820133430213 |
Australia | 0.007669578121135597 |
Dominican Republic | 0.007243377483443708 |
Belize | 0.00701569762343243 |
United Kingdom | 0.006944157400901087 |
Haiti | 0.006894049346879536 |
Uruguay | 0.006856555152415508 |
Mongolia | 0.006797308883619258 |
Portugal | 0.006778178637804745 |
Philippines | 0.006137438374081899 |
Jordan | 0.006080944122880115 |
Slovenia | 0.006054290109671977 |
Egypt | 0.006027424782761565 |
Cameroon | 0.005775211017325633 |
France | 0.005268360016051791 |
Mauritius | 0.0049261083743842365 |
Thailand | 0.004364931785707295 |
Peru | 0.004078137744180451 |
South Africa | 0.0038041285499024265 |
Malaysia | 0.0036207961491768015 |
Samoa | 0.003544842254519674 |
Iraq | 0.0021720888864500522 |
Honduras | 0.00178746983644651 |
Sierra Leone | 0.0016755096341803965 |
Congo, Republic of the | 0.0014641288433382138 |
Burkina Faso | 0.0014609203798392988 |
Namibia | 0.001217068104799038 |
Cyprus | 0.0010821339681852614 |
Korea, North | 0.0010796624808982792 |
Djibouti | 0.0008628127696289905 |
Costa Rica | 0.0007833920877399138 |
Guinea | 0.0005697611479873187 |
Morocco | 0.000560161326462021 |
Niger | 0.00023683587274019106 |
Bosnia and Herzegovina | 0.0001953621036591322 |
Afghanistan | 0.0 |
Algeria | 0.0 |
Andorra | 0.0 |
Angola | 0.0 |
Antigua and Barbuda | 0.0 |
Bahrain | 0.0 |
Barbados | 0.0 |
Bhutan | 0.0 |
Cabo Verde | 0.0 |
Central African Republic | 0.0 |
Comoros | 0.0 |
Dominica | 0.0 |
Equatorial Guinea | 0.0 |
Fiji | 0.0 |
Georgia | 0.0 |
Grenada | 0.0 |
Kiribati | 0.0 |
Kosovo | 0.0 |
Kuwait | 0.0 |
Lesotho | 0.0 |
Libya | 0.0 |
Liechtenstein | 0.0 |
Luxembourg | 0.0 |
Maldives | 0.0 |
Malta | 0.0 |
Marshall Islands | 0.0 |
Mauritania | 0.0 |
Micronesia, Federated States of | 0.0 |
Monaco | 0.0 |
Nauru | 0.0 |
Oman | 0.0 |
Palau | 0.0 |
Qatar | 0.0 |
Saint Kitts and Nevis | 0.0 |
Saint Vincent and the Grenadines | 0.0 |
San Marino | 0.0 |
Sao Tome and Principe | 0.0 |
Saudi Arabia | 0.0 |
Serbia | 0.0 |
Seychelles | 0.0 |
Timor-Leste | 0.0 |
Trinidad and Tobago | 0.0 |
Tuvalu | 0.0 |
United Arab Emirates | 0.0 |
Vanuatu | 0.0 |
Yemen | 0.0 |
Ashmore and Cartier Islands | 0.0 |
Christmas Island | 0.0 |
Cocos (Keeling) Islands | 0.0 |
Coral Sea Islands | 0.0 |
Heard Island and McDonald Islands | 0.0 |
Norfolk Island | 0.0 |
Macau | 0.0 |
Faroe Islands | 0.0 |
Clipperton Island | 0.0 |
Saint Pierre and Miquelon | 0.0 |
Wallis and Futuna | 0.0 |
Aruba | 0.0 |
Curacao | 0.0 |
Sint Maarten | 0.0 |
Cook Islands | 0.0 |
Niue | 0.0 |
Tokelau | 0.0 |
Bouvet Island | 0.0 |
Jan Mayen | 0.0 |
Svalbard | 0.0 |
Anguilla | 0.0 |
Bermuda | 0.0 |
British Virgin Islands | 0.0 |
Cayman Islands | 0.0 |
Falkland Islands (Islas Malvinas) | 0.0 |
Gibraltar | 0.0 |
Guernsey | 0.0 |
Jersey | 0.0 |
Isle of Man | 0.0 |
Montserrat | 0.0 |
Pitcairn Islands | 0.0 |
Saint Helena, Ascension, and Tristan da Cunha | 0.0 |
South Georgia and South Sandwich Islands | 0.0 |
Turks and Caicos Islands | 0.0 |
American Samoa | 0.0 |
Guam | 0.0 |
Navassa Island | 0.0 |
Northern Mariana Islands | 0.0 |
Wake Island | 0.0 |
Gaza Strip | 0.0 |
Paracel Islands | 0.0 |
Spratly Islands | 0.0 |
Western Sahara | 0.0 |
Ethiopia | None |
New Zealand | None |
South Sudan | None |
Sudan | None |
Holy See (Vatican City) | None |
European Union | None |
Greenland | None |
French Southern and Antarctic Lands | None |
Saint Barthelemy | None |
Saint Martin | None |
Akrotiri | None |
Dhekelia | None |
United States Pacific Island Wildlife Refuges | None |
Antarctica | None |
Arctic Ocean | None |
Atlantic Ocean | None |
Indian Ocean | None |
Pacific Ocean | None |
Southern Ocean | None |
World | None |
%%sql
SELECT name, area_water, area_land
FROM facts
WHERE area_water > area_land;
Done.
name | area_water | area_land |
---|---|---|
British Indian Ocean Territory | 54340 | 60 |
Virgin Islands | 1564 | 346 |
%%sql
SELECT
name, ROUND(population * (population_growth / 100),0) AS 'people_next_year'
FROM facts
WHERE name NOT IN('World')
ORDER BY people_next_year DESC;
Done.
name | people_next_year |
---|---|
India | 15270686.0 |
China | 6153684.0 |
Nigeria | 4448270.0 |
Pakistan | 2906653.0 |
Ethiopia | 2874562.0 |
Bangladesh | 2703324.0 |
United States | 2506677.0 |
Indonesia | 2355142.0 |
Congo, Democratic Republic of the | 1944691.0 |
Philippines | 1626074.0 |
Egypt | 1583924.0 |
Brazil | 1572801.0 |
Mexico | 1436494.0 |
Tanzania | 1424180.0 |
European Union | 1284874.0 |
Uganda | 1202097.0 |
Iraq | 1085746.0 |
Turkey | 1000620.0 |
Iran | 981891.0 |
Vietnam | 915184.0 |
Kenya | 886358.0 |
Afghanistan | 755493.0 |
Algeria | 727576.0 |
South Africa | 713885.0 |
Yemen | 660412.0 |
Sudan | 621072.0 |
Mozambique | 619926.0 |
Cameroon | 614846.0 |
Madagascar | 614367.0 |
Malawi | 596428.0 |
Niger | 586486.0 |
Ghana | 573943.0 |
Burkina Faso | 573630.0 |
Burma | 568834.0 |
Nepal | 564768.0 |
Angola | 545585.0 |
Mali | 505275.0 |
Colombia | 486062.0 |
South Sudan | 484125.0 |
Cote d'Ivoire | 444940.0 |
Malaysia | 439399.0 |
Zambia | 433908.0 |
Spain | 428501.0 |
Venezuela | 406929.0 |
Saudi Arabia | 405184.0 |
Argentina | 403917.0 |
Burundi | 352347.0 |
United Kingdom | 346076.0 |
Senegal | 342408.0 |
Morocco | 333227.0 |
Rwanda | 324140.0 |
Zimbabwe | 314473.0 |
Guinea | 309818.0 |
Peru | 295316.0 |
Benin | 290472.0 |
France | 286181.0 |
Uzbekistan | 271559.0 |
Guatemala | 271526.0 |
Ukraine | 266577.0 |
Canada | 263249.0 |
Cambodia | 248198.0 |
Australia | 243436.0 |
Thailand | 231120.0 |
Chad | 219835.0 |
Ecuador | 214223.0 |
Kazakhstan | 206991.0 |
Togo | 203157.0 |
Japan | 203071.0 |
Somalia | 194280.0 |
Sri Lanka | 185249.0 |
Bolivia | 168494.0 |
Italy | 167009.0 |
United Arab Emirates | 149118.0 |
Honduras | 146944.0 |
Eritrea | 146873.0 |
Chile | 143568.0 |
Libya | 142983.0 |
Tajikistan | 140082.0 |
Sierra Leone | 138159.0 |
Germany | 137452.0 |
Korea, North | 132411.0 |
Dominican Republic | 128889.0 |
Israel | 125569.0 |
Papua New Guinea | 118769.0 |
Haiti | 118287.0 |
Central African Republic | 114840.0 |
Singapore | 107248.0 |
Laos | 107129.0 |
Liberia | 103633.0 |
Tunisia | 98231.0 |
Congo, Republic of the | 95102.0 |
Azerbaijan | 93895.0 |
Belgium | 86062.0 |
Mauritania | 80206.0 |
Paraguay | 78686.0 |
Sweden | 78413.0 |
Netherlands | 69486.0 |
Korea, South | 68761.0 |
Oman | 68040.0 |
Qatar | 67381.0 |
Jordan | 67376.0 |
Romania | 64999.0 |
Kyrgyzstan | 62881.0 |
Ireland | 61154.0 |
Turkmenistan | 59638.0 |
Nicaragua | 59079.0 |
Norway | 58847.0 |
Costa Rica | 58733.0 |
Switzerland | 57665.0 |
Russia | 56970.0 |
West Bank | 54315.0 |
Taiwan | 53855.0 |
Lebanon | 53188.0 |
Gaza Strip | 52520.0 |
Panama | 48273.0 |
Austria | 47661.0 |
Kuwait | 45174.0 |
Gambia, The | 42503.0 |
Bulgaria | 41684.0 |
Mongolia | 39207.0 |
Moldova | 36533.0 |
New Zealand | 36395.0 |
Poland | 34706.0 |
Serbia | 33013.0 |
Guinea-Bissau | 32970.0 |
Gabon | 32913.0 |
Bahrain | 32453.0 |
Lithuania | 29998.0 |
Timor-Leste | 29793.0 |
Syria | 27304.0 |
Hong Kong | 27136.0 |
Botswana | 26411.0 |
Finland | 21908.0 |
Hungary | 21775.0 |
Puerto Rico | 21590.0 |
Latvia | 21059.0 |
Jamaica | 20061.0 |
Belarus | 19179.0 |
Equatorial Guinea | 18593.0 |
Djibouti | 18223.0 |
Czech Republic | 17032.0 |
Cyprus | 17006.0 |
Cuba | 16547.0 |
Western Sahara | 16098.0 |
Swaziland | 15935.0 |
El Salvador | 15353.0 |
Comoros | 13823.0 |
Namibia | 13053.0 |
Solomon Islands | 12574.0 |
Denmark | 12279.0 |
Luxembourg | 12146.0 |
Portugal | 9743.0 |
Albania | 9088.0 |
Uruguay | 9023.0 |
Mauritius | 8575.0 |
Bhutan | 8235.0 |
Cabo Verde | 7426.0 |
Brunei | 6960.0 |
Estonia | 6960.0 |
Belize | 6496.0 |
Suriname | 6260.0 |
Lesotho | 6233.0 |
Fiji | 6093.0 |
Croatia | 5804.0 |
Vanuatu | 5309.0 |
Slovenia | 5157.0 |
Bosnia and Herzegovina | 5027.0 |
Macau | 4742.0 |
Armenia | 4585.0 |
Macedonia | 4192.0 |
Iceland | 4016.0 |
Georgia | 3945.0 |
New Caledonia | 3748.0 |
Sao Tome and Principe | 3570.0 |
Bahamas, The | 2759.0 |
Montenegro | 2718.0 |
French Polynesia | 2657.0 |
Trinidad and Tobago | 1589.0 |
Aruba | 1492.0 |
Malta | 1283.0 |
Kiribati | 1216.0 |
Marshall Islands | 1198.0 |
Cayman Islands | 1178.0 |
Turks and Caicos Islands | 1156.0 |
Samoa | 1147.0 |
Antigua and Barbuda | 1146.0 |
Northern Mariana Islands | 1141.0 |
Slovakia | 1089.0 |
Greece | 1078.0 |
Barbados | 901.0 |
Guam | 874.0 |
Jersey | 778.0 |
British Virgin Islands | 776.0 |
Seychelles | 767.0 |
Isle of Man | 665.0 |
Curacao | 638.0 |
Virgin Islands | 611.0 |
Sint Maarten | 599.0 |
Saint Lucia | 557.0 |
Grenada | 531.0 |
Micronesia, Federated States of | 484.0 |
Saint Kitts and Nevis | 395.0 |
Bermuda | 351.0 |
Anguilla | 333.0 |
Liechtenstein | 316.0 |
Maldives | 315.0 |
Cook Islands | 290.0 |
Saint Vincent and the Grenadines | 287.0 |
San Marino | 271.0 |
Faroe Islands | 256.0 |
Guernsey | 225.0 |
American Samoa | 163.0 |
Dominica | 155.0 |
Guyana | 147.0 |
Andorra | 103.0 |
Tuvalu | 89.0 |
Palau | 81.0 |
Gibraltar | 70.0 |
Saint Pierre and Miquelon | 61.0 |
Nauru | 52.0 |
Wallis and Futuna | 52.0 |
Monaco | 37.0 |
Tonga | 32.0 |
Montserrat | 26.0 |
Saint Helena, Ascension, and Tristan da Cunha | 19.0 |
Christmas Island | 17.0 |
Svalbard | 1.0 |
Holy See (Vatican City) | 0.0 |
Cocos (Keeling) Islands | 0.0 |
Norfolk Island | 0.0 |
Greenland | 0.0 |
Niue | 0.0 |
Tokelau | 0.0 |
Falkland Islands (Islas Malvinas) | 0.0 |
Pitcairn Islands | 0.0 |
Kosovo | None |
Ashmore and Cartier Islands | None |
Coral Sea Islands | None |
Heard Island and McDonald Islands | None |
Clipperton Island | None |
French Southern and Antarctic Lands | None |
Saint Barthelemy | None |
Saint Martin | None |
Bouvet Island | None |
Jan Mayen | None |
Akrotiri | None |
British Indian Ocean Territory | None |
Dhekelia | None |
South Georgia and South Sandwich Islands | None |
Navassa Island | None |
Wake Island | None |
United States Pacific Island Wildlife Refuges | None |
Antarctica | None |
Paracel Islands | None |
Spratly Islands | None |
Arctic Ocean | None |
Atlantic Ocean | None |
Indian Ocean | None |
Pacific Ocean | None |
Southern Ocean | None |
%%sql
SELECT
name, death_rate, birth_rate
FROM facts
WHERE death_rate > birth_rate;
Done.
name | death_rate | birth_rate |
---|---|---|
Austria | 9.42 | 9.41 |
Belarus | 13.36 | 10.7 |
Bosnia and Herzegovina | 9.75 | 8.87 |
Bulgaria | 14.44 | 8.92 |
Croatia | 12.18 | 9.45 |
Czech Republic | 10.34 | 9.63 |
Estonia | 12.4 | 10.51 |
Germany | 11.42 | 8.47 |
Greece | 11.09 | 8.66 |
Hungary | 12.73 | 9.16 |
Italy | 10.19 | 8.74 |
Japan | 9.51 | 7.93 |
Latvia | 14.31 | 10.0 |
Lithuania | 14.27 | 10.1 |
Moldova | 12.59 | 12.0 |
Monaco | 9.24 | 6.65 |
Poland | 10.19 | 9.74 |
Portugal | 11.02 | 9.27 |
Romania | 11.9 | 9.14 |
Russia | 13.69 | 11.6 |
Serbia | 13.66 | 9.08 |
Slovenia | 11.37 | 8.42 |
Ukraine | 14.46 | 10.72 |
Saint Pierre and Miquelon | 9.72 | 7.42 |
%%sql
SELECT
name, ROUND(CAST(population AS Float) / CAST(area AS Float),2) AS 'population_area_ratio'
FROM facts
ORDER BY population_area_ratio DESC;
Done.
name | population_area_ratio |
---|---|
Macau | 21168.96 |
Monaco | 15267.5 |
Singapore | 8141.28 |
Hong Kong | 6445.04 |
Gaza Strip | 5191.82 |
Gibraltar | 4876.33 |
Bahrain | 1771.86 |
Maldives | 1319.64 |
Malta | 1310.02 |
Bermuda | 1299.93 |
Sint Maarten | 1167.32 |
Bangladesh | 1138.07 |
Guernsey | 847.18 |
Jersey | 838.74 |
Barbados | 675.82 |
Mauritius | 656.78 |
Taiwan | 650.78 |
Aruba | 623.12 |
Lebanon | 594.68 |
Saint Martin | 588.04 |
San Marino | 541.31 |
Korea, South | 492.53 |
Rwanda | 480.74 |
West Bank | 475.32 |
Nauru | 454.29 |
Tuvalu | 418.04 |
Netherlands | 407.96 |
Marshall Islands | 398.85 |
Israel | 387.55 |
Burundi | 386.0 |
India | 380.77 |
Belgium | 370.94 |
Haiti | 364.33 |
Comoros | 349.43 |
Philippines | 336.66 |
Sri Lanka | 336.13 |
Japan | 335.84 |
Curacao | 334.25 |
Grenada | 321.78 |
Guam | 297.4 |
El Salvador | 291.88 |
Vietnam | 284.86 |
American Samoa | 273.08 |
Jamaica | 268.42 |
Saint Lucia | 266.11 |
Saint Vincent and the Grenadines | 263.82 |
United Kingdom | 263.08 |
Puerto Rico | 260.92 |
Pakistan | 250.08 |
Trinidad and Tobago | 238.37 |
Liechtenstein | 235.15 |
Germany | 226.47 |
British Virgin Islands | 221.55 |
Luxembourg | 220.52 |
Dominican Republic | 215.3 |
Nepal | 214.37 |
Cayman Islands | 212.47 |
Antigua and Barbuda | 209.13 |
Korea, North | 207.26 |
Italy | 205.27 |
Seychelles | 203.14 |
Sao Tome and Principe | 201.25 |
Saint Kitts and Nevis | 198.99 |
Switzerland | 196.76 |
Nigeria | 196.55 |
Qatar | 189.44 |
Andorra | 182.86 |
Anguilla | 180.42 |
Gambia, The | 174.13 |
Kosovo | 171.85 |
Kuwait | 156.5 |
Uganda | 153.92 |
Isle of Man | 153.05 |
Malawi | 151.62 |
Micronesia, Federated States of | 149.88 |
Tonga | 142.57 |
China | 142.49 |
Guatemala | 137.01 |
Cabo Verde | 135.38 |
Czech Republic | 134.97 |
Indonesia | 134.41 |
Togo | 133.0 |
Thailand | 132.48 |
Kiribati | 130.35 |
Denmark | 129.52 |
Cyprus | 128.55 |
Akrotiri | 127.64 |
Poland | 123.33 |
Dhekelia | 120.77 |
European Union | 118.84 |
Portugal | 117.55 |
Azerbaijan | 112.94 |
Northern Mariana Islands | 112.81 |
Tokelau | 111.42 |
Slovakia | 111.04 |
Ghana | 110.37 |
Wallis and Futuna | 109.95 |
Hungary | 106.39 |
Albania | 105.37 |
Moldova | 104.78 |
France | 103.38 |
Austria | 103.32 |
Armenia | 102.76 |
Turkey | 101.35 |
Cuba | 99.51 |
Dominica | 98.01 |
Slovenia | 97.84 |
Spain | 95.27 |
Costa Rica | 94.21 |
Benin | 92.78 |
Serbia | 92.63 |
Malaysia | 92.51 |
Syria | 92.15 |
Romania | 90.89 |
Jordan | 90.86 |
Ethiopia | 90.07 |
Egypt | 88.36 |
Cambodia | 86.77 |
Iraq | 84.54 |
Burma | 83.24 |
Timor-Leste | 82.77 |
Swaziland | 82.68 |
Sierra Leone | 81.95 |
Greece | 81.66 |
Macedonia | 81.52 |
Kenya | 79.13 |
Croatia | 78.89 |
Honduras | 78.03 |
Bosnia and Herzegovina | 75.53 |
Morocco | 74.62 |
Brunei | 74.53 |
Ukraine | 73.61 |
Cote d'Ivoire | 72.24 |
Senegal | 71.04 |
Georgia | 70.75 |
Samoa | 69.86 |
Ireland | 69.62 |
United Arab Emirates | 69.14 |
Burkina Faso | 69.04 |
French Polynesia | 67.84 |
Tunisia | 67.46 |
Uzbekistan | 65.27 |
Bulgaria | 64.82 |
Lesotho | 64.16 |
Mexico | 61.97 |
Norfolk Island | 61.39 |
Tajikistan | 56.85 |
Ecuador | 55.96 |
Eritrea | 55.51 |
Virgin Islands | 54.23 |
Tanzania | 53.89 |
Turks and Caicos Islands | 53.04 |
Montserrat | 51.38 |
Yemen | 50.64 |
Afghanistan | 49.93 |
Cameroon | 49.93 |
Fiji | 49.76 |
Iran | 49.64 |
Panama | 48.49 |
Guinea | 47.91 |
Guinea-Bissau | 47.78 |
Montenegro | 46.85 |
Palau | 46.33 |
Belarus | 46.19 |
Nicaragua | 45.32 |
Lithuania | 44.17 |
South Africa | 44.03 |
Cocos (Keeling) Islands | 42.57 |
Cook Islands | 41.69 |
Colombia | 41.04 |
Madagascar | 40.56 |
Liberia | 37.67 |
Zimbabwe | 36.42 |
Faroe Islands | 36.03 |
Djibouti | 35.7 |
Congo, Democratic Republic of the | 33.85 |
United States | 32.7 |
Venezuela | 32.1 |
Mozambique | 31.65 |
Latvia | 30.76 |
Laos | 29.19 |
Kyrgyzstan | 28.33 |
Estonia | 27.98 |
Equatorial Guinea | 26.41 |
Saint Helena, Ascension, and Tristan da Cunha | 25.31 |
Brazil | 23.99 |
Peru | 23.69 |
Bahamas, The | 23.39 |
Saint Pierre and Miquelon | 23.38 |
Chile | 23.16 |
Vanuatu | 22.34 |
Sweden | 21.77 |
Solomon Islands | 21.54 |
Zambia | 20.02 |
Sudan | 19.4 |
Bhutan | 19.32 |
Uruguay | 18.96 |
South Sudan | 18.69 |
Paraguay | 16.68 |
Somalia | 16.65 |
Algeria | 16.6 |
New Zealand | 16.58 |
Finland | 16.2 |
Norway | 16.08 |
Angola | 15.74 |
Argentina | 15.62 |
Belize | 15.13 |
New Caledonia | 14.62 |
Papua New Guinea | 14.42 |
Congo, Republic of the | 13.9 |
Mali | 13.67 |
Saudi Arabia | 12.91 |
Christmas Island | 11.33 |
Turkmenistan | 10.72 |
Oman | 10.62 |
Bolivia | 9.83 |
Central African Republic | 8.65 |
Russia | 8.33 |
Kazakhstan | 6.66 |
Gabon | 6.37 |
Niue | 4.58 |
Botswana | 3.75 |
Libya | 3.64 |
Suriname | 3.54 |
Canada | 3.52 |
Mauritania | 3.49 |
Guyana | 3.42 |
Iceland | 3.22 |
Australia | 2.94 |
Namibia | 2.68 |
Western Sahara | 2.15 |
Mongolia | 1.91 |
Pitcairn Islands | 1.02 |
Falkland Islands (Islas Malvinas) | 0.28 |
Greenland | 0.03 |
Svalbard | 0.03 |
Chad | None |
Niger | None |
Holy See (Vatican City) | None |
Ashmore and Cartier Islands | None |
Coral Sea Islands | None |
Heard Island and McDonald Islands | None |
Clipperton Island | None |
French Southern and Antarctic Lands | None |
Saint Barthelemy | None |
Bouvet Island | None |
Jan Mayen | None |
British Indian Ocean Territory | None |
South Georgia and South Sandwich Islands | None |
Navassa Island | None |
Wake Island | None |
United States Pacific Island Wildlife Refuges | None |
Antarctica | None |
Paracel Islands | None |
Spratly Islands | None |
Arctic Ocean | None |
Atlantic Ocean | None |
Indian Ocean | None |
Pacific Ocean | None |
Southern Ocean | None |
World | None |