1. Comandos Básicos

Introducción

Este taller está diseñado para que los estudiantes desarrollen sus habilidades en la realización de consultas SQL sobre la base de datos «world database», un conjunto de datos realista y ampliamente utilizado para aprender sobre bases de datos relacionales. En este taller, el estudiante aprenderá a realizar consultas básicas y de nivel medio empleando operadores SQL y notación de álgebra relacional para construir y entender mejor las consultas, fortaleciendo el conocimiento de comandos como HAVING, GROUP BY, AVERAGE, COUNT, ORDER BY, LIKE, DISTINCT, BETWEEN, MAX, MIN, y AS, entre otros.

Las consultas se dividen en dos niveles de dificultad: básico, que introduce a los conceptos fundamentales de las consultas SQL, y medio, que desafía a los estudiantes a utilizar operadores de agrupamiento, proyecciones, y condiciones más complejas para extraer y manipular datos. El objetivo es que el estudiante aprenda a traducir problemas de consulta de álgebra relacional a SQL de manera fluida y comprenda cómo aplicar los operadores más importantes de SQL para la manipulación y el análisis de datos en bases de datos relacionales.

Importante

Para este taller utilizaremos la base de datos World que ya tienen desde la instalación o pueden descargar desde Other MySQL Documentation.

Base de Datos (world)

SHOW Tables;

	Tables_in_world
0	city
1	country
2	countrylanguage

Tablas

Country

SELECT * FROM country;

	Code	Name	Continent	Region	SurfaceArea	IndepYear	Population	LifeExpectancy	GNP	GNPOld	LocalName	GovernmentForm	HeadOfState	Capital	Code2
0	ABW	Aruba	North America	Caribbean	193.0	NaN	103000	78.4	828.0	793.0	Aruba	Nonmetropolitan Territory of The Netherlands	Beatrix	129.0	AW
1	AFG	Afghanistan	Asia	Southern and Central Asia	652090.0	1919.0	22720000	45.9	5976.0	NaN	Afganistan/Afqanestan	Islamic Emirate	Mohammad Omar	1.0	AF
2	AGO	Angola	Africa	Central Africa	1246700.0	1975.0	12878000	38.3	6648.0	7984.0	Angola	Republic	José Eduardo dos Santos	56.0	AO
3	AIA	Anguilla	North America	Caribbean	96.0	NaN	8000	76.1	63.2	NaN	Anguilla	Dependent Territory of the UK	Elisabeth II	62.0	AI
4	ALB	Albania	Europe	Southern Europe	28748.0	1912.0	3401200	71.6	3205.0	2500.0	Shqipëria	Republic	Rexhep Mejdani	34.0	AL
5	AND	Andorra	Europe	Southern Europe	468.0	1278.0	78000	83.5	1630.0	NaN	Andorra	Parliamentary Coprincipality		55.0	AD
6	ANT	Netherlands Antilles	North America	Caribbean	800.0	NaN	217000	74.7	1941.0	NaN	Nederlandse Antillen	Nonmetropolitan Territory of The Netherlands	Beatrix	33.0	AN
7	ARE	United Arab Emirates	Asia	Middle East	83600.0	1971.0	2441000	74.1	37966.0	36846.0	Al-Imarat al-´Arabiya al-Muttahida	Emirate Federation	Zayid bin Sultan al-Nahayan	65.0	AE
8	ARG	Argentina	South America	South America	2780400.0	1816.0	37032000	75.1	340238.0	323310.0	Argentina	Federal Republic	Fernando de la Rúa	69.0	AR
9	ARM	Armenia	Asia	Middle East	29800.0	1991.0	3520000	66.4	1813.0	1627.0	Hajastan	Republic	Robert Kotšarjan	126.0	AM
10	ASM	American Samoa	Oceania	Polynesia	199.0	NaN	68000	75.1	334.0	NaN	Amerika Samoa	US Territory	George W. Bush	54.0	AS
11	ATA	Antarctica	Antarctica	Antarctica	13120000.0	NaN	0	NaN	0.0	NaN	–	Co-administrated		NaN	AQ
12	ATF	French Southern territories	Antarctica	Antarctica	7780.0	NaN	0	NaN	0.0	NaN	Terres australes françaises	Nonmetropolitan Territory of France	Jacques Chirac	NaN	TF
13	ATG	Antigua and Barbuda	North America	Caribbean	442.0	1981.0	68000	70.5	612.0	584.0	Antigua and Barbuda	Constitutional Monarchy	Elisabeth II	63.0	AG
14	AUS	Australia	Oceania	Australia and New Zealand	7741220.0	1901.0	18886000	79.8	351182.0	392911.0	Australia	Constitutional Monarchy, Federation	Elisabeth II	135.0	AU
15	AUT	Austria	Europe	Western Europe	83859.0	1918.0	8091800	77.7	211860.0	206025.0	Österreich	Federal Republic	Thomas Klestil	1523.0	AT
16	AZE	Azerbaijan	Asia	Middle East	86600.0	1991.0	7734000	62.9	4127.0	4100.0	Azərbaycan	Republic	İlham Əliyev	144.0	AZ
17	BDI	Burundi	Africa	Eastern Africa	27834.0	1962.0	6695000	46.2	903.0	982.0	Burundi/Uburundi	Republic	Pierre Buyoya	552.0	BI
18	BEL	Belgium	Europe	Western Europe	30518.0	1830.0	10239000	77.8	249704.0	243948.0	België/Belgique	Constitutional Monarchy, Federation	Albert II	179.0	BE
19	BEN	Benin	Africa	Western Africa	112622.0	1960.0	6097000	50.2	2357.0	2141.0	Bénin	Republic	Mathieu Kérékou	187.0	BJ
20	BFA	Burkina Faso	Africa	Western Africa	274000.0	1960.0	11937000	46.7	2425.0	2201.0	Burkina Faso	Republic	Blaise Compaoré	549.0	BF
21	BGD	Bangladesh	Asia	Southern and Central Asia	143998.0	1971.0	129155000	60.2	32852.0	31966.0	Bangladesh	Republic	Shahabuddin Ahmad	150.0	BD
22	BGR	Bulgaria	Europe	Eastern Europe	110994.0	1908.0	8190900	70.9	12178.0	10169.0	Balgarija	Republic	Petar Stojanov	539.0	BG
23	BHR	Bahrain	Asia	Middle East	694.0	1971.0	617000	73.0	6366.0	6097.0	Al-Bahrayn	Monarchy (Emirate)	Hamad ibn Isa al-Khalifa	149.0	BH
24	BHS	Bahamas	North America	Caribbean	13878.0	1973.0	307000	71.1	3527.0	3347.0	The Bahamas	Constitutional Monarchy	Elisabeth II	148.0	BS
25	BIH	Bosnia and Herzegovina	Europe	Southern Europe	51197.0	1992.0	3972000	71.5	2841.0	NaN	Bosna i Hercegovina	Federal Republic	Ante Jelavic	201.0	BA
26	BLR	Belarus	Europe	Eastern Europe	207600.0	1991.0	10236000	68.0	13714.0	NaN	Belarus	Republic	Aljaksandr Lukašenka	3520.0	BY
27	BLZ	Belize	North America	Central America	22696.0	1981.0	241000	70.9	630.0	616.0	Belize	Constitutional Monarchy	Elisabeth II	185.0	BZ
28	BMU	Bermuda	North America	North America	53.0	NaN	65000	76.9	2328.0	2190.0	Bermuda	Dependent Territory of the UK	Elisabeth II	191.0	BM
29	BOL	Bolivia	South America	South America	1098581.0	1825.0	8329000	63.7	8571.0	7967.0	Bolivia	Republic	Hugo Bánzer Suárez	194.0	BO
30	BRA	Brazil	South America	South America	8547403.0	1822.0	170115000	62.9	776739.0	804108.0	Brasil	Federal Republic	Fernando Henrique Cardoso	211.0	BR
31	BRB	Barbados	North America	Caribbean	430.0	1966.0	270000	73.0	2223.0	2186.0	Barbados	Constitutional Monarchy	Elisabeth II	174.0	BB
32	BRN	Brunei	Asia	Southeast Asia	5765.0	1984.0	328000	73.6	11705.0	12460.0	Brunei Darussalam	Monarchy (Sultanate)	Haji Hassan al-Bolkiah	538.0	BN
33	BTN	Bhutan	Asia	Southern and Central Asia	47000.0	1910.0	2124000	52.4	372.0	383.0	Druk-Yul	Monarchy	Jigme Singye Wangchuk	192.0	BT
34	BVT	Bouvet Island	Antarctica	Antarctica	59.0	NaN	0	NaN	0.0	NaN	Bouvetøya	Dependent Territory of Norway	Harald V	NaN	BV
35	BWA	Botswana	Africa	Southern Africa	581730.0	1966.0	1622000	39.3	4834.0	4935.0	Botswana	Republic	Festus G. Mogae	204.0	BW
36	CAF	Central African Republic	Africa	Central Africa	622984.0	1960.0	3615000	44.0	1054.0	993.0	Centrafrique/Bê-Afrîka	Republic	Ange-Félix Patassé	1889.0	CF
37	CAN	Canada	North America	North America	9970610.0	1867.0	31147000	79.4	598862.0	625626.0	Canada	Constitutional Monarchy, Federation	Elisabeth II	1822.0	CA
38	CCK	Cocos (Keeling) Islands	Oceania	Australia and New Zealand	14.0	NaN	600	NaN	0.0	NaN	Cocos (Keeling) Islands	Territory of Australia	Elisabeth II	2317.0	CC
39	CHE	Switzerland	Europe	Western Europe	41284.0	1499.0	7160400	79.6	264478.0	256092.0	Schweiz/Suisse/Svizzera/Svizra	Federation	Adolf Ogi	3248.0	CH
40	CHL	Chile	South America	South America	756626.0	1810.0	15211000	75.7	72949.0	75780.0	Chile	Republic	Ricardo Lagos Escobar	554.0	CL
41	CHN	China	Asia	Eastern Asia	9572900.0	-1523.0	1277558000	71.4	982268.0	917719.0	Zhongquo	People'sRepublic	Jiang Zemin	1891.0	CN
42	CIV	Côte d’Ivoire	Africa	Western Africa	322463.0	1960.0	14786000	45.2	11345.0	10285.0	Côte d’Ivoire	Republic	Laurent Gbagbo	2814.0	CI
43	CMR	Cameroon	Africa	Central Africa	475442.0	1960.0	15085000	54.8	9174.0	8596.0	Cameroun/Cameroon	Republic	Paul Biya	1804.0	CM
44	COD	Congo, The Democratic Republic of the	Africa	Central Africa	2344858.0	1960.0	51654000	48.8	6964.0	2474.0	République Démocratique du Congo	Republic	Joseph Kabila	2298.0	CD
45	COG	Congo	Africa	Central Africa	342000.0	1960.0	2943000	47.4	2108.0	2287.0	Congo	Republic	Denis Sassou-Nguesso	2296.0	CG
46	COK	Cook Islands	Oceania	Polynesia	236.0	NaN	20000	71.1	100.0	NaN	The Cook Islands	Nonmetropolitan Territory of New Zealand	Elisabeth II	583.0	CK
47	COL	Colombia	South America	South America	1138914.0	1810.0	42321000	70.3	102896.0	105116.0	Colombia	Republic	Andrés Pastrana Arango	2257.0	CO
48	COM	Comoros	Africa	Eastern Africa	1862.0	1975.0	578000	60.0	4401.0	4361.0	Komori/Comores	Republic	Azali Assoumani	2295.0	KM
49	CPV	Cape Verde	Africa	Western Africa	4033.0	1975.0	428000	68.9	435.0	420.0	Cabo Verde	Republic	António Mascarenhas Monteiro	1859.0	CV
50	CRI	Costa Rica	North America	Central America	51100.0	1821.0	4023000	75.8	10226.0	9757.0	Costa Rica	Republic	Miguel Ángel Rodríguez Echeverría	584.0	CR
51	CUB	Cuba	North America	Caribbean	110861.0	1902.0	11201000	76.2	17843.0	18862.0	Cuba	Socialistic Republic	Fidel Castro Ruz	2413.0	CU
52	CXR	Christmas Island	Oceania	Australia and New Zealand	135.0	NaN	2500	NaN	0.0	NaN	Christmas Island	Territory of Australia	Elisabeth II	1791.0	CX
53	CYM	Cayman Islands	North America	Caribbean	264.0	NaN	38000	78.9	1263.0	1186.0	Cayman Islands	Dependent Territory of the UK	Elisabeth II	553.0	KY
54	CYP	Cyprus	Asia	Middle East	9251.0	1960.0	754700	76.7	9333.0	8246.0	Kýpros/Kibris	Republic	Glafkos Klerides	2430.0	CY
55	CZE	Czech Republic	Europe	Eastern Europe	78866.0	1993.0	10278100	74.5	55017.0	52037.0	¸esko	Republic	Václav Havel	3339.0	CZ
56	DEU	Germany	Europe	Western Europe	357022.0	1955.0	82164700	77.4	2133367.0	2102826.0	Deutschland	Federal Republic	Johannes Rau	3068.0	DE
57	DJI	Djibouti	Africa	Eastern Africa	23200.0	1977.0	638000	50.8	382.0	373.0	Djibouti/Jibuti	Republic	Ismail Omar Guelleh	585.0	DJ
58	DMA	Dominica	North America	Caribbean	751.0	1978.0	71000	73.4	256.0	243.0	Dominica	Republic	Vernon Shaw	586.0	DM
59	DNK	Denmark	Europe	Nordic Countries	43094.0	800.0	5330000	76.5	174099.0	169264.0	Danmark	Constitutional Monarchy	Margrethe II	3315.0	DK
60	DOM	Dominican Republic	North America	Caribbean	48511.0	1844.0	8495000	73.2	15846.0	15076.0	República Dominicana	Republic	Hipólito Mejía Domínguez	587.0	DO
61	DZA	Algeria	Africa	Northern Africa	2381741.0	1962.0	31471000	69.7	49982.0	46966.0	Al-Jaza’ir/Algérie	Republic	Abdelaziz Bouteflika	35.0	DZ
62	ECU	Ecuador	South America	South America	283561.0	1822.0	12646000	71.1	19770.0	19769.0	Ecuador	Republic	Gustavo Noboa Bejarano	594.0	EC
63	EGY	Egypt	Africa	Northern Africa	1001449.0	1922.0	68470000	63.3	82710.0	75617.0	Misr	Republic	Hosni Mubarak	608.0	EG
64	ERI	Eritrea	Africa	Eastern Africa	117600.0	1993.0	3850000	55.8	650.0	755.0	Ertra	Republic	Isayas Afewerki [Isaias Afwerki]	652.0	ER
65	ESH	Western Sahara	Africa	Northern Africa	266000.0	NaN	293000	49.8	60.0	NaN	As-Sahrawiya	Occupied by Marocco	Mohammed Abdel Aziz	2453.0	EH
66	ESP	Spain	Europe	Southern Europe	505992.0	1492.0	39441700	78.8	553233.0	532031.0	España	Constitutional Monarchy	Juan Carlos I	653.0	ES
67	EST	Estonia	Europe	Baltic Countries	45227.0	1991.0	1439200	69.5	5328.0	3371.0	Eesti	Republic	Lennart Meri	3791.0	EE
68	ETH	Ethiopia	Africa	Eastern Africa	1104300.0	-1000.0	62565000	45.2	6353.0	6180.0	YeItyop´iya	Republic	Negasso Gidada	756.0	ET
69	FIN	Finland	Europe	Nordic Countries	338145.0	1917.0	5171300	77.4	121914.0	119833.0	Suomi	Republic	Tarja Halonen	3236.0	FI
70	FJI	Fiji Islands	Oceania	Melanesia	18274.0	1970.0	817000	67.9	1536.0	2149.0	Fiji Islands	Republic	Josefa Iloilo	764.0	FJ
71	FLK	Falkland Islands	South America	South America	12173.0	NaN	2000	NaN	0.0	NaN	Falkland Islands	Dependent Territory of the UK	Elisabeth II	763.0	FK
72	FRA	France	Europe	Western Europe	551500.0	843.0	59225700	78.8	1424285.0	1392448.0	France	Republic	Jacques Chirac	2974.0	FR
73	FRO	Faroe Islands	Europe	Nordic Countries	1399.0	NaN	43000	78.4	0.0	NaN	Føroyar	Part of Denmark	Margrethe II	901.0	FO
74	FSM	Micronesia, Federated States of	Oceania	Micronesia	702.0	1990.0	119000	68.6	212.0	NaN	Micronesia	Federal Republic	Leo A. Falcam	2689.0	FM
75	GAB	Gabon	Africa	Central Africa	267668.0	1960.0	1226000	50.1	5493.0	5279.0	Le Gabon	Republic	Omar Bongo	902.0	GA
76	GBR	United Kingdom	Europe	British Islands	242900.0	1066.0	59623400	77.7	1378330.0	1296830.0	United Kingdom	Constitutional Monarchy	Elisabeth II	456.0	GB
77	GEO	Georgia	Asia	Middle East	69700.0	1991.0	4968000	64.5	6064.0	5924.0	Sakartvelo	Republic	Eduard Ševardnadze	905.0	GE
78	GHA	Ghana	Africa	Western Africa	238533.0	1957.0	20212000	57.4	7137.0	6884.0	Ghana	Republic	John Kufuor	910.0	GH
79	GIB	Gibraltar	Europe	Southern Europe	6.0	NaN	25000	79.0	258.0	NaN	Gibraltar	Dependent Territory of the UK	Elisabeth II	915.0	GI
80	GIN	Guinea	Africa	Western Africa	245857.0	1958.0	7430000	45.6	2352.0	2383.0	Guinée	Republic	Lansana Conté	926.0	GN
81	GLP	Guadeloupe	North America	Caribbean	1705.0	NaN	456000	77.0	3501.0	NaN	Guadeloupe	Overseas Department of France	Jacques Chirac	919.0	GP
82	GMB	Gambia	Africa	Western Africa	11295.0	1965.0	1305000	53.2	320.0	325.0	The Gambia	Republic	Yahya Jammeh	904.0	GM
83	GNB	Guinea-Bissau	Africa	Western Africa	36125.0	1974.0	1213000	49.0	293.0	272.0	Guiné-Bissau	Republic	Kumba Ialá	927.0	GW
84	GNQ	Equatorial Guinea	Africa	Central Africa	28051.0	1968.0	453000	53.6	283.0	542.0	Guinea Ecuatorial	Republic	Teodoro Obiang Nguema Mbasogo	2972.0	GQ
85	GRC	Greece	Europe	Southern Europe	131626.0	1830.0	10545700	78.4	120724.0	119946.0	Elláda	Republic	Kostis Stefanopoulos	2401.0	GR
86	GRD	Grenada	North America	Caribbean	344.0	1974.0	94000	64.5	318.0	NaN	Grenada	Constitutional Monarchy	Elisabeth II	916.0	GD
87	GRL	Greenland	North America	North America	2166090.0	NaN	56000	68.1	0.0	NaN	Kalaallit Nunaat/Grønland	Part of Denmark	Margrethe II	917.0	GL
88	GTM	Guatemala	North America	Central America	108889.0	1821.0	11385000	66.2	19008.0	17797.0	Guatemala	Republic	Alfonso Portillo Cabrera	922.0	GT
89	GUF	French Guiana	South America	South America	90000.0	NaN	181000	76.1	681.0	NaN	Guyane française	Overseas Department of France	Jacques Chirac	3014.0	GF
90	GUM	Guam	Oceania	Micronesia	549.0	NaN	168000	77.8	1197.0	1136.0	Guam	US Territory	George W. Bush	921.0	GU
91	GUY	Guyana	South America	South America	214969.0	1966.0	861000	64.0	722.0	743.0	Guyana	Republic	Bharrat Jagdeo	928.0	GY
92	HKG	Hong Kong	Asia	Eastern Asia	1075.0	NaN	6782000	79.5	166448.0	173610.0	Xianggang/Hong Kong	Special Administrative Region of China	Jiang Zemin	937.0	HK
93	HMD	Heard Island and McDonald Islands	Antarctica	Antarctica	359.0	NaN	0	NaN	0.0	NaN	Heard and McDonald Islands	Territory of Australia	Elisabeth II	NaN	HM
94	HND	Honduras	North America	Central America	112088.0	1838.0	6485000	69.9	5333.0	4697.0	Honduras	Republic	Carlos Roberto Flores Facussé	933.0	HN
95	HRV	Croatia	Europe	Southern Europe	56538.0	1991.0	4473000	73.7	20208.0	19300.0	Hrvatska	Republic	Štipe Mesic	2409.0	HR
96	HTI	Haiti	North America	Caribbean	27750.0	1804.0	8222000	49.2	3459.0	3107.0	Haïti/Dayti	Republic	Jean-Bertrand Aristide	929.0	HT
97	HUN	Hungary	Europe	Eastern Europe	93030.0	1918.0	10043200	71.4	48267.0	45914.0	Magyarország	Republic	Ferenc Mádl	3483.0	HU
98	IDN	Indonesia	Asia	Southeast Asia	1904569.0	1945.0	212107000	68.0	84982.0	215002.0	Indonesia	Republic	Abdurrahman Wahid	939.0	ID
99	IND	India	Asia	Southern and Central Asia	3287263.0	1947.0	1013662000	62.5	447114.0	430572.0	Bharat/India	Federal Republic	Kocheril Raman Narayanan	1109.0	IN
100	IOT	British Indian Ocean Territory	Africa	Eastern Africa	78.0	NaN	0	NaN	0.0	NaN	British Indian Ocean Territory	Dependent Territory of the UK	Elisabeth II	NaN	IO
101	IRL	Ireland	Europe	British Islands	70273.0	1921.0	3775100	76.8	75921.0	73132.0	Ireland/Éire	Republic	Mary McAleese	1447.0	IE
102	IRN	Iran	Asia	Southern and Central Asia	1648195.0	1906.0	67702000	69.7	195746.0	160151.0	Iran	Islamic Republic	Ali Mohammad Khatami-Ardakani	1380.0	IR
103	IRQ	Iraq	Asia	Middle East	438317.0	1932.0	23115000	66.5	11500.0	NaN	Al-´Iraq	Republic	Saddam Hussein al-Takriti	1365.0	IQ
104	ISL	Iceland	Europe	Nordic Countries	103000.0	1944.0	279000	79.4	8255.0	7474.0	Ísland	Republic	Ólafur Ragnar Grímsson	1449.0	IS
105	ISR	Israel	Asia	Middle East	21056.0	1948.0	6217000	78.6	97477.0	98577.0	Yisra’el/Isra’il	Republic	Moshe Katzav	1450.0	IL
106	ITA	Italy	Europe	Southern Europe	301316.0	1861.0	57680000	79.0	1161755.0	1145372.0	Italia	Republic	Carlo Azeglio Ciampi	1464.0	IT
107	JAM	Jamaica	North America	Caribbean	10990.0	1962.0	2583000	75.2	6871.0	6722.0	Jamaica	Constitutional Monarchy	Elisabeth II	1530.0	JM
108	JOR	Jordan	Asia	Middle East	88946.0	1946.0	5083000	77.4	7526.0	7051.0	Al-Urdunn	Constitutional Monarchy	Abdullah II	1786.0	JO
109	JPN	Japan	Asia	Eastern Asia	377829.0	-660.0	126714000	80.7	3787042.0	4192638.0	Nihon/Nippon	Constitutional Monarchy	Akihito	1532.0	JP
110	KAZ	Kazakstan	Asia	Southern and Central Asia	2724900.0	1991.0	16223000	63.2	24375.0	23383.0	Qazaqstan	Republic	Nursultan Nazarbajev	1864.0	KZ
111	KEN	Kenya	Africa	Eastern Africa	580367.0	1963.0	30080000	48.0	9217.0	10241.0	Kenya	Republic	Daniel arap Moi	1881.0	KE
112	KGZ	Kyrgyzstan	Asia	Southern and Central Asia	199900.0	1991.0	4699000	63.4	1626.0	1767.0	Kyrgyzstan	Republic	Askar Akajev	2253.0	KG
113	KHM	Cambodia	Asia	Southeast Asia	181035.0	1953.0	11168000	56.5	5121.0	5670.0	Kâmpuchéa	Constitutional Monarchy	Norodom Sihanouk	1800.0	KH
114	KIR	Kiribati	Oceania	Micronesia	726.0	1979.0	83000	59.8	40.7	NaN	Kiribati	Republic	Teburoro Tito	2256.0	KI
115	KNA	Saint Kitts and Nevis	North America	Caribbean	261.0	1983.0	38000	70.7	299.0	NaN	Saint Kitts and Nevis	Constitutional Monarchy	Elisabeth II	3064.0	KN
116	KOR	South Korea	Asia	Eastern Asia	99434.0	1948.0	46844000	74.4	320749.0	442544.0	Taehan Min’guk (Namhan)	Republic	Kim Dae-jung	2331.0	KR
117	KWT	Kuwait	Asia	Middle East	17818.0	1961.0	1972000	76.1	27037.0	30373.0	Al-Kuwayt	Constitutional Monarchy (Emirate)	Jabir al-Ahmad al-Jabir al-Sabah	2429.0	KW
118	LAO	Laos	Asia	Southeast Asia	236800.0	1953.0	5433000	53.1	1292.0	1746.0	Lao	Republic	Khamtay Siphandone	2432.0	LA
119	LBN	Lebanon	Asia	Middle East	10400.0	1941.0	3282000	71.3	17121.0	15129.0	Lubnan	Republic	Émile Lahoud	2438.0	LB
120	LBR	Liberia	Africa	Western Africa	111369.0	1847.0	3154000	51.0	2012.0	NaN	Liberia	Republic	Charles Taylor	2440.0	LR
121	LBY	Libyan Arab Jamahiriya	Africa	Northern Africa	1759540.0	1951.0	5605000	75.5	44806.0	40562.0	Libiya	Socialistic State	Muammar al-Qadhafi	2441.0	LY
122	LCA	Saint Lucia	North America	Caribbean	622.0	1979.0	154000	72.3	571.0	NaN	Saint Lucia	Constitutional Monarchy	Elisabeth II	3065.0	LC
123	LIE	Liechtenstein	Europe	Western Europe	160.0	1806.0	32300	78.8	1119.0	1084.0	Liechtenstein	Constitutional Monarchy	Hans-Adam II	2446.0	LI
124	LKA	Sri Lanka	Asia	Southern and Central Asia	65610.0	1948.0	18827000	71.8	15706.0	15091.0	Sri Lanka/Ilankai	Republic	Chandrika Kumaratunga	3217.0	LK
125	LSO	Lesotho	Africa	Southern Africa	30355.0	1966.0	2153000	50.8	1061.0	1161.0	Lesotho	Constitutional Monarchy	Letsie III	2437.0	LS
126	LTU	Lithuania	Europe	Baltic Countries	65301.0	1991.0	3698500	69.1	10692.0	9585.0	Lietuva	Republic	Valdas Adamkus	2447.0	LT
127	LUX	Luxembourg	Europe	Western Europe	2586.0	1867.0	435700	77.1	16321.0	15519.0	Luxembourg/Lëtzebuerg	Constitutional Monarchy	Henri	2452.0	LU
128	LVA	Latvia	Europe	Baltic Countries	64589.0	1991.0	2424200	68.4	6398.0	5639.0	Latvija	Republic	Vaira Vike-Freiberga	2434.0	LV
129	MAC	Macao	Asia	Eastern Asia	18.0	NaN	473000	81.6	5749.0	5940.0	Macau/Aomen	Special Administrative Region of China	Jiang Zemin	2454.0	MO
130	MAR	Morocco	Africa	Northern Africa	446550.0	1956.0	28351000	69.1	36124.0	33514.0	Al-Maghrib	Constitutional Monarchy	Mohammed VI	2486.0	MA
131	MCO	Monaco	Europe	Western Europe	1.5	1861.0	34000	78.8	776.0	NaN	Monaco	Constitutional Monarchy	Rainier III	2695.0	MC
132	MDA	Moldova	Europe	Eastern Europe	33851.0	1991.0	4380000	64.5	1579.0	1872.0	Moldova	Republic	Vladimir Voronin	2690.0	MD
133	MDG	Madagascar	Africa	Eastern Africa	587041.0	1960.0	15942000	55.0	3750.0	3545.0	Madagasikara/Madagascar	Federal Republic	Didier Ratsiraka	2455.0	MG
134	MDV	Maldives	Asia	Southern and Central Asia	298.0	1965.0	286000	62.2	199.0	NaN	Dhivehi Raajje/Maldives	Republic	Maumoon Abdul Gayoom	2463.0	MV
135	MEX	Mexico	North America	Central America	1958201.0	1810.0	98881000	71.5	414972.0	401461.0	México	Federal Republic	Vicente Fox Quesada	2515.0	MX
136	MHL	Marshall Islands	Oceania	Micronesia	181.0	1990.0	64000	65.5	97.0	NaN	Marshall Islands/Majol	Republic	Kessai Note	2507.0	MH
137	MKD	Macedonia	Europe	Southern Europe	25713.0	1991.0	2024000	73.8	1694.0	1915.0	Makedonija	Republic	Boris Trajkovski	2460.0	MK
138	MLI	Mali	Africa	Western Africa	1240192.0	1960.0	11234000	46.7	2642.0	2453.0	Mali	Republic	Alpha Oumar Konaré	2482.0	ML
139	MLT	Malta	Europe	Southern Europe	316.0	1964.0	380200	77.9	3512.0	3338.0	Malta	Republic	Guido de Marco	2484.0	MT
140	MMR	Myanmar	Asia	Southeast Asia	676578.0	1948.0	45611000	54.9	180375.0	171028.0	Myanma Pye	Republic	kenraali Than Shwe	2710.0	MM
141	MNG	Mongolia	Asia	Eastern Asia	1566500.0	1921.0	2662000	67.3	1043.0	933.0	Mongol Uls	Republic	Natsagiin Bagabandi	2696.0	MN
142	MNP	Northern Mariana Islands	Oceania	Micronesia	464.0	NaN	78000	75.5	0.0	NaN	Northern Mariana Islands	Commonwealth of the US	George W. Bush	2913.0	MP
143	MOZ	Mozambique	Africa	Eastern Africa	801590.0	1975.0	19680000	37.5	2891.0	2711.0	Moçambique	Republic	Joaquím A. Chissano	2698.0	MZ
144	MRT	Mauritania	Africa	Western Africa	1025520.0	1960.0	2670000	50.8	998.0	1081.0	Muritaniya/Mauritanie	Republic	Maaouiya Ould Sid´Ahmad Taya	2509.0	MR
145	MSR	Montserrat	North America	Caribbean	102.0	NaN	11000	78.0	109.0	NaN	Montserrat	Dependent Territory of the UK	Elisabeth II	2697.0	MS
146	MTQ	Martinique	North America	Caribbean	1102.0	NaN	395000	78.3	2731.0	2559.0	Martinique	Overseas Department of France	Jacques Chirac	2508.0	MQ
147	MUS	Mauritius	Africa	Eastern Africa	2040.0	1968.0	1158000	71.0	4251.0	4186.0	Mauritius	Republic	Cassam Uteem	2511.0	MU
148	MWI	Malawi	Africa	Eastern Africa	118484.0	1964.0	10925000	37.6	1687.0	2527.0	Malawi	Republic	Bakili Muluzi	2462.0	MW
149	MYS	Malaysia	Asia	Southeast Asia	329758.0	1957.0	22244000	70.8	69213.0	97884.0	Malaysia	Constitutional Monarchy, Federation	Salahuddin Abdul Aziz Shah Alhaj	2464.0	MY
150	MYT	Mayotte	Africa	Eastern Africa	373.0	NaN	149000	59.5	0.0	NaN	Mayotte	Territorial Collectivity of France	Jacques Chirac	2514.0	YT
151	NAM	Namibia	Africa	Southern Africa	824292.0	1990.0	1726000	42.5	3101.0	3384.0	Namibia	Republic	Sam Nujoma	2726.0	NA
152	NCL	New Caledonia	Oceania	Melanesia	18575.0	NaN	214000	72.8	3563.0	NaN	Nouvelle-Calédonie	Nonmetropolitan Territory of France	Jacques Chirac	3493.0	NC
153	NER	Niger	Africa	Western Africa	1267000.0	1960.0	10730000	41.3	1706.0	1580.0	Niger	Republic	Mamadou Tandja	2738.0	NE
154	NFK	Norfolk Island	Oceania	Australia and New Zealand	36.0	NaN	2000	NaN	0.0	NaN	Norfolk Island	Territory of Australia	Elisabeth II	2806.0	NF
155	NGA	Nigeria	Africa	Western Africa	923768.0	1960.0	111506000	51.6	65707.0	58623.0	Nigeria	Federal Republic	Olusegun Obasanjo	2754.0	NG
156	NIC	Nicaragua	North America	Central America	130000.0	1838.0	5074000	68.7	1988.0	2023.0	Nicaragua	Republic	Arnoldo Alemán Lacayo	2734.0	NI
157	NIU	Niue	Oceania	Polynesia	260.0	NaN	2000	NaN	0.0	NaN	Niue	Nonmetropolitan Territory of New Zealand	Elisabeth II	2805.0	NU
158	NLD	Netherlands	Europe	Western Europe	41526.0	1581.0	15864000	78.3	371362.0	360478.0	Nederland	Constitutional Monarchy	Beatrix	5.0	NL
159	NOR	Norway	Europe	Nordic Countries	323877.0	1905.0	4478500	78.7	145895.0	153370.0	Norge	Constitutional Monarchy	Harald V	2807.0	NO
160	NPL	Nepal	Asia	Southern and Central Asia	147181.0	1769.0	23930000	57.8	4768.0	4837.0	Nepal	Constitutional Monarchy	Gyanendra Bir Bikram	2729.0	NP
161	NRU	Nauru	Oceania	Micronesia	21.0	1968.0	12000	60.8	197.0	NaN	Naoero/Nauru	Republic	Bernard Dowiyogo	2728.0	NR
162	NZL	New Zealand	Oceania	Australia and New Zealand	270534.0	1907.0	3862000	77.8	54669.0	64960.0	New Zealand/Aotearoa	Constitutional Monarchy	Elisabeth II	3499.0	NZ
163	OMN	Oman	Asia	Middle East	309500.0	1951.0	2542000	71.8	16904.0	16153.0	´Uman	Monarchy (Sultanate)	Qabus ibn Sa´id	2821.0	OM
164	PAK	Pakistan	Asia	Southern and Central Asia	796095.0	1947.0	156483000	61.1	61289.0	58549.0	Pakistan	Republic	Mohammad Rafiq Tarar	2831.0	PK
165	PAN	Panama	North America	Central America	75517.0	1903.0	2856000	75.5	9131.0	8700.0	Panamá	Republic	Mireya Elisa Moscoso Rodríguez	2882.0	PA
166	PCN	Pitcairn	Oceania	Polynesia	49.0	NaN	50	NaN	0.0	NaN	Pitcairn	Dependent Territory of the UK	Elisabeth II	2912.0	PN
167	PER	Peru	South America	South America	1285216.0	1821.0	25662000	70.0	64140.0	65186.0	Perú/Piruw	Republic	Valentin Paniagua Corazao	2890.0	PE
168	PHL	Philippines	Asia	Southeast Asia	300000.0	1946.0	75967000	67.5	65107.0	82239.0	Pilipinas	Republic	Gloria Macapagal-Arroyo	766.0	PH
169	PLW	Palau	Oceania	Micronesia	459.0	1994.0	19000	68.6	105.0	NaN	Belau/Palau	Republic	Kuniwo Nakamura	2881.0	PW
170	PNG	Papua New Guinea	Oceania	Melanesia	462840.0	1975.0	4807000	63.1	4988.0	6328.0	Papua New Guinea/Papua Niugini	Constitutional Monarchy	Elisabeth II	2884.0	PG
171	POL	Poland	Europe	Eastern Europe	323250.0	1918.0	38653600	73.2	151697.0	135636.0	Polska	Republic	Aleksander Kwasniewski	2928.0	PL
172	PRI	Puerto Rico	North America	Caribbean	8875.0	NaN	3869000	75.6	34100.0	32100.0	Puerto Rico	Commonwealth of the US	George W. Bush	2919.0	PR
173	PRK	North Korea	Asia	Eastern Asia	120538.0	1948.0	24039000	70.7	5332.0	NaN	Choson Minjujuui In´min Konghwaguk (Bukhan)	Socialistic Republic	Kim Jong-il	2318.0	KP
174	PRT	Portugal	Europe	Southern Europe	91982.0	1143.0	9997600	75.8	105954.0	102133.0	Portugal	Republic	Jorge Sampãio	2914.0	PT
175	PRY	Paraguay	South America	South America	406752.0	1811.0	5496000	73.7	8444.0	9555.0	Paraguay	Republic	Luis Ángel González Macchi	2885.0	PY
176	PSE	Palestine	Asia	Middle East	6257.0	NaN	3101000	71.4	4173.0	NaN	Filastin	Autonomous Area	Yasser (Yasir) Arafat	4074.0	PS
177	PYF	French Polynesia	Oceania	Polynesia	4000.0	NaN	235000	74.8	818.0	781.0	Polynésie française	Nonmetropolitan Territory of France	Jacques Chirac	3016.0	PF
178	QAT	Qatar	Asia	Middle East	11000.0	1971.0	599000	72.4	9472.0	8920.0	Qatar	Monarchy	Hamad ibn Khalifa al-Thani	2973.0	QA
179	REU	Réunion	Africa	Eastern Africa	2510.0	NaN	699000	72.7	8287.0	7988.0	Réunion	Overseas Department of France	Jacques Chirac	3017.0	RE
180	ROM	Romania	Europe	Eastern Europe	238391.0	1878.0	22455500	69.9	38158.0	34843.0	România	Republic	Ion Iliescu	3018.0	RO
181	RUS	Russian Federation	Europe	Eastern Europe	17075400.0	1991.0	146934000	67.2	276608.0	442989.0	Rossija	Federal Republic	Vladimir Putin	3580.0	RU
182	RWA	Rwanda	Africa	Eastern Africa	26338.0	1962.0	7733000	39.3	2036.0	1863.0	Rwanda/Urwanda	Republic	Paul Kagame	3047.0	RW
183	SAU	Saudi Arabia	Asia	Middle East	2149690.0	1932.0	21607000	67.8	137635.0	146171.0	Al-´Arabiya as-Sa´udiya	Monarchy	Fahd ibn Abdul-Aziz al-Sa´ud	3173.0	SA
184	SDN	Sudan	Africa	Northern Africa	2505813.0	1956.0	29490000	56.6	10162.0	NaN	As-Sudan	Islamic Republic	Omar Hassan Ahmad al-Bashir	3225.0	SD
185	SEN	Senegal	Africa	Western Africa	196722.0	1960.0	9481000	62.2	4787.0	4542.0	Sénégal/Sounougal	Republic	Abdoulaye Wade	3198.0	SN
186	SGP	Singapore	Asia	Southeast Asia	618.0	1965.0	3567000	80.1	86503.0	96318.0	Singapore/Singapura/Xinjiapo/Singapur	Republic	Sellapan Rama Nathan	3208.0	SG
187	SGS	South Georgia and the South Sandwich Islands	Antarctica	Antarctica	3903.0	NaN	0	NaN	0.0	NaN	South Georgia and the South Sandwich Islands	Dependent Territory of the UK	Elisabeth II	NaN	GS
188	SHN	Saint Helena	Africa	Western Africa	314.0	NaN	6000	76.8	0.0	NaN	Saint Helena	Dependent Territory of the UK	Elisabeth II	3063.0	SH
189	SJM	Svalbard and Jan Mayen	Europe	Nordic Countries	62422.0	NaN	3200	NaN	0.0	NaN	Svalbard og Jan Mayen	Dependent Territory of Norway	Harald V	938.0	SJ
190	SLB	Solomon Islands	Oceania	Melanesia	28896.0	1978.0	444000	71.3	182.0	220.0	Solomon Islands	Constitutional Monarchy	Elisabeth II	3161.0	SB
191	SLE	Sierra Leone	Africa	Western Africa	71740.0	1961.0	4854000	45.3	746.0	858.0	Sierra Leone	Republic	Ahmed Tejan Kabbah	3207.0	SL
192	SLV	El Salvador	North America	Central America	21041.0	1841.0	6276000	69.7	11863.0	11203.0	El Salvador	Republic	Francisco Guillermo Flores Pérez	645.0	SV
193	SMR	San Marino	Europe	Southern Europe	61.0	885.0	27000	81.1	510.0	NaN	San Marino	Republic	None	3171.0	SM
194	SOM	Somalia	Africa	Eastern Africa	637657.0	1960.0	10097000	46.2	935.0	NaN	Soomaaliya	Republic	Abdiqassim Salad Hassan	3214.0	SO
195	SPM	Saint Pierre and Miquelon	North America	North America	242.0	NaN	7000	77.6	0.0	NaN	Saint-Pierre-et-Miquelon	Territorial Collectivity of France	Jacques Chirac	3067.0	PM
196	STP	Sao Tome and Principe	Africa	Central Africa	964.0	1975.0	147000	65.3	6.0	NaN	São Tomé e Príncipe	Republic	Miguel Trovoada	3172.0	ST
197	SUR	Suriname	South America	South America	163265.0	1975.0	417000	71.4	870.0	706.0	Suriname	Republic	Ronald Venetiaan	3243.0	SR
198	SVK	Slovakia	Europe	Eastern Europe	49012.0	1993.0	5398700	73.7	20594.0	19452.0	Slovensko	Republic	Rudolf Schuster	3209.0	SK
199	SVN	Slovenia	Europe	Southern Europe	20256.0	1991.0	1987800	74.9	19756.0	18202.0	Slovenija	Republic	Milan Kucan	3212.0	SI
200	SWE	Sweden	Europe	Nordic Countries	449964.0	836.0	8861400	79.6	226492.0	227757.0	Sverige	Constitutional Monarchy	Carl XVI Gustaf	3048.0	SE
201	SWZ	Swaziland	Africa	Southern Africa	17364.0	1968.0	1008000	40.4	1206.0	1312.0	kaNgwane	Monarchy	Mswati III	3244.0	SZ
202	SYC	Seychelles	Africa	Eastern Africa	455.0	1976.0	77000	70.4	536.0	539.0	Sesel/Seychelles	Republic	France-Albert René	3206.0	SC
203	SYR	Syria	Asia	Middle East	185180.0	1941.0	16125000	68.5	65984.0	64926.0	Suriya	Republic	Bashar al-Assad	3250.0	SY
204	TCA	Turks and Caicos Islands	North America	Caribbean	430.0	NaN	17000	73.3	96.0	NaN	The Turks and Caicos Islands	Dependent Territory of the UK	Elisabeth II	3423.0	TC
205	TCD	Chad	Africa	Central Africa	1284000.0	1960.0	7651000	50.5	1208.0	1102.0	Tchad/Tshad	Republic	Idriss Déby	3337.0	TD
206	TGO	Togo	Africa	Western Africa	56785.0	1960.0	4629000	54.7	1449.0	1400.0	Togo	Republic	Gnassingbé Eyadéma	3332.0	TG
207	THA	Thailand	Asia	Southeast Asia	513115.0	1350.0	61399000	68.6	116416.0	153907.0	Prathet Thai	Constitutional Monarchy	Bhumibol Adulyadej	3320.0	TH
208	TJK	Tajikistan	Asia	Southern and Central Asia	143100.0	1991.0	6188000	64.1	1990.0	1056.0	Toçikiston	Republic	Emomali Rahmonov	3261.0	TJ
209	TKL	Tokelau	Oceania	Polynesia	12.0	NaN	2000	NaN	0.0	NaN	Tokelau	Nonmetropolitan Territory of New Zealand	Elisabeth II	3333.0	TK
210	TKM	Turkmenistan	Asia	Southern and Central Asia	488100.0	1991.0	4459000	60.9	4397.0	2000.0	Türkmenostan	Republic	Saparmurad Nijazov	3419.0	TM
211	TMP	East Timor	Asia	Southeast Asia	14874.0	NaN	885000	46.0	0.0	NaN	Timor Timur	Administrated by the UN	José Alexandre Gusmão	1522.0	TP
212	TON	Tonga	Oceania	Polynesia	650.0	1970.0	99000	67.9	146.0	170.0	Tonga	Monarchy	Taufa'ahau Tupou IV	3334.0	TO
213	TTO	Trinidad and Tobago	North America	Caribbean	5130.0	1962.0	1295000	68.0	6232.0	5867.0	Trinidad and Tobago	Republic	Arthur N. R. Robinson	3336.0	TT
214	TUN	Tunisia	Africa	Northern Africa	163610.0	1956.0	9586000	73.7	20026.0	18898.0	Tunis/Tunisie	Republic	Zine al-Abidine Ben Ali	3349.0	TN
215	TUR	Turkey	Asia	Middle East	774815.0	1923.0	66591000	71.0	210721.0	189122.0	Türkiye	Republic	Ahmet Necdet Sezer	3358.0	TR
216	TUV	Tuvalu	Oceania	Polynesia	26.0	1978.0	12000	66.3	6.0	NaN	Tuvalu	Constitutional Monarchy	Elisabeth II	3424.0	TV
217	TWN	Taiwan	Asia	Eastern Asia	36188.0	1945.0	22256000	76.4	256254.0	263451.0	T’ai-wan	Republic	Chen Shui-bian	3263.0	TW
218	TZA	Tanzania	Africa	Eastern Africa	883749.0	1961.0	33517000	52.3	8005.0	7388.0	Tanzania	Republic	Benjamin William Mkapa	3306.0	TZ
219	UGA	Uganda	Africa	Eastern Africa	241038.0	1962.0	21778000	42.9	6313.0	6887.0	Uganda	Republic	Yoweri Museveni	3425.0	UG
220	UKR	Ukraine	Europe	Eastern Europe	603700.0	1991.0	50456000	66.0	42168.0	49677.0	Ukrajina	Republic	Leonid Kutšma	3426.0	UA
221	UMI	United States Minor Outlying Islands	Oceania	Micronesia/Caribbean	16.0	NaN	0	NaN	0.0	NaN	United States Minor Outlying Islands	Dependent Territory of the US	George W. Bush	NaN	UM
222	URY	Uruguay	South America	South America	175016.0	1828.0	3337000	75.2	20831.0	19967.0	Uruguay	Republic	Jorge Batlle Ibáñez	3492.0	UY
223	USA	United States	North America	North America	9363520.0	1776.0	278357000	77.1	8510700.0	8110900.0	United States	Federal Republic	George W. Bush	3813.0	US
224	UZB	Uzbekistan	Asia	Southern and Central Asia	447400.0	1991.0	24318000	63.7	14194.0	21300.0	Uzbekiston	Republic	Islam Karimov	3503.0	UZ
225	VAT	Holy See (Vatican City State)	Europe	Southern Europe	0.4	1929.0	1000	NaN	9.0	NaN	Santa Sede/Città del Vaticano	Independent Church State	Johannes Paavali II	3538.0	VA
226	VCT	Saint Vincent and the Grenadines	North America	Caribbean	388.0	1979.0	114000	72.3	285.0	NaN	Saint Vincent and the Grenadines	Constitutional Monarchy	Elisabeth II	3066.0	VC
227	VEN	Venezuela	South America	South America	912050.0	1811.0	24170000	73.1	95023.0	88434.0	Venezuela	Federal Republic	Hugo Chávez Frías	3539.0	VE
228	VGB	Virgin Islands, British	North America	Caribbean	151.0	NaN	21000	75.4	612.0	573.0	British Virgin Islands	Dependent Territory of the UK	Elisabeth II	537.0	VG
229	VIR	Virgin Islands, U.S.	North America	Caribbean	347.0	NaN	93000	78.1	0.0	NaN	Virgin Islands of the United States	US Territory	George W. Bush	4067.0	VI
230	VNM	Vietnam	Asia	Southeast Asia	331689.0	1945.0	79832000	69.3	21929.0	22834.0	Viêt Nam	Socialistic Republic	Trân Duc Luong	3770.0	VN
231	VUT	Vanuatu	Oceania	Melanesia	12189.0	1980.0	190000	60.6	261.0	246.0	Vanuatu	Republic	John Bani	3537.0	VU
232	WLF	Wallis and Futuna	Oceania	Polynesia	200.0	NaN	15000	NaN	0.0	NaN	Wallis-et-Futuna	Nonmetropolitan Territory of France	Jacques Chirac	3536.0	WF
233	WSM	Samoa	Oceania	Polynesia	2831.0	1962.0	180000	69.2	141.0	157.0	Samoa	Parlementary Monarchy	Malietoa Tanumafili II	3169.0	WS
234	YEM	Yemen	Asia	Middle East	527968.0	1918.0	18112000	59.8	6041.0	5729.0	Al-Yaman	Republic	Ali Abdallah Salih	1780.0	YE
235	YUG	Yugoslavia	Europe	Southern Europe	102173.0	1918.0	10640000	72.4	17000.0	NaN	Jugoslavija	Federal Republic	Vojislav Koštunica	1792.0	YU
236	ZAF	South Africa	Africa	Southern Africa	1221037.0	1910.0	40377000	51.1	116729.0	129092.0	South Africa	Republic	Thabo Mbeki	716.0	ZA
237	ZMB	Zambia	Africa	Eastern Africa	752618.0	1964.0	9169000	37.2	3377.0	3922.0	Zambia	Republic	Frederick Chiluba	3162.0	ZM
238	ZWE	Zimbabwe	Africa	Eastern Africa	390757.0	1980.0	11669000	37.8	5951.0	8670.0	Zimbabwe	Republic	Robert G. Mugabe	4068.0	ZW

City

SELECT * FROM city;

	ID	Name	CountryCode	District	Population
0	1	Kabul	AFG	Kabol	1780000
1	2	Qandahar	AFG	Qandahar	237500
2	3	Herat	AFG	Herat	186800
3	4	Mazar-e-Sharif	AFG	Balkh	127800
4	5	Amsterdam	NLD	Noord-Holland	731200
5	6	Rotterdam	NLD	Zuid-Holland	593321
6	7	Haag	NLD	Zuid-Holland	440900
7	8	Utrecht	NLD	Utrecht	234323
8	9	Eindhoven	NLD	Noord-Brabant	201843
9	10	Tilburg	NLD	Noord-Brabant	193238
10	11	Groningen	NLD	Groningen	172701
11	12	Breda	NLD	Noord-Brabant	160398
12	13	Apeldoorn	NLD	Gelderland	153491
13	14	Nijmegen	NLD	Gelderland	152463
14	15	Enschede	NLD	Overijssel	149544
15	16	Haarlem	NLD	Noord-Holland	148772
16	17	Almere	NLD	Flevoland	142465
17	18	Arnhem	NLD	Gelderland	138020
18	19	Zaanstad	NLD	Noord-Holland	135621
19	20	´s-Hertogenbosch	NLD	Noord-Brabant	129170
20	21	Amersfoort	NLD	Utrecht	126270
21	22	Maastricht	NLD	Limburg	122087
22	23	Dordrecht	NLD	Zuid-Holland	119811
23	24	Leiden	NLD	Zuid-Holland	117196
24	25	Haarlemmermeer	NLD	Noord-Holland	110722
25	26	Zoetermeer	NLD	Zuid-Holland	110214
26	27	Emmen	NLD	Drenthe	105853
27	28	Zwolle	NLD	Overijssel	105819
28	29	Ede	NLD	Gelderland	101574
29	30	Delft	NLD	Zuid-Holland	95268
30	31	Heerlen	NLD	Limburg	95052
31	32	Alkmaar	NLD	Noord-Holland	92713
32	33	Willemstad	ANT	Curaçao	2345
33	34	Tirana	ALB	Tirana	270000
34	35	Alger	DZA	Alger	2168000
35	36	Oran	DZA	Oran	609823
36	37	Constantine	DZA	Constantine	443727
37	38	Annaba	DZA	Annaba	222518
38	39	Batna	DZA	Batna	183377
39	40	Sétif	DZA	Sétif	179055
40	41	Sidi Bel Abbès	DZA	Sidi Bel Abbès	153106
41	42	Skikda	DZA	Skikda	128747
42	43	Biskra	DZA	Biskra	128281
43	44	Blida (el-Boulaida)	DZA	Blida	127284
44	45	Béjaïa	DZA	Béjaïa	117162
45	46	Mostaganem	DZA	Mostaganem	115212
46	47	Tébessa	DZA	Tébessa	112007
47	48	Tlemcen (Tilimsen)	DZA	Tlemcen	110242
48	49	Béchar	DZA	Béchar	107311
49	50	Tiaret	DZA	Tiaret	100118
50	51	Ech-Chleff (el-Asnam)	DZA	Chlef	96794
51	52	Ghardaïa	DZA	Ghardaïa	89415
52	53	Tafuna	ASM	Tutuila	5200
53	54	Fagatogo	ASM	Tutuila	2323
54	55	Andorra la Vella	AND	Andorra la Vella	21189
55	56	Luanda	AGO	Luanda	2022000
56	57	Huambo	AGO	Huambo	163100
57	58	Lobito	AGO	Benguela	130000
58	59	Benguela	AGO	Benguela	128300
59	60	Namibe	AGO	Namibe	118200
60	61	South Hill	AIA	–	961
61	62	The Valley	AIA	–	595
62	63	Saint John´s	ATG	St John	24000
63	64	Dubai	ARE	Dubai	669181
64	65	Abu Dhabi	ARE	Abu Dhabi	398695
65	66	Sharja	ARE	Sharja	320095
66	67	al-Ayn	ARE	Abu Dhabi	225970
67	68	Ajman	ARE	Ajman	114395
68	69	Buenos Aires	ARG	Distrito Federal	2982146
69	70	La Matanza	ARG	Buenos Aires	1266461
70	71	Córdoba	ARG	Córdoba	1157507
71	72	Rosario	ARG	Santa Fé	907718
72	73	Lomas de Zamora	ARG	Buenos Aires	622013
73	74	Quilmes	ARG	Buenos Aires	559249
74	75	Almirante Brown	ARG	Buenos Aires	538918
75	76	La Plata	ARG	Buenos Aires	521936
76	77	Mar del Plata	ARG	Buenos Aires	512880
77	78	San Miguel de Tucumán	ARG	Tucumán	470809
78	79	Lanús	ARG	Buenos Aires	469735
79	80	Merlo	ARG	Buenos Aires	463846
80	81	General San Martín	ARG	Buenos Aires	422542
81	82	Salta	ARG	Salta	367550
82	83	Moreno	ARG	Buenos Aires	356993
83	84	Santa Fé	ARG	Santa Fé	353063
84	85	Avellaneda	ARG	Buenos Aires	353046
85	86	Tres de Febrero	ARG	Buenos Aires	352311
86	87	Morón	ARG	Buenos Aires	349246
87	88	Florencio Varela	ARG	Buenos Aires	315432
88	89	San Isidro	ARG	Buenos Aires	306341
89	90	Tigre	ARG	Buenos Aires	296226
90	91	Malvinas Argentinas	ARG	Buenos Aires	290335
91	92	Vicente López	ARG	Buenos Aires	288341
92	93	Berazategui	ARG	Buenos Aires	276916
93	94	Corrientes	ARG	Corrientes	258103
94	95	San Miguel	ARG	Buenos Aires	248700
95	96	Bahía Blanca	ARG	Buenos Aires	239810
96	97	Esteban Echeverría	ARG	Buenos Aires	235760
97	98	Resistencia	ARG	Chaco	229212
98	99	José C. Paz	ARG	Buenos Aires	221754
99	100	Paraná	ARG	Entre Rios	207041
100	101	Godoy Cruz	ARG	Mendoza	206998
101	102	Posadas	ARG	Misiones	201273
102	103	Guaymallén	ARG	Mendoza	200595
103	104	Santiago del Estero	ARG	Santiago del Estero	189947
104	105	San Salvador de Jujuy	ARG	Jujuy	178748
105	106	Hurlingham	ARG	Buenos Aires	170028
106	107	Neuquén	ARG	Neuquén	167296
107	108	Ituzaingó	ARG	Buenos Aires	158197
108	109	San Fernando	ARG	Buenos Aires	153036
109	110	Formosa	ARG	Formosa	147636
110	111	Las Heras	ARG	Mendoza	145823
111	112	La Rioja	ARG	La Rioja	138117
112	113	San Fernando del Valle de Cata	ARG	Catamarca	134935
113	114	Río Cuarto	ARG	Córdoba	134355
114	115	Comodoro Rivadavia	ARG	Chubut	124104
115	116	Mendoza	ARG	Mendoza	123027
116	117	San Nicolás de los Arroyos	ARG	Buenos Aires	119302
117	118	San Juan	ARG	San Juan	119152
118	119	Escobar	ARG	Buenos Aires	116675
119	120	Concordia	ARG	Entre Rios	116485
120	121	Pilar	ARG	Buenos Aires	113428
121	122	San Luis	ARG	San Luis	110136
122	123	Ezeiza	ARG	Buenos Aires	99578
123	124	San Rafael	ARG	Mendoza	94651
124	125	Tandil	ARG	Buenos Aires	91101
125	126	Yerevan	ARM	Yerevan	1248700
126	127	Gjumri	ARM	Širak	211700
127	128	Vanadzor	ARM	Lori	172700
128	129	Oranjestad	ABW	–	29034
129	130	Sydney	AUS	New South Wales	3276207
130	131	Melbourne	AUS	Victoria	2865329
131	132	Brisbane	AUS	Queensland	1291117
132	133	Perth	AUS	West Australia	1096829
133	134	Adelaide	AUS	South Australia	978100
134	135	Canberra	AUS	Capital Region	322723
135	136	Gold Coast	AUS	Queensland	311932
136	137	Newcastle	AUS	New South Wales	270324
137	138	Central Coast	AUS	New South Wales	227657
138	139	Wollongong	AUS	New South Wales	219761
139	140	Hobart	AUS	Tasmania	126118
140	141	Geelong	AUS	Victoria	125382
141	142	Townsville	AUS	Queensland	109914
142	143	Cairns	AUS	Queensland	92273
143	144	Bakı	AZE	Bakı	1787800
144	145	Gəncə	AZE	Gəncə	299300
145	146	Sumqayıt	AZE	Sumqayıt	283000
146	147	Mingəçevir	AZE	Mingəçevir	93900
147	148	Nassau	BHS	New Providence	172000
148	149	al-Manama	BHR	al-Manama	148000
149	150	Dhaka	BGD	Dhaka	3612850
150	151	Chittagong	BGD	Chittagong	1392860
151	152	Khulna	BGD	Khulna	663340
152	153	Rajshahi	BGD	Rajshahi	294056
153	154	Narayanganj	BGD	Dhaka	202134
154	155	Rangpur	BGD	Rajshahi	191398
155	156	Mymensingh	BGD	Dhaka	188713
156	157	Barisal	BGD	Barisal	170232
157	158	Tungi	BGD	Dhaka	168702
158	159	Jessore	BGD	Khulna	139710
159	160	Comilla	BGD	Chittagong	135313
160	161	Nawabganj	BGD	Rajshahi	130577
161	162	Dinajpur	BGD	Rajshahi	127815
162	163	Bogra	BGD	Rajshahi	120170
163	164	Sylhet	BGD	Sylhet	117396
164	165	Brahmanbaria	BGD	Chittagong	109032
165	166	Tangail	BGD	Dhaka	106004
166	167	Jamalpur	BGD	Dhaka	103556
167	168	Pabna	BGD	Rajshahi	103277
168	169	Naogaon	BGD	Rajshahi	101266
169	170	Sirajganj	BGD	Rajshahi	99669
170	171	Narsinghdi	BGD	Dhaka	98342
171	172	Saidpur	BGD	Rajshahi	96777
172	173	Gazipur	BGD	Dhaka	96717
173	174	Bridgetown	BRB	St Michael	6070
174	175	Antwerpen	BEL	Antwerpen	446525
175	176	Gent	BEL	East Flanderi	224180
176	177	Charleroi	BEL	Hainaut	200827
177	178	Liège	BEL	Liège	185639
178	179	Bruxelles [Brussel]	BEL	Bryssel	133859
179	180	Brugge	BEL	West Flanderi	116246
180	181	Schaerbeek	BEL	Bryssel	105692
181	182	Namur	BEL	Namur	105419
182	183	Mons	BEL	Hainaut	90935
183	184	Belize City	BLZ	Belize City	55810
184	185	Belmopan	BLZ	Cayo	7105
185	186	Cotonou	BEN	Atlantique	536827
186	187	Porto-Novo	BEN	Ouémé	194000
187	188	Djougou	BEN	Atacora	134099
188	189	Parakou	BEN	Borgou	103577
189	190	Saint George	BMU	Saint George´s	1800
190	191	Hamilton	BMU	Hamilton	1200
191	192	Thimphu	BTN	Thimphu	22000
192	193	Santa Cruz de la Sierra	BOL	Santa Cruz	935361
193	194	La Paz	BOL	La Paz	758141
194	195	El Alto	BOL	La Paz	534466
195	196	Cochabamba	BOL	Cochabamba	482800
196	197	Oruro	BOL	Oruro	223553
197	198	Sucre	BOL	Chuquisaca	178426
198	199	Potosí	BOL	Potosí	140642
199	200	Tarija	BOL	Tarija	125255
200	201	Sarajevo	BIH	Federaatio	360000
201	202	Banja Luka	BIH	Republika Srpska	143079
202	203	Zenica	BIH	Federaatio	96027
203	204	Gaborone	BWA	Gaborone	213017
204	205	Francistown	BWA	Francistown	101805
205	206	São Paulo	BRA	São Paulo	9968485
206	207	Rio de Janeiro	BRA	Rio de Janeiro	5598953
207	208	Salvador	BRA	Bahia	2302832
208	209	Belo Horizonte	BRA	Minas Gerais	2139125
209	210	Fortaleza	BRA	Ceará	2097757
210	211	Brasília	BRA	Distrito Federal	1969868
211	212	Curitiba	BRA	Paraná	1584232
212	213	Recife	BRA	Pernambuco	1378087
213	214	Porto Alegre	BRA	Rio Grande do Sul	1314032
214	215	Manaus	BRA	Amazonas	1255049
215	216	Belém	BRA	Pará	1186926
216	217	Guarulhos	BRA	São Paulo	1095874
217	218	Goiânia	BRA	Goiás	1056330
218	219	Campinas	BRA	São Paulo	950043
219	220	São Gonçalo	BRA	Rio de Janeiro	869254
220	221	Nova Iguaçu	BRA	Rio de Janeiro	862225
221	222	São Luís	BRA	Maranhão	837588
222	223	Maceió	BRA	Alagoas	786288
223	224	Duque de Caxias	BRA	Rio de Janeiro	746758
224	225	São Bernardo do Campo	BRA	São Paulo	723132
225	226	Teresina	BRA	Piauí	691942
226	227	Natal	BRA	Rio Grande do Norte	688955
227	228	Osasco	BRA	São Paulo	659604
228	229	Campo Grande	BRA	Mato Grosso do Sul	649593
229	230	Santo André	BRA	São Paulo	630073
230	231	João Pessoa	BRA	Paraíba	584029
231	232	Jaboatão dos Guararapes	BRA	Pernambuco	558680
232	233	Contagem	BRA	Minas Gerais	520801
233	234	São José dos Campos	BRA	São Paulo	515553
234	235	Uberlândia	BRA	Minas Gerais	487222
235	236	Feira de Santana	BRA	Bahia	479992
236	237	Ribeirão Preto	BRA	São Paulo	473276
237	238	Sorocaba	BRA	São Paulo	466823
238	239	Niterói	BRA	Rio de Janeiro	459884
239	240	Cuiabá	BRA	Mato Grosso	453813
240	241	Juiz de Fora	BRA	Minas Gerais	450288
241	242	Aracaju	BRA	Sergipe	445555
242	243	São João de Meriti	BRA	Rio de Janeiro	440052
243	244	Londrina	BRA	Paraná	432257
244	245	Joinville	BRA	Santa Catarina	428011
245	246	Belford Roxo	BRA	Rio de Janeiro	425194
246	247	Santos	BRA	São Paulo	408748
247	248	Ananindeua	BRA	Pará	400940
248	249	Campos dos Goytacazes	BRA	Rio de Janeiro	398418
249	250	Mauá	BRA	São Paulo	375055
250	251	Carapicuíba	BRA	São Paulo	357552
251	252	Olinda	BRA	Pernambuco	354732
252	253	Campina Grande	BRA	Paraíba	352497
253	254	São José do Rio Preto	BRA	São Paulo	351944
254	255	Caxias do Sul	BRA	Rio Grande do Sul	349581
255	256	Moji das Cruzes	BRA	São Paulo	339194
256	257	Diadema	BRA	São Paulo	335078
257	258	Aparecida de Goiânia	BRA	Goiás	324662
258	259	Piracicaba	BRA	São Paulo	319104
259	260	Cariacica	BRA	Espírito Santo	319033
260	261	Vila Velha	BRA	Espírito Santo	318758
261	262	Pelotas	BRA	Rio Grande do Sul	315415
262	263	Bauru	BRA	São Paulo	313670
263	264	Porto Velho	BRA	Rondônia	309750
264	265	Serra	BRA	Espírito Santo	302666
265	266	Betim	BRA	Minas Gerais	302108
266	267	Jundíaí	BRA	São Paulo	296127
267	268	Canoas	BRA	Rio Grande do Sul	294125
268	269	Franca	BRA	São Paulo	290139
269	270	São Vicente	BRA	São Paulo	286848
270	271	Maringá	BRA	Paraná	286461
271	272	Montes Claros	BRA	Minas Gerais	286058
272	273	Anápolis	BRA	Goiás	282197
273	274	Florianópolis	BRA	Santa Catarina	281928
274	275	Petrópolis	BRA	Rio de Janeiro	279183
275	276	Itaquaquecetuba	BRA	São Paulo	270874
276	277	Vitória	BRA	Espírito Santo	270626
277	278	Ponta Grossa	BRA	Paraná	268013
278	279	Rio Branco	BRA	Acre	259537
279	280	Foz do Iguaçu	BRA	Paraná	259425
280	281	Macapá	BRA	Amapá	256033
281	282	Ilhéus	BRA	Bahia	254970
282	283	Vitória da Conquista	BRA	Bahia	253587
283	284	Uberaba	BRA	Minas Gerais	249225
284	285	Paulista	BRA	Pernambuco	248473
285	286	Limeira	BRA	São Paulo	245497
286	287	Blumenau	BRA	Santa Catarina	244379
287	288	Caruaru	BRA	Pernambuco	244247
288	289	Santarém	BRA	Pará	241771
289	290	Volta Redonda	BRA	Rio de Janeiro	240315
290	291	Novo Hamburgo	BRA	Rio Grande do Sul	239940
291	292	Caucaia	BRA	Ceará	238738
292	293	Santa Maria	BRA	Rio Grande do Sul	238473
293	294	Cascavel	BRA	Paraná	237510
294	295	Guarujá	BRA	São Paulo	237206
295	296	Ribeirão das Neves	BRA	Minas Gerais	232685
296	297	Governador Valadares	BRA	Minas Gerais	231724
297	298	Taubaté	BRA	São Paulo	229130
298	299	Imperatriz	BRA	Maranhão	224564
299	300	Gravataí	BRA	Rio Grande do Sul	223011
300	301	Embu	BRA	São Paulo	222223
301	302	Mossoró	BRA	Rio Grande do Norte	214901
302	303	Várzea Grande	BRA	Mato Grosso	214435
303	304	Petrolina	BRA	Pernambuco	210540
304	305	Barueri	BRA	São Paulo	208426
305	306	Viamão	BRA	Rio Grande do Sul	207557
306	307	Ipatinga	BRA	Minas Gerais	206338
307	308	Juazeiro	BRA	Bahia	201073
308	309	Juazeiro do Norte	BRA	Ceará	199636
309	310	Taboão da Serra	BRA	São Paulo	197550
310	311	São José dos Pinhais	BRA	Paraná	196884
311	312	Magé	BRA	Rio de Janeiro	196147
312	313	Suzano	BRA	São Paulo	195434
313	314	São Leopoldo	BRA	Rio Grande do Sul	189258
314	315	Marília	BRA	São Paulo	188691
315	316	São Carlos	BRA	São Paulo	187122
316	317	Sumaré	BRA	São Paulo	186205
317	318	Presidente Prudente	BRA	São Paulo	185340
318	319	Divinópolis	BRA	Minas Gerais	185047
319	320	Sete Lagoas	BRA	Minas Gerais	182984
320	321	Rio Grande	BRA	Rio Grande do Sul	182222
321	322	Itabuna	BRA	Bahia	182148
322	323	Jequié	BRA	Bahia	179128
323	324	Arapiraca	BRA	Alagoas	178988
324	325	Colombo	BRA	Paraná	177764
325	326	Americana	BRA	São Paulo	177409
326	327	Alvorada	BRA	Rio Grande do Sul	175574
327	328	Araraquara	BRA	São Paulo	174381
328	329	Itaboraí	BRA	Rio de Janeiro	173977
329	330	Santa Bárbara d´Oeste	BRA	São Paulo	171657
330	331	Nova Friburgo	BRA	Rio de Janeiro	170697
331	332	Jacareí	BRA	São Paulo	170356
332	333	Araçatuba	BRA	São Paulo	169303
333	334	Barra Mansa	BRA	Rio de Janeiro	168953
334	335	Praia Grande	BRA	São Paulo	168434
335	336	Marabá	BRA	Pará	167795
336	337	Criciúma	BRA	Santa Catarina	167661
337	338	Boa Vista	BRA	Roraima	167185
338	339	Passo Fundo	BRA	Rio Grande do Sul	166343
339	340	Dourados	BRA	Mato Grosso do Sul	164716
340	341	Santa Luzia	BRA	Minas Gerais	164704
341	342	Rio Claro	BRA	São Paulo	163551
342	343	Maracanaú	BRA	Ceará	162022
343	344	Guarapuava	BRA	Paraná	160510
344	345	Rondonópolis	BRA	Mato Grosso	155115
345	346	São José	BRA	Santa Catarina	155105
346	347	Cachoeiro de Itapemirim	BRA	Espírito Santo	155024
347	348	Nilópolis	BRA	Rio de Janeiro	153383
348	349	Itapevi	BRA	São Paulo	150664
349	350	Cabo de Santo Agostinho	BRA	Pernambuco	149964
350	351	Camaçari	BRA	Bahia	149146
351	352	Sobral	BRA	Ceará	146005
352	353	Itajaí	BRA	Santa Catarina	145197
353	354	Chapecó	BRA	Santa Catarina	144158
354	355	Cotia	BRA	São Paulo	140042
355	356	Lages	BRA	Santa Catarina	139570
356	357	Ferraz de Vasconcelos	BRA	São Paulo	139283
357	358	Indaiatuba	BRA	São Paulo	135968
358	359	Hortolândia	BRA	São Paulo	135755
359	360	Caxias	BRA	Maranhão	133980
360	361	São Caetano do Sul	BRA	São Paulo	133321
361	362	Itu	BRA	São Paulo	132736
362	363	Nossa Senhora do Socorro	BRA	Sergipe	131351
363	364	Parnaíba	BRA	Piauí	129756
364	365	Poços de Caldas	BRA	Minas Gerais	129683
365	366	Teresópolis	BRA	Rio de Janeiro	128079
366	367	Barreiras	BRA	Bahia	127801
367	368	Castanhal	BRA	Pará	127634
368	369	Alagoinhas	BRA	Bahia	126820
369	370	Itapecerica da Serra	BRA	São Paulo	126672
370	371	Uruguaiana	BRA	Rio Grande do Sul	126305
371	372	Paranaguá	BRA	Paraná	126076
372	373	Ibirité	BRA	Minas Gerais	125982
373	374	Timon	BRA	Maranhão	125812
374	375	Luziânia	BRA	Goiás	125597
375	376	Macaé	BRA	Rio de Janeiro	125597
376	377	Teófilo Otoni	BRA	Minas Gerais	124489
377	378	Moji-Guaçu	BRA	São Paulo	123782
378	379	Palmas	BRA	Tocantins	121919
379	380	Pindamonhangaba	BRA	São Paulo	121904
380	381	Francisco Morato	BRA	São Paulo	121197
381	382	Bagé	BRA	Rio Grande do Sul	120793
382	383	Sapucaia do Sul	BRA	Rio Grande do Sul	120217
383	384	Cabo Frio	BRA	Rio de Janeiro	119503
384	385	Itapetininga	BRA	São Paulo	119391
385	386	Patos de Minas	BRA	Minas Gerais	119262
386	387	Camaragibe	BRA	Pernambuco	118968
387	388	Bragança Paulista	BRA	São Paulo	116929
388	389	Queimados	BRA	Rio de Janeiro	115020
389	390	Araguaína	BRA	Tocantins	114948
390	391	Garanhuns	BRA	Pernambuco	114603
391	392	Vitória de Santo Antão	BRA	Pernambuco	113595
392	393	Santa Rita	BRA	Paraíba	113135
393	394	Barbacena	BRA	Minas Gerais	113079
394	395	Abaetetuba	BRA	Pará	111258
395	396	Jaú	BRA	São Paulo	109965
396	397	Lauro de Freitas	BRA	Bahia	109236
397	398	Franco da Rocha	BRA	São Paulo	108964
398	399	Teixeira de Freitas	BRA	Bahia	108441
399	400	Varginha	BRA	Minas Gerais	108314
400	401	Ribeirão Pires	BRA	São Paulo	108121
401	402	Sabará	BRA	Minas Gerais	107781
402	403	Catanduva	BRA	São Paulo	107761
403	404	Rio Verde	BRA	Goiás	107755
404	405	Botucatu	BRA	São Paulo	107663
405	406	Colatina	BRA	Espírito Santo	107354
406	407	Santa Cruz do Sul	BRA	Rio Grande do Sul	106734
407	408	Linhares	BRA	Espírito Santo	106278
408	409	Apucarana	BRA	Paraná	105114
409	410	Barretos	BRA	São Paulo	104156
410	411	Guaratinguetá	BRA	São Paulo	103433
411	412	Cachoeirinha	BRA	Rio Grande do Sul	103240
412	413	Codó	BRA	Maranhão	103153
413	414	Jaraguá do Sul	BRA	Santa Catarina	102580
414	415	Cubatão	BRA	São Paulo	102372
415	416	Itabira	BRA	Minas Gerais	102217
416	417	Itaituba	BRA	Pará	101320
417	418	Araras	BRA	São Paulo	101046
418	419	Resende	BRA	Rio de Janeiro	100627
419	420	Atibaia	BRA	São Paulo	100356
420	421	Pouso Alegre	BRA	Minas Gerais	100028
421	422	Toledo	BRA	Paraná	99387
422	423	Crato	BRA	Ceará	98965
423	424	Passos	BRA	Minas Gerais	98570
424	425	Araguari	BRA	Minas Gerais	98399
425	426	São José de Ribamar	BRA	Maranhão	98318
426	427	Pinhais	BRA	Paraná	98198
427	428	Sertãozinho	BRA	São Paulo	98140
428	429	Conselheiro Lafaiete	BRA	Minas Gerais	97507
429	430	Paulo Afonso	BRA	Bahia	97291
430	431	Angra dos Reis	BRA	Rio de Janeiro	96864
431	432	Eunápolis	BRA	Bahia	96610
432	433	Salto	BRA	São Paulo	96348
433	434	Ourinhos	BRA	São Paulo	96291
434	435	Parnamirim	BRA	Rio Grande do Norte	96210
435	436	Jacobina	BRA	Bahia	96131
436	437	Coronel Fabriciano	BRA	Minas Gerais	95933
437	438	Birigui	BRA	São Paulo	94685
438	439	Tatuí	BRA	São Paulo	93897
439	440	Ji-Paraná	BRA	Rondônia	93346
440	441	Bacabal	BRA	Maranhão	93121
441	442	Cametá	BRA	Pará	92779
442	443	Guaíba	BRA	Rio Grande do Sul	92224
443	444	São Lourenço da Mata	BRA	Pernambuco	91999
444	445	Santana do Livramento	BRA	Rio Grande do Sul	91779
445	446	Votorantim	BRA	São Paulo	91777
446	447	Campo Largo	BRA	Paraná	91203
447	448	Patos	BRA	Paraíba	90519
448	449	Ituiutaba	BRA	Minas Gerais	90507
449	450	Corumbá	BRA	Mato Grosso do Sul	90111
450	451	Palhoça	BRA	Santa Catarina	89465
451	452	Barra do Piraí	BRA	Rio de Janeiro	89388
452	453	Bento Gonçalves	BRA	Rio Grande do Sul	89254
453	454	Poá	BRA	São Paulo	89236
454	455	Águas Lindas de Goiás	BRA	Goiás	89200
455	456	London	GBR	England	7285000
456	457	Birmingham	GBR	England	1013000
457	458	Glasgow	GBR	Scotland	619680
458	459	Liverpool	GBR	England	461000
459	460	Edinburgh	GBR	Scotland	450180
460	461	Sheffield	GBR	England	431607
461	462	Manchester	GBR	England	430000
462	463	Leeds	GBR	England	424194
463	464	Bristol	GBR	England	402000
464	465	Cardiff	GBR	Wales	321000
465	466	Coventry	GBR	England	304000
466	467	Leicester	GBR	England	294000
467	468	Bradford	GBR	England	289376
468	469	Belfast	GBR	North Ireland	287500
469	470	Nottingham	GBR	England	287000
470	471	Kingston upon Hull	GBR	England	262000
471	472	Plymouth	GBR	England	253000
472	473	Stoke-on-Trent	GBR	England	252000
473	474	Wolverhampton	GBR	England	242000
474	475	Derby	GBR	England	236000
475	476	Swansea	GBR	Wales	230000
476	477	Southampton	GBR	England	216000
477	478	Aberdeen	GBR	Scotland	213070
478	479	Northampton	GBR	England	196000
479	480	Dudley	GBR	England	192171
480	481	Portsmouth	GBR	England	190000
481	482	Newcastle upon Tyne	GBR	England	189150
482	483	Sunderland	GBR	England	183310
483	484	Luton	GBR	England	183000
484	485	Swindon	GBR	England	180000
485	486	Southend-on-Sea	GBR	England	176000
486	487	Walsall	GBR	England	174739
487	488	Bournemouth	GBR	England	162000
488	489	Peterborough	GBR	England	156000
489	490	Brighton	GBR	England	156124
490	491	Blackpool	GBR	England	151000
491	492	Dundee	GBR	Scotland	146690
492	493	West Bromwich	GBR	England	146386
493	494	Reading	GBR	England	148000
494	495	Oldbury/Smethwick (Warley)	GBR	England	145542
495	496	Middlesbrough	GBR	England	145000
496	497	Huddersfield	GBR	England	143726
497	498	Oxford	GBR	England	144000
498	499	Poole	GBR	England	141000
499	500	Bolton	GBR	England	139020
500	501	Blackburn	GBR	England	140000
501	502	Newport	GBR	Wales	139000
502	503	Preston	GBR	England	135000
503	504	Stockport	GBR	England	132813
504	505	Norwich	GBR	England	124000
505	506	Rotherham	GBR	England	121380
506	507	Cambridge	GBR	England	121000
507	508	Watford	GBR	England	113080
508	509	Ipswich	GBR	England	114000
509	510	Slough	GBR	England	112000
510	511	Exeter	GBR	England	111000
511	512	Cheltenham	GBR	England	106000
512	513	Gloucester	GBR	England	107000
513	514	Saint Helens	GBR	England	106293
514	515	Sutton Coldfield	GBR	England	106001
515	516	York	GBR	England	104425
516	517	Oldham	GBR	England	103931
517	518	Basildon	GBR	England	100924
518	519	Worthing	GBR	England	100000
519	520	Chelmsford	GBR	England	97451
520	521	Colchester	GBR	England	96063
521	522	Crawley	GBR	England	97000
522	523	Gillingham	GBR	England	92000
523	524	Solihull	GBR	England	94531
524	525	Rochdale	GBR	England	94313
525	526	Birkenhead	GBR	England	93087
526	527	Worcester	GBR	England	95000
527	528	Hartlepool	GBR	England	92000
528	529	Halifax	GBR	England	91069
529	530	Woking/Byfleet	GBR	England	92000
530	531	Southport	GBR	England	90959
531	532	Maidstone	GBR	England	90878
532	533	Eastbourne	GBR	England	90000
533	534	Grimsby	GBR	England	89000
534	535	Saint Helier	GBR	Jersey	27523
535	536	Douglas	GBR	–	23487
536	537	Road Town	VGB	Tortola	8000
537	538	Bandar Seri Begawan	BRN	Brunei and Muara	21484
538	539	Sofija	BGR	Grad Sofija	1122302
539	540	Plovdiv	BGR	Plovdiv	342584
540	541	Varna	BGR	Varna	299801
541	542	Burgas	BGR	Burgas	195255
542	543	Ruse	BGR	Ruse	166467
543	544	Stara Zagora	BGR	Haskovo	147939
544	545	Pleven	BGR	Lovec	121952
545	546	Sliven	BGR	Burgas	105530
546	547	Dobric	BGR	Varna	100399
547	548	Šumen	BGR	Varna	94686
548	549	Ouagadougou	BFA	Kadiogo	824000
549	550	Bobo-Dioulasso	BFA	Houet	300000
550	551	Koudougou	BFA	Boulkiemdé	105000
551	552	Bujumbura	BDI	Bujumbura	300000
552	553	George Town	CYM	Grand Cayman	19600
553	554	Santiago de Chile	CHL	Santiago	4703954
554	555	Puente Alto	CHL	Santiago	386236
555	556	Viña del Mar	CHL	Valparaíso	312493
556	557	Valparaíso	CHL	Valparaíso	293800
557	558	Talcahuano	CHL	Bíobío	277752
558	559	Antofagasta	CHL	Antofagasta	251429
559	560	San Bernardo	CHL	Santiago	241910
560	561	Temuco	CHL	La Araucanía	233041
561	562	Concepción	CHL	Bíobío	217664
562	563	Rancagua	CHL	O´Higgins	212977
563	564	Arica	CHL	Tarapacá	189036
564	565	Talca	CHL	Maule	187557
565	566	Chillán	CHL	Bíobío	178182
566	567	Iquique	CHL	Tarapacá	177892
567	568	Los Angeles	CHL	Bíobío	158215
568	569	Puerto Montt	CHL	Los Lagos	152194
569	570	Coquimbo	CHL	Coquimbo	143353
570	571	Osorno	CHL	Los Lagos	141468
571	572	La Serena	CHL	Coquimbo	137409
572	573	Calama	CHL	Antofagasta	137265
573	574	Valdivia	CHL	Los Lagos	133106
574	575	Punta Arenas	CHL	Magallanes	125631
575	576	Copiapó	CHL	Atacama	120128
576	577	Quilpué	CHL	Valparaíso	118857
577	578	Curicó	CHL	Maule	115766
578	579	Ovalle	CHL	Coquimbo	94854
579	580	Coronel	CHL	Bíobío	93061
580	581	San Pedro de la Paz	CHL	Bíobío	91684
581	582	Melipilla	CHL	Santiago	91056
582	583	Avarua	COK	Rarotonga	11900
583	584	San José	CRI	San José	339131
584	585	Djibouti	DJI	Djibouti	383000
585	586	Roseau	DMA	St George	16243
586	587	Santo Domingo de Guzmán	DOM	Distrito Nacional	1609966
587	588	Santiago de los Caballeros	DOM	Santiago	365463
588	589	La Romana	DOM	La Romana	140204
589	590	San Pedro de Macorís	DOM	San Pedro de Macorís	124735
590	591	San Francisco de Macorís	DOM	Duarte	108485
591	592	San Felipe de Puerto Plata	DOM	Puerto Plata	89423
592	593	Guayaquil	ECU	Guayas	2070040
593	594	Quito	ECU	Pichincha	1573458
594	595	Cuenca	ECU	Azuay	270353
595	596	Machala	ECU	El Oro	210368
596	597	Santo Domingo de los Colorados	ECU	Pichincha	202111
597	598	Portoviejo	ECU	Manabí	176413
598	599	Ambato	ECU	Tungurahua	169612
599	600	Manta	ECU	Manabí	164739
600	601	Duran [Eloy Alfaro]	ECU	Guayas	152514
601	602	Ibarra	ECU	Imbabura	130643
602	603	Quevedo	ECU	Los Ríos	129631
603	604	Milagro	ECU	Guayas	124177
604	605	Loja	ECU	Loja	123875
605	606	Ríobamba	ECU	Chimborazo	123163
606	607	Esmeraldas	ECU	Esmeraldas	123045
607	608	Cairo	EGY	Kairo	6789479
608	609	Alexandria	EGY	Aleksandria	3328196
609	610	Giza	EGY	Giza	2221868
610	611	Shubra al-Khayma	EGY	al-Qalyubiya	870716
611	612	Port Said	EGY	Port Said	469533
612	613	Suez	EGY	Suez	417610
613	614	al-Mahallat al-Kubra	EGY	al-Gharbiya	395402
614	615	Tanta	EGY	al-Gharbiya	371010
615	616	al-Mansura	EGY	al-Daqahliya	369621
616	617	Luxor	EGY	Luxor	360503
617	618	Asyut	EGY	Asyut	343498
618	619	Bahtim	EGY	al-Qalyubiya	275807
619	620	Zagazig	EGY	al-Sharqiya	267351
620	621	al-Faiyum	EGY	al-Faiyum	260964
621	622	Ismailia	EGY	Ismailia	254477
622	623	Kafr al-Dawwar	EGY	al-Buhayra	231978
623	624	Assuan	EGY	Assuan	219017
624	625	Damanhur	EGY	al-Buhayra	212203
625	626	al-Minya	EGY	al-Minya	201360
626	627	Bani Suwayf	EGY	Bani Suwayf	172032
627	628	Qina	EGY	Qina	171275
628	629	Sawhaj	EGY	Sawhaj	170125
629	630	Shibin al-Kawm	EGY	al-Minufiya	159909
630	631	Bulaq al-Dakrur	EGY	Giza	148787
631	632	Banha	EGY	al-Qalyubiya	145792
632	633	Warraq al-Arab	EGY	Giza	127108
633	634	Kafr al-Shaykh	EGY	Kafr al-Shaykh	124819
634	635	Mallawi	EGY	al-Minya	119283
635	636	Bilbays	EGY	al-Sharqiya	113608
636	637	Mit Ghamr	EGY	al-Daqahliya	101801
637	638	al-Arish	EGY	Shamal Sina	100447
638	639	Talkha	EGY	al-Daqahliya	97700
639	640	Qalyub	EGY	al-Qalyubiya	97200
640	641	Jirja	EGY	Sawhaj	95400
641	642	Idfu	EGY	Qina	94200
642	643	al-Hawamidiya	EGY	Giza	91700
643	644	Disuq	EGY	Kafr al-Shaykh	91300
644	645	San Salvador	SLV	San Salvador	415346
645	646	Santa Ana	SLV	Santa Ana	139389
646	647	Mejicanos	SLV	San Salvador	138800
647	648	Soyapango	SLV	San Salvador	129800
648	649	San Miguel	SLV	San Miguel	127696
649	650	Nueva San Salvador	SLV	La Libertad	98400
650	651	Apopa	SLV	San Salvador	88800
651	652	Asmara	ERI	Maekel	431000
652	653	Madrid	ESP	Madrid	2879052
653	654	Barcelona	ESP	Katalonia	1503451
654	655	Valencia	ESP	Valencia	739412
655	656	Sevilla	ESP	Andalusia	701927
656	657	Zaragoza	ESP	Aragonia	603367
657	658	Málaga	ESP	Andalusia	530553
658	659	Bilbao	ESP	Baskimaa	357589
659	660	Las Palmas de Gran Canaria	ESP	Canary Islands	354757
660	661	Murcia	ESP	Murcia	353504
661	662	Palma de Mallorca	ESP	Balears	326993
662	663	Valladolid	ESP	Castilla and León	319998
663	664	Córdoba	ESP	Andalusia	311708
664	665	Vigo	ESP	Galicia	283670
665	666	Alicante [Alacant]	ESP	Valencia	272432
666	667	Gijón	ESP	Asturia	267980
667	668	L´Hospitalet de Llobregat	ESP	Katalonia	247986
668	669	Granada	ESP	Andalusia	244767
669	670	A Coruña (La Coruña)	ESP	Galicia	243402
670	671	Vitoria-Gasteiz	ESP	Baskimaa	217154
671	672	Santa Cruz de Tenerife	ESP	Canary Islands	213050
672	673	Badalona	ESP	Katalonia	209635
673	674	Oviedo	ESP	Asturia	200453
674	675	Móstoles	ESP	Madrid	195351
675	676	Elche [Elx]	ESP	Valencia	193174
676	677	Sabadell	ESP	Katalonia	184859
677	678	Santander	ESP	Cantabria	184165
678	679	Jerez de la Frontera	ESP	Andalusia	182660
679	680	Pamplona [Iruña]	ESP	Navarra	180483
680	681	Donostia-San Sebastián	ESP	Baskimaa	179208
681	682	Cartagena	ESP	Murcia	177709
682	683	Leganés	ESP	Madrid	173163
683	684	Fuenlabrada	ESP	Madrid	171173
684	685	Almería	ESP	Andalusia	169027
685	686	Terrassa	ESP	Katalonia	168695
686	687	Alcalá de Henares	ESP	Madrid	164463
687	688	Burgos	ESP	Castilla and León	162802
688	689	Salamanca	ESP	Castilla and León	158720
689	690	Albacete	ESP	Kastilia-La Mancha	147527
690	691	Getafe	ESP	Madrid	145371
691	692	Cádiz	ESP	Andalusia	142449
692	693	Alcorcón	ESP	Madrid	142048
693	694	Huelva	ESP	Andalusia	140583
694	695	León	ESP	Castilla and León	139809
695	696	Castellón de la Plana [Castell	ESP	Valencia	139712
696	697	Badajoz	ESP	Extremadura	136613
697	698	[San Cristóbal de] la Laguna	ESP	Canary Islands	127945
698	699	Logroño	ESP	La Rioja	127093
699	700	Santa Coloma de Gramenet	ESP	Katalonia	120802
700	701	Tarragona	ESP	Katalonia	113016
701	702	Lleida (Lérida)	ESP	Katalonia	112207
702	703	Jaén	ESP	Andalusia	109247
703	704	Ourense (Orense)	ESP	Galicia	109120
704	705	Mataró	ESP	Katalonia	104095
705	706	Algeciras	ESP	Andalusia	103106
706	707	Marbella	ESP	Andalusia	101144
707	708	Barakaldo	ESP	Baskimaa	98212
708	709	Dos Hermanas	ESP	Andalusia	94591
709	710	Santiago de Compostela	ESP	Galicia	93745
710	711	Torrejón de Ardoz	ESP	Madrid	92262
711	712	Cape Town	ZAF	Western Cape	2352121
712	713	Soweto	ZAF	Gauteng	904165
713	714	Johannesburg	ZAF	Gauteng	756653
714	715	Port Elizabeth	ZAF	Eastern Cape	752319
715	716	Pretoria	ZAF	Gauteng	658630
716	717	Inanda	ZAF	KwaZulu-Natal	634065
717	718	Durban	ZAF	KwaZulu-Natal	566120
718	719	Vanderbijlpark	ZAF	Gauteng	468931
719	720	Kempton Park	ZAF	Gauteng	442633
720	721	Alberton	ZAF	Gauteng	410102
721	722	Pinetown	ZAF	KwaZulu-Natal	378810
722	723	Pietermaritzburg	ZAF	KwaZulu-Natal	370190
723	724	Benoni	ZAF	Gauteng	365467
724	725	Randburg	ZAF	Gauteng	341288
725	726	Umlazi	ZAF	KwaZulu-Natal	339233
726	727	Bloemfontein	ZAF	Free State	334341
727	728	Vereeniging	ZAF	Gauteng	328535
728	729	Wonderboom	ZAF	Gauteng	283289
729	730	Roodepoort	ZAF	Gauteng	279340
730	731	Boksburg	ZAF	Gauteng	262648
731	732	Klerksdorp	ZAF	North West	261911
732	733	Soshanguve	ZAF	Gauteng	242727
733	734	Newcastle	ZAF	KwaZulu-Natal	222993
734	735	East London	ZAF	Eastern Cape	221047
735	736	Welkom	ZAF	Free State	203296
736	737	Kimberley	ZAF	Northern Cape	197254
737	738	Uitenhage	ZAF	Eastern Cape	192120
738	739	Chatsworth	ZAF	KwaZulu-Natal	189885
739	740	Mdantsane	ZAF	Eastern Cape	182639
740	741	Krugersdorp	ZAF	Gauteng	181503
741	742	Botshabelo	ZAF	Free State	177971
742	743	Brakpan	ZAF	Gauteng	171363
743	744	Witbank	ZAF	Mpumalanga	167183
744	745	Oberholzer	ZAF	Gauteng	164367
745	746	Germiston	ZAF	Gauteng	164252
746	747	Springs	ZAF	Gauteng	162072
747	748	Westonaria	ZAF	Gauteng	159632
748	749	Randfontein	ZAF	Gauteng	120838
749	750	Paarl	ZAF	Western Cape	105768
750	751	Potchefstroom	ZAF	North West	101817
751	752	Rustenburg	ZAF	North West	97008
752	753	Nigel	ZAF	Gauteng	96734
753	754	George	ZAF	Western Cape	93818
754	755	Ladysmith	ZAF	KwaZulu-Natal	89292
755	756	Addis Abeba	ETH	Addis Abeba	2495000
756	757	Dire Dawa	ETH	Dire Dawa	164851
757	758	Nazret	ETH	Oromia	127842
758	759	Gonder	ETH	Amhara	112249
759	760	Dese	ETH	Amhara	97314
760	761	Mekele	ETH	Tigray	96938
761	762	Bahir Dar	ETH	Amhara	96140
762	763	Stanley	FLK	East Falkland	1636
763	764	Suva	FJI	Central	77366
764	765	Quezon	PHL	National Capital Reg	2173831
765	766	Manila	PHL	National Capital Reg	1581082
766	767	Kalookan	PHL	National Capital Reg	1177604
767	768	Davao	PHL	Southern Mindanao	1147116
768	769	Cebu	PHL	Central Visayas	718821
769	770	Zamboanga	PHL	Western Mindanao	601794
770	771	Pasig	PHL	National Capital Reg	505058
771	772	Valenzuela	PHL	National Capital Reg	485433
772	773	Las Piñas	PHL	National Capital Reg	472780
773	774	Antipolo	PHL	Southern Tagalog	470866
774	775	Taguig	PHL	National Capital Reg	467375
775	776	Cagayan de Oro	PHL	Northern Mindanao	461877
776	777	Parañaque	PHL	National Capital Reg	449811
777	778	Makati	PHL	National Capital Reg	444867
778	779	Bacolod	PHL	Western Visayas	429076
779	780	General Santos	PHL	Southern Mindanao	411822
780	781	Marikina	PHL	National Capital Reg	391170
781	782	Dasmariñas	PHL	Southern Tagalog	379520
782	783	Muntinlupa	PHL	National Capital Reg	379310
783	784	Iloilo	PHL	Western Visayas	365820
784	785	Pasay	PHL	National Capital Reg	354908
785	786	Malabon	PHL	National Capital Reg	338855
786	787	San José del Monte	PHL	Central Luzon	315807
787	788	Bacoor	PHL	Southern Tagalog	305699
788	789	Iligan	PHL	Central Mindanao	285061
789	790	Calamba	PHL	Southern Tagalog	281146
790	791	Mandaluyong	PHL	National Capital Reg	278474
791	792	Butuan	PHL	Caraga	267279
792	793	Angeles	PHL	Central Luzon	263971
793	794	Tarlac	PHL	Central Luzon	262481
794	795	Mandaue	PHL	Central Visayas	259728
795	796	Baguio	PHL	CAR	252386
796	797	Batangas	PHL	Southern Tagalog	247588
797	798	Cainta	PHL	Southern Tagalog	242511
798	799	San Pedro	PHL	Southern Tagalog	231403
799	800	Navotas	PHL	National Capital Reg	230403
800	801	Cabanatuan	PHL	Central Luzon	222859
801	802	San Fernando	PHL	Central Luzon	221857
802	803	Lipa	PHL	Southern Tagalog	218447
803	804	Lapu-Lapu	PHL	Central Visayas	217019
804	805	San Pablo	PHL	Southern Tagalog	207927
805	806	Biñan	PHL	Southern Tagalog	201186
806	807	Taytay	PHL	Southern Tagalog	198183
807	808	Lucena	PHL	Southern Tagalog	196075
808	809	Imus	PHL	Southern Tagalog	195482
809	810	Olongapo	PHL	Central Luzon	194260
810	811	Binangonan	PHL	Southern Tagalog	187691
811	812	Santa Rosa	PHL	Southern Tagalog	185633
812	813	Tagum	PHL	Southern Mindanao	179531
813	814	Tacloban	PHL	Eastern Visayas	178639
814	815	Malolos	PHL	Central Luzon	175291
815	816	Mabalacat	PHL	Central Luzon	171045
816	817	Cotabato	PHL	Central Mindanao	163849
817	818	Meycauayan	PHL	Central Luzon	163037
818	819	Puerto Princesa	PHL	Southern Tagalog	161912
819	820	Legazpi	PHL	Bicol	157010
820	821	Silang	PHL	Southern Tagalog	156137
821	822	Ormoc	PHL	Eastern Visayas	154297
822	823	San Carlos	PHL	Ilocos	154264
823	824	Kabankalan	PHL	Western Visayas	149769
824	825	Talisay	PHL	Central Visayas	148110
825	826	Valencia	PHL	Northern Mindanao	147924
826	827	Calbayog	PHL	Eastern Visayas	147187
827	828	Santa Maria	PHL	Central Luzon	144282
828	829	Pagadian	PHL	Western Mindanao	142515
829	830	Cadiz	PHL	Western Visayas	141954
830	831	Bago	PHL	Western Visayas	141721
831	832	Toledo	PHL	Central Visayas	141174
832	833	Naga	PHL	Bicol	137810
833	834	San Mateo	PHL	Southern Tagalog	135603
834	835	Panabo	PHL	Southern Mindanao	133950
835	836	Koronadal	PHL	Southern Mindanao	133786
836	837	Marawi	PHL	Central Mindanao	131090
837	838	Dagupan	PHL	Ilocos	130328
838	839	Sagay	PHL	Western Visayas	129765
839	840	Roxas	PHL	Western Visayas	126352
840	841	Lubao	PHL	Central Luzon	125699
841	842	Digos	PHL	Southern Mindanao	125171
842	843	San Miguel	PHL	Central Luzon	123824
843	844	Malaybalay	PHL	Northern Mindanao	123672
844	845	Tuguegarao	PHL	Cagayan Valley	120645
845	846	Ilagan	PHL	Cagayan Valley	119990
846	847	Baliuag	PHL	Central Luzon	119675
847	848	Surigao	PHL	Caraga	118534
848	849	San Carlos	PHL	Western Visayas	118259
849	850	San Juan del Monte	PHL	National Capital Reg	117680
850	851	Tanauan	PHL	Southern Tagalog	117539
851	852	Concepcion	PHL	Central Luzon	115171
852	853	Rodriguez (Montalban)	PHL	Southern Tagalog	115167
853	854	Sariaya	PHL	Southern Tagalog	114568
854	855	Malasiqui	PHL	Ilocos	113190
855	856	General Mariano Alvarez	PHL	Southern Tagalog	112446
856	857	Urdaneta	PHL	Ilocos	111582
857	858	Hagonoy	PHL	Central Luzon	111425
858	859	San Jose	PHL	Southern Tagalog	111009
859	860	Polomolok	PHL	Southern Mindanao	110709
860	861	Santiago	PHL	Cagayan Valley	110531
861	862	Tanza	PHL	Southern Tagalog	110517
862	863	Ozamis	PHL	Northern Mindanao	110420
863	864	Mexico	PHL	Central Luzon	109481
864	865	San Jose	PHL	Central Luzon	108254
865	866	Silay	PHL	Western Visayas	107722
866	867	General Trias	PHL	Southern Tagalog	107691
867	868	Tabaco	PHL	Bicol	107166
868	869	Cabuyao	PHL	Southern Tagalog	106630
869	870	Calapan	PHL	Southern Tagalog	105910
870	871	Mati	PHL	Southern Mindanao	105908
871	872	Midsayap	PHL	Central Mindanao	105760
872	873	Cauayan	PHL	Cagayan Valley	103952
873	874	Gingoog	PHL	Northern Mindanao	102379
874	875	Dumaguete	PHL	Central Visayas	102265
875	876	San Fernando	PHL	Ilocos	102082
876	877	Arayat	PHL	Central Luzon	101792
877	878	Bayawan (Tulong)	PHL	Central Visayas	101391
878	879	Kidapawan	PHL	Central Mindanao	101205
879	880	Daraga (Locsin)	PHL	Bicol	101031
880	881	Marilao	PHL	Central Luzon	101017
881	882	Malita	PHL	Southern Mindanao	100000
882	883	Dipolog	PHL	Western Mindanao	99862
883	884	Cavite	PHL	Southern Tagalog	99367
884	885	Danao	PHL	Central Visayas	98781
885	886	Bislig	PHL	Caraga	97860
886	887	Talavera	PHL	Central Luzon	97329
887	888	Guagua	PHL	Central Luzon	96858
888	889	Bayambang	PHL	Ilocos	96609
889	890	Nasugbu	PHL	Southern Tagalog	96113
890	891	Baybay	PHL	Eastern Visayas	95630
891	892	Capas	PHL	Central Luzon	95219
892	893	Sultan Kudarat	PHL	ARMM	94861
893	894	Laoag	PHL	Ilocos	94466
894	895	Bayugan	PHL	Caraga	93623
895	896	Malungon	PHL	Southern Mindanao	93232
896	897	Santa Cruz	PHL	Southern Tagalog	92694
897	898	Sorsogon	PHL	Bicol	92512
898	899	Candelaria	PHL	Southern Tagalog	92429
899	900	Ligao	PHL	Bicol	90603
900	901	Tórshavn	FRO	Streymoyar	14542
901	902	Libreville	GAB	Estuaire	419000
902	903	Serekunda	GMB	Kombo St Mary	102600
903	904	Banjul	GMB	Banjul	42326
904	905	Tbilisi	GEO	Tbilisi	1235200
905	906	Kutaisi	GEO	Imereti	240900
906	907	Rustavi	GEO	Kvemo Kartli	155400
907	908	Batumi	GEO	Adzaria [Atšara]	137700
908	909	Sohumi	GEO	Abhasia [Aphazeti]	111700
909	910	Accra	GHA	Greater Accra	1070000
910	911	Kumasi	GHA	Ashanti	385192
911	912	Tamale	GHA	Northern	151069
912	913	Tema	GHA	Greater Accra	109975
913	914	Sekondi-Takoradi	GHA	Western	103653
914	915	Gibraltar	GIB	–	27025
915	916	Saint George´s	GRD	St George	4621
916	917	Nuuk	GRL	Kitaa	13445
917	918	Les Abymes	GLP	Grande-Terre	62947
918	919	Basse-Terre	GLP	Basse-Terre	12433
919	920	Tamuning	GUM	–	9500
920	921	Agaña	GUM	–	1139
921	922	Ciudad de Guatemala	GTM	Guatemala	823301
922	923	Mixco	GTM	Guatemala	209791
923	924	Villa Nueva	GTM	Guatemala	101295
924	925	Quetzaltenango	GTM	Quetzaltenango	90801
925	926	Conakry	GIN	Conakry	1090610
926	927	Bissau	GNB	Bissau	241000
927	928	Georgetown	GUY	Georgetown	254000
928	929	Port-au-Prince	HTI	Ouest	884472
929	930	Carrefour	HTI	Ouest	290204
930	931	Delmas	HTI	Ouest	240429
931	932	Le-Cap-Haïtien	HTI	Nord	102233
932	933	Tegucigalpa	HND	Distrito Central	813900
933	934	San Pedro Sula	HND	Cortés	383900
934	935	La Ceiba	HND	Atlántida	89200
935	936	Kowloon and New Kowloon	HKG	Kowloon and New Kowl	1987996
936	937	Victoria	HKG	Hongkong	1312637
937	938	Longyearbyen	SJM	Länsimaa	1438
938	939	Jakarta	IDN	Jakarta Raya	9604900
939	940	Surabaya	IDN	East Java	2663820
940	941	Bandung	IDN	West Java	2429000
941	942	Medan	IDN	Sumatera Utara	1843919
942	943	Palembang	IDN	Sumatera Selatan	1222764
943	944	Tangerang	IDN	West Java	1198300
944	945	Semarang	IDN	Central Java	1104405
945	946	Ujung Pandang	IDN	Sulawesi Selatan	1060257
946	947	Malang	IDN	East Java	716862
947	948	Bandar Lampung	IDN	Lampung	680332
948	949	Bekasi	IDN	West Java	644300
949	950	Padang	IDN	Sumatera Barat	534474
950	951	Surakarta	IDN	Central Java	518600
951	952	Banjarmasin	IDN	Kalimantan Selatan	482931
952	953	Pekan Baru	IDN	Riau	438638
953	954	Denpasar	IDN	Bali	435000
954	955	Yogyakarta	IDN	Yogyakarta	418944
955	956	Pontianak	IDN	Kalimantan Barat	409632
956	957	Samarinda	IDN	Kalimantan Timur	399175
957	958	Jambi	IDN	Jambi	385201
958	959	Depok	IDN	West Java	365200
959	960	Cimahi	IDN	West Java	344600
960	961	Balikpapan	IDN	Kalimantan Timur	338752
961	962	Manado	IDN	Sulawesi Utara	332288
962	963	Mataram	IDN	Nusa Tenggara Barat	306600
963	964	Pekalongan	IDN	Central Java	301504
964	965	Tegal	IDN	Central Java	289744
965	966	Bogor	IDN	West Java	285114
966	967	Ciputat	IDN	West Java	270800
967	968	Pondokgede	IDN	West Java	263200
968	969	Cirebon	IDN	West Java	254406
969	970	Kediri	IDN	East Java	253760
970	971	Ambon	IDN	Molukit	249312
971	972	Jember	IDN	East Java	218500
972	973	Cilacap	IDN	Central Java	206900
973	974	Cimanggis	IDN	West Java	205100
974	975	Pematang Siantar	IDN	Sumatera Utara	203056
975	976	Purwokerto	IDN	Central Java	202500
976	977	Ciomas	IDN	West Java	187400
977	978	Tasikmalaya	IDN	West Java	179800
978	979	Madiun	IDN	East Java	171532
979	980	Bengkulu	IDN	Bengkulu	146439
980	981	Karawang	IDN	West Java	145000
981	982	Banda Aceh	IDN	Aceh	143409
982	983	Palu	IDN	Sulawesi Tengah	142800
983	984	Pasuruan	IDN	East Java	134019
984	985	Kupang	IDN	Nusa Tenggara Timur	129300
985	986	Tebing Tinggi	IDN	Sumatera Utara	129300
986	987	Percut Sei Tuan	IDN	Sumatera Utara	129000
987	988	Binjai	IDN	Sumatera Utara	127222
988	989	Sukabumi	IDN	West Java	125766
989	990	Waru	IDN	East Java	124300
990	991	Pangkal Pinang	IDN	Sumatera Selatan	124000
991	992	Magelang	IDN	Central Java	123800
992	993	Blitar	IDN	East Java	122600
993	994	Serang	IDN	West Java	122400
994	995	Probolinggo	IDN	East Java	120770
995	996	Cilegon	IDN	West Java	117000
996	997	Cianjur	IDN	West Java	114300
997	998	Ciparay	IDN	West Java	111500
998	999	Lhokseumawe	IDN	Aceh	109600
999	1000	Taman	IDN	East Java	107000

CountryLanguage

SELECT * FROM countrylanguage;

	CountryCode	Language	IsOfficial	Percentage
0	ABW	Dutch	T	5.3
1	ABW	English	F	9.5
2	ABW	Papiamento	F	76.7
3	ABW	Spanish	F	7.4
4	AFG	Balochi	F	0.9
5	AFG	Dari	T	32.1
6	AFG	Pashto	T	52.4
7	AFG	Turkmenian	F	1.9
8	AFG	Uzbek	F	8.8
9	AGO	Ambo	F	2.4
10	AGO	Chokwe	F	4.2
11	AGO	Kongo	F	13.2
12	AGO	Luchazi	F	2.4
13	AGO	Luimbe-nganguela	F	5.4
14	AGO	Luvale	F	3.6
15	AGO	Mbundu	F	21.6
16	AGO	Nyaneka-nkhumbi	F	5.4
17	AGO	Ovimbundu	F	37.2
18	AIA	English	T	0.0
19	ALB	Albaniana	T	97.9
20	ALB	Greek	F	1.8
21	ALB	Macedonian	F	0.1
22	AND	Catalan	T	32.3
23	AND	French	F	6.2
24	AND	Portuguese	F	10.8
25	AND	Spanish	F	44.6
26	ANT	Dutch	T	0.0
27	ANT	English	F	7.8
28	ANT	Papiamento	T	86.2
29	ARE	Arabic	T	42.0
30	ARE	Hindi	F	0.0
31	ARG	Indian Languages	F	0.3
32	ARG	Italian	F	1.7
33	ARG	Spanish	T	96.8
34	ARM	Armenian	T	93.4
35	ARM	Azerbaijani	F	2.6
36	ASM	English	T	3.1
37	ASM	Samoan	T	90.6
38	ASM	Tongan	F	3.1
39	ATG	Creole English	F	95.7
40	ATG	English	T	0.0
41	AUS	Arabic	F	1.0
42	AUS	Canton Chinese	F	1.1
43	AUS	English	T	81.2
44	AUS	German	F	0.6
45	AUS	Greek	F	1.6
46	AUS	Italian	F	2.2
47	AUS	Serbo-Croatian	F	0.6
48	AUS	Vietnamese	F	0.8
49	AUT	Czech	F	0.2
50	AUT	German	T	92.0
51	AUT	Hungarian	F	0.4
52	AUT	Polish	F	0.2
53	AUT	Romanian	F	0.2
54	AUT	Serbo-Croatian	F	2.2
55	AUT	Slovene	F	0.4
56	AUT	Turkish	F	1.5
57	AZE	Armenian	F	2.0
58	AZE	Azerbaijani	T	89.0
59	AZE	Lezgian	F	2.3
60	AZE	Russian	F	3.0
61	BDI	French	T	0.0
62	BDI	Kirundi	T	98.1
63	BDI	Swahili	F	0.0
64	BEL	Arabic	F	1.6
65	BEL	Dutch	T	59.2
66	BEL	French	T	32.6
67	BEL	German	T	1.0
68	BEL	Italian	F	2.4
69	BEL	Turkish	F	0.9
70	BEN	Adja	F	11.1
71	BEN	Aizo	F	8.7
72	BEN	Bariba	F	8.7
73	BEN	Fon	F	39.8
74	BEN	Ful	F	5.6
75	BEN	Joruba	F	12.2
76	BEN	Somba	F	6.7
77	BFA	Busansi	F	3.5
78	BFA	Dagara	F	3.1
79	BFA	Dyula	F	2.6
80	BFA	Ful	F	9.7
81	BFA	Gurma	F	5.7
82	BFA	Mossi	F	50.2
83	BGD	Bengali	T	97.7
84	BGD	Chakma	F	0.4
85	BGD	Garo	F	0.1
86	BGD	Khasi	F	0.1
87	BGD	Marma	F	0.2
88	BGD	Santhali	F	0.1
89	BGD	Tripuri	F	0.1
90	BGR	Bulgariana	T	83.2
91	BGR	Macedonian	F	2.6
92	BGR	Romani	F	3.7
93	BGR	Turkish	F	9.4
94	BHR	Arabic	T	67.7
95	BHR	English	F	0.0
96	BHS	Creole English	F	89.7
97	BHS	Creole French	F	10.3
98	BIH	Serbo-Croatian	T	99.2
99	BLR	Belorussian	T	65.6
100	BLR	Polish	F	0.6
101	BLR	Russian	T	32.0
102	BLR	Ukrainian	F	1.3
103	BLZ	English	T	50.8
104	BLZ	Garifuna	F	6.8
105	BLZ	Maya Languages	F	9.6
106	BLZ	Spanish	F	31.6
107	BMU	English	T	100.0
108	BOL	Aimará	T	3.2
109	BOL	Guaraní	F	0.1
110	BOL	Ketšua	T	8.1
111	BOL	Spanish	T	87.7
112	BRA	German	F	0.5
113	BRA	Indian Languages	F	0.2
114	BRA	Italian	F	0.4
115	BRA	Japanese	F	0.4
116	BRA	Portuguese	T	97.5
117	BRB	Bajan	F	95.1
118	BRB	English	T	0.0
119	BRN	Chinese	F	9.3
120	BRN	English	F	3.1
121	BRN	Malay	T	45.5
122	BRN	Malay-English	F	28.8
123	BTN	Asami	F	15.2
124	BTN	Dzongkha	T	50.0
125	BTN	Nepali	F	34.8
126	BWA	Khoekhoe	F	2.5
127	BWA	Ndebele	F	1.3
128	BWA	San	F	3.5
129	BWA	Shona	F	12.3
130	BWA	Tswana	F	75.5
131	CAF	Banda	F	23.5
132	CAF	Gbaya	F	23.8
133	CAF	Mandjia	F	14.8
134	CAF	Mbum	F	6.4
135	CAF	Ngbaka	F	7.5
136	CAF	Sara	F	6.4
137	CAN	Chinese	F	2.5
138	CAN	Dutch	F	0.5
139	CAN	English	T	60.4
140	CAN	Eskimo Languages	F	0.1
141	CAN	French	T	23.4
142	CAN	German	F	1.6
143	CAN	Italian	F	1.7
144	CAN	Polish	F	0.7
145	CAN	Portuguese	F	0.7
146	CAN	Punjabi	F	0.7
147	CAN	Spanish	F	0.7
148	CAN	Ukrainian	F	0.6
149	CCK	English	T	0.0
150	CCK	Malay	F	0.0
151	CHE	French	T	19.2
152	CHE	German	T	63.6
153	CHE	Italian	T	7.7
154	CHE	Romansh	T	0.6
155	CHL	Aimará	F	0.5
156	CHL	Araucan	F	9.6
157	CHL	Rapa nui	F	0.2
158	CHL	Spanish	T	89.7
159	CHN	Chinese	T	92.0
160	CHN	Dong	F	0.2
161	CHN	Hui	F	0.8
162	CHN	Mantšu	F	0.9
163	CHN	Miao	F	0.7
164	CHN	Mongolian	F	0.4
165	CHN	Puyi	F	0.2
166	CHN	Tibetan	F	0.4
167	CHN	Tujia	F	0.5
168	CHN	Uighur	F	0.6
169	CHN	Yi	F	0.6
170	CHN	Zhuang	F	1.4
171	CIV	[South]Mande	F	7.7
172	CIV	Akan	F	30.0
173	CIV	Gur	F	11.7
174	CIV	Kru	F	10.5
175	CIV	Malinke	F	11.4
176	CMR	Bamileke-bamum	F	18.6
177	CMR	Duala	F	10.9
178	CMR	Fang	F	19.7
179	CMR	Ful	F	9.6
180	CMR	Maka	F	4.9
181	CMR	Mandara	F	5.7
182	CMR	Masana	F	3.9
183	CMR	Tikar	F	7.4
184	COD	Boa	F	2.3
185	COD	Chokwe	F	1.8
186	COD	Kongo	F	16.0
187	COD	Luba	F	18.0
188	COD	Mongo	F	13.5
189	COD	Ngala and Bangi	F	5.8
190	COD	Rundi	F	3.8
191	COD	Rwanda	F	10.3
192	COD	Teke	F	2.7
193	COD	Zande	F	6.1
194	COG	Kongo	F	51.5
195	COG	Mbete	F	4.8
196	COG	Mboshi	F	11.4
197	COG	Punu	F	2.9
198	COG	Sango	F	2.6
199	COG	Teke	F	17.3
200	COK	English	F	0.0
201	COK	Maori	T	0.0
202	COL	Arawakan	F	0.1
203	COL	Caribbean	F	0.1
204	COL	Chibcha	F	0.4
205	COL	Creole English	F	0.1
206	COL	Spanish	T	99.0
207	COM	Comorian	T	75.0
208	COM	Comorian-Arabic	F	1.6
209	COM	Comorian-French	F	12.9
210	COM	Comorian-madagassi	F	5.5
211	COM	Comorian-Swahili	F	0.5
212	CPV	Crioulo	F	100.0
213	CPV	Portuguese	T	0.0
214	CRI	Chibcha	F	0.3
215	CRI	Chinese	F	0.2
216	CRI	Creole English	F	2.0
217	CRI	Spanish	T	97.5
218	CUB	Spanish	T	100.0
219	CXR	Chinese	F	0.0
220	CXR	English	T	0.0
221	CYM	English	T	0.0
222	CYP	Greek	T	74.1
223	CYP	Turkish	T	22.4
224	CZE	Czech	T	81.2
225	CZE	German	F	0.5
226	CZE	Hungarian	F	0.2
227	CZE	Moravian	F	12.9
228	CZE	Polish	F	0.6
229	CZE	Romani	F	0.3
230	CZE	Silesiana	F	0.4
231	CZE	Slovak	F	3.1
232	DEU	German	T	91.3
233	DEU	Greek	F	0.4
234	DEU	Italian	F	0.7
235	DEU	Polish	F	0.3
236	DEU	Southern Slavic Languages	F	1.4
237	DEU	Turkish	F	2.6
238	DJI	Afar	F	34.8
239	DJI	Arabic	T	10.6
240	DJI	Somali	F	43.9
241	DMA	Creole English	F	100.0
242	DMA	Creole French	F	0.0
243	DNK	Arabic	F	0.7
244	DNK	Danish	T	93.5
245	DNK	English	F	0.3
246	DNK	German	F	0.5
247	DNK	Norwegian	F	0.3
248	DNK	Swedish	F	0.3
249	DNK	Turkish	F	0.8
250	DOM	Creole French	F	2.0
251	DOM	Spanish	T	98.0
252	DZA	Arabic	T	86.0
253	DZA	Berberi	F	14.0
254	ECU	Ketšua	F	7.0
255	ECU	Spanish	T	93.0
256	EGY	Arabic	T	98.8
257	EGY	Sinaberberi	F	0.0
258	ERI	Afar	F	4.3
259	ERI	Bilin	F	3.0
260	ERI	Hadareb	F	3.8
261	ERI	Saho	F	3.0
262	ERI	Tigre	F	31.7
263	ERI	Tigrinja	T	49.1
264	ESH	Arabic	T	100.0
265	ESP	Basque	F	1.6
266	ESP	Catalan	F	16.9
267	ESP	Galecian	F	6.4
268	ESP	Spanish	T	74.4
269	EST	Belorussian	F	1.4
270	EST	Estonian	T	65.3
271	EST	Finnish	F	0.7
272	EST	Russian	F	27.8
273	EST	Ukrainian	F	2.8
274	ETH	Amhara	F	30.0
275	ETH	Gurage	F	4.7
276	ETH	Oromo	F	31.0
277	ETH	Sidamo	F	3.2
278	ETH	Somali	F	4.1
279	ETH	Tigrinja	F	7.2
280	ETH	Walaita	F	2.8
281	FIN	Estonian	F	0.2
282	FIN	Finnish	T	92.7
283	FIN	Russian	F	0.4
284	FIN	Saame	F	0.0
285	FIN	Swedish	T	5.7
286	FJI	Fijian	T	50.8
287	FJI	Hindi	F	43.7
288	FLK	English	T	0.0
289	FRA	Arabic	F	2.5
290	FRA	French	T	93.6
291	FRA	Italian	F	0.4
292	FRA	Portuguese	F	1.2
293	FRA	Spanish	F	0.4
294	FRA	Turkish	F	0.4
295	FRO	Danish	T	0.0
296	FRO	Faroese	T	100.0
297	FSM	Kosrean	F	7.3
298	FSM	Mortlock	F	7.6
299	FSM	Pohnpei	F	23.8
300	FSM	Trukese	F	41.6
301	FSM	Wolea	F	3.7
302	FSM	Yap	F	5.8
303	GAB	Fang	F	35.8
304	GAB	Mbete	F	13.8
305	GAB	Mpongwe	F	14.6
306	GAB	Punu-sira-nzebi	F	17.1
307	GBR	English	T	97.3
308	GBR	Gaeli	F	0.1
309	GBR	Kymri	F	0.9
310	GEO	Abhyasi	F	1.7
311	GEO	Armenian	F	6.8
312	GEO	Azerbaijani	F	5.5
313	GEO	Georgiana	T	71.7
314	GEO	Osseetti	F	2.4
315	GEO	Russian	F	8.8
316	GHA	Akan	F	52.4
317	GHA	Ewe	F	11.9
318	GHA	Ga-adangme	F	7.8
319	GHA	Gurma	F	3.3
320	GHA	Joruba	F	1.3
321	GHA	Mossi	F	15.8
322	GIB	Arabic	F	7.4
323	GIB	English	T	88.9
324	GIN	Ful	F	38.6
325	GIN	Kissi	F	6.0
326	GIN	Kpelle	F	4.6
327	GIN	Loma	F	2.3
328	GIN	Malinke	F	23.2
329	GIN	Susu	F	11.0
330	GIN	Yalunka	F	2.9
331	GLP	Creole French	F	95.0
332	GLP	French	T	0.0
333	GMB	Diola	F	9.2
334	GMB	Ful	F	16.2
335	GMB	Malinke	F	34.1
336	GMB	Soninke	F	7.6
337	GMB	Wolof	F	12.6
338	GNB	Balante	F	14.6
339	GNB	Crioulo	F	36.4
340	GNB	Ful	F	16.6
341	GNB	Malinke	F	6.9
342	GNB	Mandyako	F	4.9
343	GNB	Portuguese	T	8.1
344	GNQ	Bubi	F	8.7
345	GNQ	Fang	F	84.8
346	GRC	Greek	T	98.5
347	GRC	Turkish	F	0.9
348	GRD	Creole English	F	100.0
349	GRL	Danish	T	12.5
350	GRL	Greenlandic	T	87.5
351	GTM	Cakchiquel	F	8.9
352	GTM	Kekchí	F	4.9
353	GTM	Mam	F	2.7
354	GTM	Quiché	F	10.1
355	GTM	Spanish	T	64.7
356	GUF	Creole French	F	94.3
357	GUF	Indian Languages	F	1.9
358	GUM	Chamorro	T	29.6
359	GUM	English	T	37.5
360	GUM	Japanese	F	2.0
361	GUM	Korean	F	3.3
362	GUM	Philippene Languages	F	19.7
363	GUY	Arawakan	F	1.4
364	GUY	Caribbean	F	2.2
365	GUY	Creole English	F	96.4
366	HKG	Canton Chinese	F	88.7
367	HKG	Chiu chau	F	1.4
368	HKG	English	T	2.2
369	HKG	Fukien	F	1.9
370	HKG	Hakka	F	1.6
371	HND	Creole English	F	0.2
372	HND	Garifuna	F	1.3
373	HND	Miskito	F	0.2
374	HND	Spanish	T	97.2
375	HRV	Serbo-Croatian	T	95.9
376	HRV	Slovene	F	0.0
377	HTI	French	T	0.0
378	HTI	Haiti Creole	F	100.0
379	HUN	German	F	0.4
380	HUN	Hungarian	T	98.5
381	HUN	Romani	F	0.5
382	HUN	Romanian	F	0.1
383	HUN	Serbo-Croatian	F	0.2
384	HUN	Slovak	F	0.1
385	IDN	Bali	F	1.7
386	IDN	Banja	F	1.8
387	IDN	Batakki	F	2.2
388	IDN	Bugi	F	2.2
389	IDN	Javanese	F	39.4
390	IDN	Madura	F	4.3
391	IDN	Malay	T	12.1
392	IDN	Minangkabau	F	2.4
393	IDN	Sunda	F	15.8
394	IND	Asami	F	1.5
395	IND	Bengali	F	8.2
396	IND	Gujarati	F	4.8
397	IND	Hindi	T	39.9
398	IND	Kannada	F	3.9
399	IND	Malajalam	F	3.6
400	IND	Marathi	F	7.4
401	IND	Orija	F	3.3
402	IND	Punjabi	F	2.8
403	IND	Tamil	F	6.3
404	IND	Telugu	F	7.8
405	IND	Urdu	F	5.1
406	IRL	English	T	98.4
407	IRL	Irish	T	1.6
408	IRN	Arabic	F	2.2
409	IRN	Azerbaijani	F	16.8
410	IRN	Bakhtyari	F	1.7
411	IRN	Balochi	F	2.3
412	IRN	Gilaki	F	5.3
413	IRN	Kurdish	F	9.1
414	IRN	Luri	F	4.3
415	IRN	Mazandarani	F	3.6
416	IRN	Persian	T	45.7
417	IRN	Turkmenian	F	1.6
418	IRQ	Arabic	T	77.2
419	IRQ	Assyrian	F	0.8
420	IRQ	Azerbaijani	F	1.7
421	IRQ	Kurdish	F	19.0
422	IRQ	Persian	F	0.8
423	ISL	English	F	0.0
424	ISL	Icelandic	T	95.7
425	ISR	Arabic	T	18.0
426	ISR	Hebrew	T	63.1
427	ISR	Russian	F	8.9
428	ITA	Albaniana	F	0.2
429	ITA	French	F	0.5
430	ITA	Friuli	F	1.2
431	ITA	German	F	0.5
432	ITA	Italian	T	94.1
433	ITA	Romani	F	0.2
434	ITA	Sardinian	F	2.7
435	ITA	Slovene	F	0.2
436	JAM	Creole English	F	94.2
437	JAM	Hindi	F	1.9
438	JOR	Arabic	T	97.9
439	JOR	Armenian	F	1.0
440	JOR	Circassian	F	1.0
441	JPN	Ainu	F	0.0
442	JPN	Chinese	F	0.2
443	JPN	English	F	0.1
444	JPN	Japanese	T	99.1
445	JPN	Korean	F	0.5
446	JPN	Philippene Languages	F	0.1
447	KAZ	German	F	3.1
448	KAZ	Kazakh	T	46.0
449	KAZ	Russian	F	34.7
450	KAZ	Tatar	F	2.0
451	KAZ	Ukrainian	F	5.0
452	KAZ	Uzbek	F	2.3
453	KEN	Gusii	F	6.1
454	KEN	Kalenjin	F	10.8
455	KEN	Kamba	F	11.2
456	KEN	Kikuyu	F	20.9
457	KEN	Luhya	F	13.8
458	KEN	Luo	F	12.8
459	KEN	Masai	F	1.6
460	KEN	Meru	F	5.5
461	KEN	Nyika	F	4.8
462	KEN	Turkana	F	1.4
463	KGZ	Kazakh	F	0.8
464	KGZ	Kirgiz	T	59.7
465	KGZ	Russian	T	16.2
466	KGZ	Tadzhik	F	0.8
467	KGZ	Tatar	F	1.3
468	KGZ	Ukrainian	F	1.7
469	KGZ	Uzbek	F	14.1
470	KHM	Chinese	F	3.1
471	KHM	Khmer	T	88.6
472	KHM	Tšam	F	2.4
473	KHM	Vietnamese	F	5.5
474	KIR	Kiribati	T	98.9
475	KIR	Tuvalu	F	0.5
476	KNA	Creole English	F	100.0
477	KNA	English	T	0.0
478	KOR	Chinese	F	0.1
479	KOR	Korean	T	99.9
480	KWT	Arabic	T	78.1
481	KWT	English	F	0.0
482	LAO	Lao	T	67.2
483	LAO	Lao-Soung	F	5.2
484	LAO	Mon-khmer	F	16.5
485	LAO	Thai	F	7.8
486	LBN	Arabic	T	93.0
487	LBN	Armenian	F	5.9
488	LBN	French	F	0.0
489	LBR	Bassa	F	13.7
490	LBR	Gio	F	7.9
491	LBR	Grebo	F	8.9
492	LBR	Kpelle	F	19.5
493	LBR	Kru	F	7.2
494	LBR	Loma	F	5.8
495	LBR	Malinke	F	5.1
496	LBR	Mano	F	7.2
497	LBY	Arabic	T	96.0
498	LBY	Berberi	F	1.0
499	LCA	Creole French	F	80.0
500	LCA	English	T	20.0
501	LIE	German	T	89.0
502	LIE	Italian	F	2.5
503	LIE	Turkish	F	2.5
504	LKA	Mixed Languages	F	19.6
505	LKA	Singali	T	60.3
506	LKA	Tamil	T	19.6
507	LSO	English	T	0.0
508	LSO	Sotho	T	85.0
509	LSO	Zulu	F	15.0
510	LTU	Belorussian	F	1.4
511	LTU	Lithuanian	T	81.6
512	LTU	Polish	F	7.0
513	LTU	Russian	F	8.1
514	LTU	Ukrainian	F	1.1
515	LUX	French	T	4.2
516	LUX	German	T	2.3
517	LUX	Italian	F	4.6
518	LUX	Luxembourgish	T	64.4
519	LUX	Portuguese	F	13.0
520	LVA	Belorussian	F	4.1
521	LVA	Latvian	T	55.1
522	LVA	Lithuanian	F	1.2
523	LVA	Polish	F	2.1
524	LVA	Russian	F	32.5
525	LVA	Ukrainian	F	2.9
526	MAC	Canton Chinese	F	85.6
527	MAC	English	F	0.5
528	MAC	Mandarin Chinese	F	1.2
529	MAC	Portuguese	T	2.3
530	MAR	Arabic	T	65.0
531	MAR	Berberi	F	33.0
532	MCO	English	F	6.5
533	MCO	French	T	41.9
534	MCO	Italian	F	16.1
535	MCO	Monegasque	F	16.1
536	MDA	Bulgariana	F	1.6
537	MDA	Gagauzi	F	3.2
538	MDA	Romanian	T	61.9
539	MDA	Russian	F	23.2
540	MDA	Ukrainian	F	8.6
541	MDG	French	T	0.0
542	MDG	Malagasy	T	98.9
543	MDV	Dhivehi	T	100.0
544	MDV	English	F	0.0
545	MEX	Mixtec	F	0.6
546	MEX	Náhuatl	F	1.8
547	MEX	Otomí	F	0.4
548	MEX	Spanish	T	92.1
549	MEX	Yucatec	F	1.1
550	MEX	Zapotec	F	0.6
551	MHL	English	T	0.0
552	MHL	Marshallese	T	96.8
553	MKD	Albaniana	F	22.9
554	MKD	Macedonian	T	66.5
555	MKD	Romani	F	2.3
556	MKD	Serbo-Croatian	F	2.0
557	MKD	Turkish	F	4.0
558	MLI	Bambara	F	31.8
559	MLI	Ful	F	13.9
560	MLI	Senufo and Minianka	F	12.0
561	MLI	Songhai	F	6.9
562	MLI	Soninke	F	8.7
563	MLI	Tamashek	F	7.3
564	MLT	English	T	2.1
565	MLT	Maltese	T	95.8
566	MMR	Burmese	T	69.0
567	MMR	Chin	F	2.2
568	MMR	Kachin	F	1.4
569	MMR	Karen	F	6.2
570	MMR	Kayah	F	0.4
571	MMR	Mon	F	2.4
572	MMR	Rakhine	F	4.5
573	MMR	Shan	F	8.5
574	MNG	Bajad	F	1.9
575	MNG	Buryat	F	1.7
576	MNG	Dariganga	F	1.4
577	MNG	Dorbet	F	2.7
578	MNG	Kazakh	F	5.9
579	MNG	Mongolian	T	78.8
580	MNP	Carolinian	F	4.8
581	MNP	Chamorro	F	30.0
582	MNP	Chinese	F	7.1
583	MNP	English	T	4.8
584	MNP	Korean	F	6.5
585	MNP	Philippene Languages	F	34.1
586	MOZ	Chuabo	F	5.7
587	MOZ	Lomwe	F	7.8
588	MOZ	Makua	F	27.8
589	MOZ	Marendje	F	3.5
590	MOZ	Nyanja	F	3.3
591	MOZ	Ronga	F	3.7
592	MOZ	Sena	F	9.4
593	MOZ	Shona	F	6.5
594	MOZ	Tsonga	F	12.4
595	MOZ	Tswa	F	6.0
596	MRT	Ful	F	1.2
597	MRT	Hassaniya	F	81.7
598	MRT	Soninke	F	2.7
599	MRT	Tukulor	F	5.4
600	MRT	Wolof	F	6.6
601	MRT	Zenaga	F	1.2
602	MSR	English	T	0.0
603	MTQ	Creole French	F	96.6
604	MTQ	French	T	0.0
605	MUS	Bhojpuri	F	21.1
606	MUS	Creole French	F	70.6
607	MUS	French	F	3.4
608	MUS	Hindi	F	1.2
609	MUS	Marathi	F	0.7
610	MUS	Tamil	F	0.8
611	MWI	Chichewa	T	58.3
612	MWI	Lomwe	F	18.4
613	MWI	Ngoni	F	6.7
614	MWI	Yao	F	13.2
615	MYS	Chinese	F	9.0
616	MYS	Dusun	F	1.1
617	MYS	English	F	1.6
618	MYS	Iban	F	2.8
619	MYS	Malay	T	58.4
620	MYS	Tamil	F	3.9
621	MYT	French	T	20.3
622	MYT	Mahoré	F	41.9
623	MYT	Malagasy	F	16.1
624	NAM	Afrikaans	F	9.5
625	NAM	Caprivi	F	4.7
626	NAM	German	F	0.9
627	NAM	Herero	F	8.0
628	NAM	Kavango	F	9.7
629	NAM	Nama	F	12.4
630	NAM	Ovambo	F	50.7
631	NAM	San	F	1.9
632	NCL	French	T	34.3
633	NCL	Malenasian Languages	F	45.4
634	NCL	Polynesian Languages	F	11.6
635	NER	Ful	F	9.7
636	NER	Hausa	F	53.1
637	NER	Kanuri	F	4.4
638	NER	Songhai-zerma	F	21.2
639	NER	Tamashek	F	10.4
640	NFK	English	T	0.0
641	NGA	Bura	F	1.6
642	NGA	Edo	F	3.3
643	NGA	Ful	F	11.3
644	NGA	Hausa	F	21.1
645	NGA	Ibibio	F	5.6
646	NGA	Ibo	F	18.1
647	NGA	Ijo	F	1.8
648	NGA	Joruba	F	21.4
649	NGA	Kanuri	F	4.1
650	NGA	Tiv	F	2.3
651	NIC	Creole English	F	0.5
652	NIC	Miskito	F	1.6
653	NIC	Spanish	T	97.6
654	NIC	Sumo	F	0.2
655	NIU	English	T	0.0
656	NIU	Niue	F	0.0
657	NLD	Arabic	F	0.9
658	NLD	Dutch	T	95.6
659	NLD	Fries	F	3.7
660	NLD	Turkish	F	0.8
661	NOR	Danish	F	0.4
662	NOR	English	F	0.5
663	NOR	Norwegian	T	96.6
664	NOR	Saame	F	0.0
665	NOR	Swedish	F	0.3
666	NPL	Bhojpuri	F	7.5
667	NPL	Hindi	F	3.0
668	NPL	Maithili	F	11.9
669	NPL	Nepali	T	50.4
670	NPL	Newari	F	3.7
671	NPL	Tamang	F	4.9
672	NPL	Tharu	F	5.4
673	NRU	Chinese	F	8.5
674	NRU	English	T	7.5
675	NRU	Kiribati	F	17.9
676	NRU	Nauru	T	57.5
677	NRU	Tuvalu	F	8.5
678	NZL	English	T	87.0
679	NZL	Maori	F	4.3
680	OMN	Arabic	T	76.7
681	OMN	Balochi	F	0.0
682	PAK	Balochi	F	3.0
683	PAK	Brahui	F	1.2
684	PAK	Hindko	F	2.4
685	PAK	Pashto	F	13.1
686	PAK	Punjabi	F	48.2
687	PAK	Saraiki	F	9.8
688	PAK	Sindhi	F	11.8
689	PAK	Urdu	T	7.6
690	PAN	Arabic	F	0.6
691	PAN	Creole English	F	14.0
692	PAN	Cuna	F	2.0
693	PAN	Embera	F	0.6
694	PAN	Guaymí	F	5.3
695	PAN	Spanish	T	76.8
696	PCN	Pitcairnese	F	0.0
697	PER	Aimará	T	2.3
698	PER	Ketšua	T	16.4
699	PER	Spanish	T	79.8
700	PHL	Bicol	F	5.7
701	PHL	Cebuano	F	23.3
702	PHL	Hiligaynon	F	9.1
703	PHL	Ilocano	F	9.3
704	PHL	Maguindanao	F	1.4
705	PHL	Maranao	F	1.3
706	PHL	Pampango	F	3.0
707	PHL	Pangasinan	F	1.8
708	PHL	Pilipino	T	29.3
709	PHL	Waray-waray	F	3.8
710	PLW	Chinese	F	1.6
711	PLW	English	T	3.2
712	PLW	Palau	T	82.2
713	PLW	Philippene Languages	F	9.2
714	PNG	Malenasian Languages	F	20.0
715	PNG	Papuan Languages	F	78.1
716	POL	Belorussian	F	0.5
717	POL	German	F	1.3
718	POL	Polish	T	97.6
719	POL	Ukrainian	F	0.6
720	PRI	English	F	47.4
721	PRI	Spanish	T	51.3
722	PRK	Chinese	F	0.1
723	PRK	Korean	T	99.9
724	PRT	Portuguese	T	99.0
725	PRY	German	F	0.9
726	PRY	Guaraní	T	40.1
727	PRY	Portuguese	F	3.2
728	PRY	Spanish	T	55.1
729	PSE	Arabic	F	95.9
730	PSE	Hebrew	F	4.1
731	PYF	Chinese	F	2.9
732	PYF	French	T	40.8
733	PYF	Tahitian	F	46.4
734	QAT	Arabic	T	40.7
735	QAT	Urdu	F	0.0
736	REU	Chinese	F	2.8
737	REU	Comorian	F	2.8
738	REU	Creole French	F	91.5
739	REU	Malagasy	F	1.4
740	REU	Tamil	F	0.0
741	ROM	German	F	0.4
742	ROM	Hungarian	F	7.2
743	ROM	Romani	T	0.7
744	ROM	Romanian	T	90.7
745	ROM	Serbo-Croatian	F	0.1
746	ROM	Ukrainian	F	0.3
747	RUS	Avarian	F	0.4
748	RUS	Bashkir	F	0.7
749	RUS	Belorussian	F	0.3
750	RUS	Chechen	F	0.6
751	RUS	Chuvash	F	0.9
752	RUS	Kazakh	F	0.4
753	RUS	Mari	F	0.4
754	RUS	Mordva	F	0.5
755	RUS	Russian	T	86.6
756	RUS	Tatar	F	3.2
757	RUS	Udmur	F	0.3
758	RUS	Ukrainian	F	1.3
759	RWA	French	T	0.0
760	RWA	Rwanda	T	100.0
761	SAU	Arabic	T	95.0
762	SDN	Arabic	T	49.4
763	SDN	Bari	F	2.5
764	SDN	Beja	F	6.4
765	SDN	Chilluk	F	1.7
766	SDN	Dinka	F	11.5
767	SDN	Fur	F	2.1
768	SDN	Lotuko	F	1.5
769	SDN	Nubian Languages	F	8.1
770	SDN	Nuer	F	4.9
771	SDN	Zande	F	2.7
772	SEN	Diola	F	5.0
773	SEN	Ful	F	21.7
774	SEN	Malinke	F	3.8
775	SEN	Serer	F	12.5
776	SEN	Soninke	F	1.3
777	SEN	Wolof	T	48.1
778	SGP	Chinese	T	77.1
779	SGP	Malay	T	14.1
780	SGP	Tamil	T	7.4
781	SHN	English	T	0.0
782	SJM	Norwegian	T	0.0
783	SJM	Russian	F	0.0
784	SLB	Malenasian Languages	F	85.6
785	SLB	Papuan Languages	F	8.6
786	SLB	Polynesian Languages	F	3.8
787	SLE	Bullom-sherbro	F	3.8
788	SLE	Ful	F	3.8
789	SLE	Kono-vai	F	5.1
790	SLE	Kuranko	F	3.4
791	SLE	Limba	F	8.3
792	SLE	Mende	F	34.8
793	SLE	Temne	F	31.8
794	SLE	Yalunka	F	3.4
795	SLV	Nahua	F	0.0
796	SLV	Spanish	T	100.0
797	SMR	Italian	T	100.0
798	SOM	Arabic	T	0.0
799	SOM	Somali	T	98.3
800	SPM	French	T	0.0
801	STP	Crioulo	F	86.3
802	STP	French	F	0.7
803	SUR	Hindi	F	0.0
804	SUR	Sranantonga	F	81.0
805	SVK	Czech and Moravian	F	1.1
806	SVK	Hungarian	F	10.5
807	SVK	Romani	F	1.7
808	SVK	Slovak	T	85.6
809	SVK	Ukrainian and Russian	F	0.6
810	SVN	Hungarian	F	0.5
811	SVN	Serbo-Croatian	F	7.9
812	SVN	Slovene	T	87.9
813	SWE	Arabic	F	0.8
814	SWE	Finnish	F	2.4
815	SWE	Norwegian	F	0.5
816	SWE	Southern Slavic Languages	F	1.3
817	SWE	Spanish	F	0.6
818	SWE	Swedish	T	89.5
819	SWZ	Swazi	T	89.9
820	SWZ	Zulu	F	2.0
821	SYC	English	T	3.8
822	SYC	French	T	1.3
823	SYC	Seselwa	F	91.3
824	SYR	Arabic	T	90.0
825	SYR	Kurdish	F	9.0
826	TCA	English	T	0.0
827	TCD	Arabic	T	12.3
828	TCD	Gorane	F	6.2
829	TCD	Hadjarai	F	6.7
830	TCD	Kanem-bornu	F	9.0
831	TCD	Mayo-kebbi	F	11.5
832	TCD	Ouaddai	F	8.7
833	TCD	Sara	F	27.7
834	TCD	Tandjile	F	6.5
835	TGO	Ane	F	5.7
836	TGO	Ewe	T	23.2
837	TGO	Gurma	F	3.4
838	TGO	Kabyé	T	13.8
839	TGO	Kotokoli	F	5.7
840	TGO	Moba	F	5.4
841	TGO	Naudemba	F	4.1
842	TGO	Watyi	F	10.3
843	THA	Chinese	F	12.1
844	THA	Khmer	F	1.3
845	THA	Kuy	F	1.1
846	THA	Lao	F	26.9
847	THA	Malay	F	3.6
848	THA	Thai	T	52.6
849	TJK	Russian	F	9.7
850	TJK	Tadzhik	T	62.2
851	TJK	Uzbek	F	23.2
852	TKL	English	T	0.0
853	TKL	Tokelau	F	0.0
854	TKM	Kazakh	F	2.0
855	TKM	Russian	F	6.7
856	TKM	Turkmenian	T	76.7
857	TKM	Uzbek	F	9.2
858	TMP	Portuguese	T	0.0
859	TMP	Sunda	F	0.0
860	TON	English	T	0.0
861	TON	Tongan	T	98.3
862	TTO	Creole English	F	2.9
863	TTO	English	F	93.5
864	TTO	Hindi	F	3.4
865	TUN	Arabic	T	69.9
866	TUN	Arabic-French	F	26.3
867	TUN	Arabic-French-English	F	3.2
868	TUR	Arabic	F	1.4
869	TUR	Kurdish	F	10.6
870	TUR	Turkish	T	87.6
871	TUV	English	T	0.0
872	TUV	Kiribati	F	7.5
873	TUV	Tuvalu	T	92.5
874	TWN	Ami	F	0.6
875	TWN	Atayal	F	0.4
876	TWN	Hakka	F	11.0
877	TWN	Mandarin Chinese	T	20.1
878	TWN	Min	F	66.7
879	TWN	Paiwan	F	0.3
880	TZA	Chaga and Pare	F	4.9
881	TZA	Gogo	F	3.9
882	TZA	Ha	F	3.5
883	TZA	Haya	F	5.9
884	TZA	Hehet	F	6.9
885	TZA	Luguru	F	4.9
886	TZA	Makonde	F	5.9
887	TZA	Nyakusa	F	5.4
888	TZA	Nyamwesi	F	21.1
889	TZA	Shambala	F	4.3
890	TZA	Swahili	T	8.8
891	UGA	Acholi	F	4.4
892	UGA	Ganda	F	18.1
893	UGA	Gisu	F	4.5
894	UGA	Kiga	F	8.3
895	UGA	Lango	F	5.9
896	UGA	Lugbara	F	4.7
897	UGA	Nkole	F	10.7
898	UGA	Rwanda	F	3.2
899	UGA	Soga	F	8.2
900	UGA	Teso	F	6.0
901	UKR	Belorussian	F	0.3
902	UKR	Bulgariana	F	0.3
903	UKR	Hungarian	F	0.3
904	UKR	Polish	F	0.1
905	UKR	Romanian	F	0.7
906	UKR	Russian	F	32.9
907	UKR	Ukrainian	T	64.7
908	UMI	English	T	0.0
909	URY	Spanish	T	95.7
910	USA	Chinese	F	0.6
911	USA	English	T	86.2
912	USA	French	F	0.7
913	USA	German	F	0.7
914	USA	Italian	F	0.6
915	USA	Japanese	F	0.2
916	USA	Korean	F	0.3
917	USA	Polish	F	0.3
918	USA	Portuguese	F	0.2
919	USA	Spanish	F	7.5
920	USA	Tagalog	F	0.4
921	USA	Vietnamese	F	0.2
922	UZB	Karakalpak	F	2.0
923	UZB	Kazakh	F	3.8
924	UZB	Russian	F	10.9
925	UZB	Tadzhik	F	4.4
926	UZB	Tatar	F	1.8
927	UZB	Uzbek	T	72.6
928	VAT	Italian	T	0.0
929	VCT	Creole English	F	99.1
930	VCT	English	T	0.0
931	VEN	Goajiro	F	0.4
932	VEN	Spanish	T	96.9
933	VEN	Warrau	F	0.1
934	VGB	English	T	0.0
935	VIR	English	T	81.7
936	VIR	French	F	2.5
937	VIR	Spanish	F	13.3
938	VNM	Chinese	F	1.4
939	VNM	Khmer	F	1.4
940	VNM	Man	F	0.7
941	VNM	Miao	F	0.9
942	VNM	Muong	F	1.5
943	VNM	Nung	F	1.1
944	VNM	Thai	F	1.6
945	VNM	Tho	F	1.8
946	VNM	Vietnamese	T	86.8
947	VUT	Bislama	T	56.6
948	VUT	English	T	28.3
949	VUT	French	T	14.2
950	WLF	Futuna	F	0.0
951	WLF	Wallis	F	0.0
952	WSM	English	T	0.6
953	WSM	Samoan	T	47.5
954	WSM	Samoan-English	F	52.0
955	YEM	Arabic	T	99.6
956	YEM	Soqutri	F	0.0
957	YUG	Albaniana	F	16.5
958	YUG	Hungarian	F	3.4
959	YUG	Macedonian	F	0.5
960	YUG	Romani	F	1.4
961	YUG	Serbo-Croatian	T	75.2
962	YUG	Slovak	F	0.7
963	ZAF	Afrikaans	T	14.3
964	ZAF	English	T	8.5
965	ZAF	Ndebele	F	1.5
966	ZAF	Northsotho	F	9.1
967	ZAF	Southsotho	F	7.6
968	ZAF	Swazi	F	2.5
969	ZAF	Tsonga	F	4.3
970	ZAF	Tswana	F	8.1
971	ZAF	Venda	F	2.2
972	ZAF	Xhosa	T	17.7
973	ZAF	Zulu	T	22.7
974	ZMB	Bemba	F	29.7
975	ZMB	Chewa	F	5.7
976	ZMB	Lozi	F	6.4
977	ZMB	Nsenga	F	4.3
978	ZMB	Nyanja	F	7.8
979	ZMB	Tonga	F	11.0
980	ZWE	English	T	2.2
981	ZWE	Ndebele	F	16.2
982	ZWE	Nyanja	F	2.2
983	ZWE	Shona	F	72.1

Consultas Básicas

1. Selección de países en el continente “Asia”

Álgebra relacional:

\[ \sigma_{\text{Continent} = 'Asia'}(\text{Country}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name FROM country WHERE Continent="Asia";

	Name
0	Afghanistan
1	United Arab Emirates
2	Armenia
3	Azerbaijan
4	Bangladesh
5	Bahrain
6	Brunei
7	Bhutan
8	China
9	Cyprus
10	Georgia
11	Hong Kong
12	Indonesia
13	India
14	Iran
15	Iraq
16	Israel
17	Jordan
18	Japan
19	Kazakstan
20	Kyrgyzstan
21	Cambodia
22	South Korea
23	Kuwait
24	Laos
25	Lebanon
26	Sri Lanka
27	Macao
28	Maldives
29	Myanmar
30	Mongolia
31	Malaysia
32	Nepal
33	Oman
34	Pakistan
35	Philippines
36	North Korea
37	Palestine
38	Qatar
39	Saudi Arabia
40	Singapore
41	Syria
42	Thailand
43	Tajikistan
44	Turkmenistan
45	East Timor
46	Turkey
47	Taiwan
48	Uzbekistan
49	Vietnam
50	Yemen

2. Contar el número total de ciudades

Álgebra relacional:

\[ \text{COUNT}(\text{City}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT DISTINCT COUNT(Name) AS Total_Cities FROM city;

	Total_Cities
0	4079

3. Listar todos los idiomas únicos en la tabla CountryLanguage

Álgebra relacional:

\[ \pi_{\text{Language}}(\text{CountryLanguage}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT DISTINCT Language FROM countrylanguage ORDER BY Language ASC;

	Language
0	[South]Mande
1	Abhyasi
2	Acholi
3	Adja
4	Afar
5	Afrikaans
6	Aimará
7	Ainu
8	Aizo
9	Akan
10	Albaniana
11	Ambo
12	Amhara
13	Ami
14	Ane
15	Arabic
16	Arabic-French
17	Arabic-French-English
18	Araucan
19	Arawakan
20	Armenian
21	Asami
22	Assyrian
23	Atayal
24	Avarian
25	Azerbaijani
26	Bajad
27	Bajan
28	Bakhtyari
29	Balante
30	Bali
31	Balochi
32	Bambara
33	Bamileke-bamum
34	Banda
35	Banja
36	Bari
37	Bariba
38	Bashkir
39	Basque
40	Bassa
41	Batakki
42	Beja
43	Belorussian
44	Bemba
45	Bengali
46	Berberi
47	Bhojpuri
48	Bicol
49	Bilin
50	Bislama
51	Boa
52	Brahui
53	Bubi
54	Bugi
55	Bulgariana
56	Bullom-sherbro
57	Bura
58	Burmese
59	Buryat
60	Busansi
61	Cakchiquel
62	Canton Chinese
63	Caprivi
64	Caribbean
65	Carolinian
66	Catalan
67	Cebuano
68	Chaga and Pare
69	Chakma
70	Chamorro
71	Chechen
72	Chewa
73	Chibcha
74	Chichewa
75	Chilluk
76	Chin
77	Chinese
78	Chiu chau
79	Chokwe
80	Chuabo
81	Chuvash
82	Circassian
83	Comorian
84	Comorian-Arabic
85	Comorian-French
86	Comorian-madagassi
87	Comorian-Swahili
88	Creole English
89	Creole French
90	Crioulo
91	Cuna
92	Czech
93	Czech and Moravian
94	Dagara
95	Danish
96	Dari
97	Dariganga
98	Dhivehi
99	Dinka
100	Diola
101	Dong
102	Dorbet
103	Duala
104	Dusun
105	Dutch
106	Dyula
107	Dzongkha
108	Edo
109	Embera
110	English
111	Eskimo Languages
112	Estonian
113	Ewe
114	Fang
115	Faroese
116	Fijian
117	Finnish
118	Fon
119	French
120	Fries
121	Friuli
122	Fukien
123	Ful
124	Fur
125	Futuna
126	Ga-adangme
127	Gaeli
128	Gagauzi
129	Galecian
130	Ganda
131	Garifuna
132	Garo
133	Gbaya
134	Georgiana
135	German
136	Gilaki
137	Gio
138	Gisu
139	Goajiro
140	Gogo
141	Gorane
142	Grebo
143	Greek
144	Greenlandic
145	Guaraní
146	Guaymí
147	Gujarati
148	Gur
149	Gurage
150	Gurma
151	Gusii
152	Ha
153	Hadareb
154	Hadjarai
155	Haiti Creole
156	Hakka
157	Hassaniya
158	Hausa
159	Haya
160	Hebrew
161	Hehet
162	Herero
163	Hiligaynon
164	Hindi
165	Hindko
166	Hui
167	Hungarian
168	Iban
169	Ibibio
170	Ibo
171	Icelandic
172	Ijo
173	Ilocano
174	Indian Languages
175	Irish
176	Italian
177	Japanese
178	Javanese
179	Joruba
180	Kabyé
181	Kachin
182	Kalenjin
183	Kamba
184	Kanem-bornu
185	Kannada
186	Kanuri
187	Karakalpak
188	Karen
189	Kavango
190	Kayah
191	Kazakh
192	Kekchí
193	Ketšua
194	Khasi
195	Khmer
196	Khoekhoe
197	Kiga
198	Kikuyu
199	Kirgiz
200	Kiribati
201	Kirundi
202	Kissi
203	Kongo
204	Kono-vai
205	Korean
206	Kosrean
207	Kotokoli
208	Kpelle
209	Kru
210	Kuranko
211	Kurdish
212	Kuy
213	Kymri
214	Lango
215	Lao
216	Lao-Soung
217	Latvian
218	Lezgian
219	Limba
220	Lithuanian
221	Loma
222	Lomwe
223	Lotuko
224	Lozi
225	Luba
226	Luchazi
227	Lugbara
228	Luguru
229	Luhya
230	Luimbe-nganguela
231	Luo
232	Luri
233	Luvale
234	Luxembourgish
235	Macedonian
236	Madura
237	Maguindanao
238	Mahoré
239	Maithili
240	Maka
241	Makonde
242	Makua
243	Malagasy
244	Malajalam
245	Malay
246	Malay-English
247	Malenasian Languages
248	Malinke
249	Maltese
250	Mam
251	Man
252	Mandara
253	Mandarin Chinese
254	Mandjia
255	Mandyako
256	Mano
257	Mantšu
258	Maori
259	Maranao
260	Marathi
261	Marendje
262	Mari
263	Marma
264	Marshallese
265	Masai
266	Masana
267	Maya Languages
268	Mayo-kebbi
269	Mazandarani
270	Mbete
271	Mboshi
272	Mbum
273	Mbundu
274	Mende
275	Meru
276	Miao
277	Min
278	Minangkabau
279	Miskito
280	Mixed Languages
281	Mixtec
282	Moba
283	Mon
284	Mon-khmer
285	Monegasque
286	Mongo
287	Mongolian
288	Moravian
289	Mordva
290	Mortlock
291	Mossi
292	Mpongwe
293	Muong
294	Nahua
295	Náhuatl
296	Nama
297	Naudemba
298	Nauru
299	Ndebele
300	Nepali
301	Newari
302	Ngala and Bangi
303	Ngbaka
304	Ngoni
305	Niue
306	Nkole
307	Northsotho
308	Norwegian
309	Nsenga
310	Nubian Languages
311	Nuer
312	Nung
313	Nyakusa
314	Nyamwesi
315	Nyaneka-nkhumbi
316	Nyanja
317	Nyika
318	Orija
319	Oromo
320	Osseetti
321	Otomí
322	Ouaddai
323	Ovambo
324	Ovimbundu
325	Paiwan
326	Palau
327	Pampango
328	Pangasinan
329	Papiamento
330	Papuan Languages
331	Pashto
332	Persian
333	Philippene Languages
334	Pilipino
335	Pitcairnese
336	Pohnpei
337	Polish
338	Polynesian Languages
339	Portuguese
340	Punjabi
341	Punu
342	Punu-sira-nzebi
343	Puyi
344	Quiché
345	Rakhine
346	Rapa nui
347	Romani
348	Romanian
349	Romansh
350	Ronga
351	Rundi
352	Russian
353	Rwanda
354	Saame
355	Saho
356	Samoan
357	Samoan-English
358	San
359	Sango
360	Santhali
361	Sara
362	Saraiki
363	Sardinian
364	Sena
365	Senufo and Minianka
366	Serbo-Croatian
367	Serer
368	Seselwa
369	Shambala
370	Shan
371	Shona
372	Sidamo
373	Silesiana
374	Sinaberberi
375	Sindhi
376	Singali
377	Slovak
378	Slovene
379	Soga
380	Somali
381	Somba
382	Songhai
383	Songhai-zerma
384	Soninke
385	Soqutri
386	Sotho
387	Southern Slavic Languages
388	Southsotho
389	Spanish
390	Sranantonga
391	Sumo
392	Sunda
393	Susu
394	Swahili
395	Swazi
396	Swedish
397	Tadzhik
398	Tagalog
399	Tahitian
400	Tamang
401	Tamashek
402	Tamil
403	Tandjile
404	Tatar
405	Teke
406	Telugu
407	Temne
408	Teso
409	Thai
410	Tharu
411	Tho
412	Tibetan
413	Tigre
414	Tigrinja
415	Tikar
416	Tiv
417	Tokelau
418	Tonga
419	Tongan
420	Tripuri
421	Trukese
422	Tšam
423	Tsonga
424	Tswa
425	Tswana
426	Tujia
427	Tukulor
428	Turkana
429	Turkish
430	Turkmenian
431	Tuvalu
432	Udmur
433	Uighur
434	Ukrainian
435	Ukrainian and Russian
436	Urdu
437	Uzbek
438	Venda
439	Vietnamese
440	Walaita
441	Wallis
442	Waray-waray
443	Warrau
444	Watyi
445	Wolea
446	Wolof
447	Xhosa
448	Yalunka
449	Yao
450	Yap
451	Yi
452	Yucatec
453	Zande
454	Zapotec
455	Zenaga
456	Zhuang
457	Zulu

4. Selección de países con población mayor a 100 millones

Álgebra relacional:

\[ \sigma_{\text{Population} > 100000000 }(\text{Country}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name,Population  FROM country 
WHERE Population>100e6
ORDER BY Population DESC;

	Name	Population
0	China	1277558000
1	India	1013662000
2	United States	278357000
3	Indonesia	212107000
4	Brazil	170115000
5	Pakistan	156483000
6	Russian Federation	146934000
7	Bangladesh	129155000
8	Japan	126714000
9	Nigeria	111506000

5. Listar nombres de países y continentes ordenados alfabéticamente por nombre de país

Álgebra relacional:

\[ \pi_{\text{Name}, \text{Continent}}(\text{Country}) \text{ ORDER BY Name} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, Continent FROM country 
ORDER BY Name ASC;

	Name	Continent
0	Afghanistan	Asia
1	Albania	Europe
2	Algeria	Africa
3	American Samoa	Oceania
4	Andorra	Europe
5	Angola	Africa
6	Anguilla	North America
7	Antarctica	Antarctica
8	Antigua and Barbuda	North America
9	Argentina	South America
10	Armenia	Asia
11	Aruba	North America
12	Australia	Oceania
13	Austria	Europe
14	Azerbaijan	Asia
15	Bahamas	North America
16	Bahrain	Asia
17	Bangladesh	Asia
18	Barbados	North America
19	Belarus	Europe
20	Belgium	Europe
21	Belize	North America
22	Benin	Africa
23	Bermuda	North America
24	Bhutan	Asia
25	Bolivia	South America
26	Bosnia and Herzegovina	Europe
27	Botswana	Africa
28	Bouvet Island	Antarctica
29	Brazil	South America
30	British Indian Ocean Territory	Africa
31	Brunei	Asia
32	Bulgaria	Europe
33	Burkina Faso	Africa
34	Burundi	Africa
35	Cambodia	Asia
36	Cameroon	Africa
37	Canada	North America
38	Cape Verde	Africa
39	Cayman Islands	North America
40	Central African Republic	Africa
41	Chad	Africa
42	Chile	South America
43	China	Asia
44	Christmas Island	Oceania
45	Cocos (Keeling) Islands	Oceania
46	Colombia	South America
47	Comoros	Africa
48	Congo	Africa
49	Congo, The Democratic Republic of the	Africa
50	Cook Islands	Oceania
51	Costa Rica	North America
52	Côte d’Ivoire	Africa
53	Croatia	Europe
54	Cuba	North America
55	Cyprus	Asia
56	Czech Republic	Europe
57	Denmark	Europe
58	Djibouti	Africa
59	Dominica	North America
60	Dominican Republic	North America
61	East Timor	Asia
62	Ecuador	South America
63	Egypt	Africa
64	El Salvador	North America
65	Equatorial Guinea	Africa
66	Eritrea	Africa
67	Estonia	Europe
68	Ethiopia	Africa
69	Falkland Islands	South America
70	Faroe Islands	Europe
71	Fiji Islands	Oceania
72	Finland	Europe
73	France	Europe
74	French Guiana	South America
75	French Polynesia	Oceania
76	French Southern territories	Antarctica
77	Gabon	Africa
78	Gambia	Africa
79	Georgia	Asia
80	Germany	Europe
81	Ghana	Africa
82	Gibraltar	Europe
83	Greece	Europe
84	Greenland	North America
85	Grenada	North America
86	Guadeloupe	North America
87	Guam	Oceania
88	Guatemala	North America
89	Guinea	Africa
90	Guinea-Bissau	Africa
91	Guyana	South America
92	Haiti	North America
93	Heard Island and McDonald Islands	Antarctica
94	Holy See (Vatican City State)	Europe
95	Honduras	North America
96	Hong Kong	Asia
97	Hungary	Europe
98	Iceland	Europe
99	India	Asia
100	Indonesia	Asia
101	Iran	Asia
102	Iraq	Asia
103	Ireland	Europe
104	Israel	Asia
105	Italy	Europe
106	Jamaica	North America
107	Japan	Asia
108	Jordan	Asia
109	Kazakstan	Asia
110	Kenya	Africa
111	Kiribati	Oceania
112	Kuwait	Asia
113	Kyrgyzstan	Asia
114	Laos	Asia
115	Latvia	Europe
116	Lebanon	Asia
117	Lesotho	Africa
118	Liberia	Africa
119	Libyan Arab Jamahiriya	Africa
120	Liechtenstein	Europe
121	Lithuania	Europe
122	Luxembourg	Europe
123	Macao	Asia
124	Macedonia	Europe
125	Madagascar	Africa
126	Malawi	Africa
127	Malaysia	Asia
128	Maldives	Asia
129	Mali	Africa
130	Malta	Europe
131	Marshall Islands	Oceania
132	Martinique	North America
133	Mauritania	Africa
134	Mauritius	Africa
135	Mayotte	Africa
136	Mexico	North America
137	Micronesia, Federated States of	Oceania
138	Moldova	Europe
139	Monaco	Europe
140	Mongolia	Asia
141	Montserrat	North America
142	Morocco	Africa
143	Mozambique	Africa
144	Myanmar	Asia
145	Namibia	Africa
146	Nauru	Oceania
147	Nepal	Asia
148	Netherlands	Europe
149	Netherlands Antilles	North America
150	New Caledonia	Oceania
151	New Zealand	Oceania
152	Nicaragua	North America
153	Niger	Africa
154	Nigeria	Africa
155	Niue	Oceania
156	Norfolk Island	Oceania
157	North Korea	Asia
158	Northern Mariana Islands	Oceania
159	Norway	Europe
160	Oman	Asia
161	Pakistan	Asia
162	Palau	Oceania
163	Palestine	Asia
164	Panama	North America
165	Papua New Guinea	Oceania
166	Paraguay	South America
167	Peru	South America
168	Philippines	Asia
169	Pitcairn	Oceania
170	Poland	Europe
171	Portugal	Europe
172	Puerto Rico	North America
173	Qatar	Asia
174	Réunion	Africa
175	Romania	Europe
176	Russian Federation	Europe
177	Rwanda	Africa
178	Saint Helena	Africa
179	Saint Kitts and Nevis	North America
180	Saint Lucia	North America
181	Saint Pierre and Miquelon	North America
182	Saint Vincent and the Grenadines	North America
183	Samoa	Oceania
184	San Marino	Europe
185	Sao Tome and Principe	Africa
186	Saudi Arabia	Asia
187	Senegal	Africa
188	Seychelles	Africa
189	Sierra Leone	Africa
190	Singapore	Asia
191	Slovakia	Europe
192	Slovenia	Europe
193	Solomon Islands	Oceania
194	Somalia	Africa
195	South Africa	Africa
196	South Georgia and the South Sandwich Islands	Antarctica
197	South Korea	Asia
198	Spain	Europe
199	Sri Lanka	Asia
200	Sudan	Africa
201	Suriname	South America
202	Svalbard and Jan Mayen	Europe
203	Swaziland	Africa
204	Sweden	Europe
205	Switzerland	Europe
206	Syria	Asia
207	Taiwan	Asia
208	Tajikistan	Asia
209	Tanzania	Africa
210	Thailand	Asia
211	Togo	Africa
212	Tokelau	Oceania
213	Tonga	Oceania
214	Trinidad and Tobago	North America
215	Tunisia	Africa
216	Turkey	Asia
217	Turkmenistan	Asia
218	Turks and Caicos Islands	North America
219	Tuvalu	Oceania
220	Uganda	Africa
221	Ukraine	Europe
222	United Arab Emirates	Asia
223	United Kingdom	Europe
224	United States	North America
225	United States Minor Outlying Islands	Oceania
226	Uruguay	South America
227	Uzbekistan	Asia
228	Vanuatu	Oceania
229	Venezuela	South America
230	Vietnam	Asia
231	Virgin Islands, British	North America
232	Virgin Islands, U.S.	North America
233	Wallis and Futuna	Oceania
234	Western Sahara	Africa
235	Yemen	Asia
236	Yugoslavia	Europe
237	Zambia	Africa
238	Zimbabwe	Africa

6. Obtener la ciudad con mayor población

Álgebra relacional:

\[ \text{MAX}(\pi_{\text{Population}}(\text{City})) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, Population FROM city 
ORDER BY Population DESC LIMIT 1;
-- otra opción usando MAX()
SELECT Name, Population FROM city
WHERE Population=(SELECT MAX(Population) FROM city);

	Name	Population
0	Mumbai (Bombay)	10500000

7. Selección de países que tienen “Republic” en su nombre

Álgebra relacional:

\[ \sigma_{\text{Name LIKE '\%Republic\%'}}(\text{Country}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name FROM country 
WHERE Name LIKE "%%Republic%%";

	Name
0	Central African Republic
1	Congo, The Democratic Republic of the
2	Czech Republic
3	Dominican Republic

8. Listar los 5 países más poblados

Álgebra relacional:

\[ \pi_{\text{Name, Population}}(\text{Country}) \text{ ORDER BY Population DESC LIMIT 5} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name,Population FROM country
ORDER BY Population DESC LIMIT 5;

	Name	Population
0	China	1277558000
1	India	1013662000
2	United States	278357000
3	Indonesia	212107000
4	Brazil	170115000

9. Calcular la población promedio de los países en el continente “Europe”

Álgebra relacional:

\[ \text{AVG}(\pi_{\text{Population}}(\sigma_{\text{Continent} = 'Europe'}(\text{Country}))) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT AVG(Population) AS AVG_Poblacion_Europa
FROM country WHERE Continent="Europe";

	AVG_Poblacion_Europa
0	1.587119e+07

10. Selección de idiomas con más del 10% de la población mundial que los habla

Álgebra relacional:

\[ \sigma_{\text{Percentage} > 10}(\text{CountryLanguage}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Language, SUM(Population * (Percentage / 100)) AS TotalSpeakers
FROM country
JOIN countrylanguage ON country.Code = countrylanguage.CountryCode
GROUP BY Language
HAVING TotalSpeakers > (SELECT SUM(Population) FROM country) * 0.1
ORDER BY TotalSpeakers DESC;

	Language	TotalSpeakers
0	Chinese	1.191844e+09

Consultas de Nivel Medio

1. Encontrar los 5 países más poblados por continente

Álgebra relacional:

\[ \pi_{\text{Name, Population}}(\text{Country}) \text{ GROUP BY Continent ORDER BY Population DESC LIMIT 5} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Continent, Name  AS Country, Population
FROM country c1
WHERE (
    SELECT COUNT(*)
    FROM country c2
    WHERE c2.Continent = c1.Continent
      AND c2.Population > c1.Population
) < 5
ORDER BY Continent, Population DESC;
-- otra forma usando ROW_NUMBER
SELECT Continent, Name AS Country, Population
FROM (
    SELECT Continent, Name, Population,
           ROW_NUMBER() OVER (PARTITION BY Continent ORDER BY Population DESC) AS rn
    FROM country
) AS ranked
WHERE rn <= 5
ORDER BY Continent, Population DESC;

	Continent	Country	Population
0	Asia	China	1277558000
1	Asia	India	1013662000
2	Asia	Indonesia	212107000
3	Asia	Pakistan	156483000
4	Asia	Bangladesh	129155000
5	Europe	Russian Federation	146934000
6	Europe	Germany	82164700
7	Europe	United Kingdom	59623400
8	Europe	France	59225700
9	Europe	Italy	57680000
10	North America	United States	278357000
11	North America	Mexico	98881000
12	North America	Canada	31147000
13	North America	Guatemala	11385000
14	North America	Cuba	11201000
15	Africa	Nigeria	111506000
16	Africa	Egypt	68470000
17	Africa	Ethiopia	62565000
18	Africa	Congo, The Democratic Republic of the	51654000
19	Africa	South Africa	40377000
20	Oceania	Australia	18886000
21	Oceania	Papua New Guinea	4807000
22	Oceania	New Zealand	3862000
23	Oceania	Fiji Islands	817000
24	Oceania	Solomon Islands	444000
25	Antarctica	French Southern territories	0
26	Antarctica	South Georgia and the South Sandwich Islands	0
27	Antarctica	Heard Island and McDonald Islands	0
28	Antarctica	Bouvet Island	0
29	Antarctica	Antarctica	0
30	South America	Brazil	170115000
31	South America	Colombia	42321000
32	South America	Argentina	37032000
33	South America	Peru	25662000
34	South America	Venezuela	24170000

2. Listar países que usan más de un idioma

Álgebra relacional:

\[ \sigma_{\text{count(Language)} > 1}(\text{CountryLanguage GROUP BY CountryCode}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, CountryCode, COUNT(Language) AS NoLanguages FROM countrylanguage 
LEFT JOIN country on countrylanguage.CountryCode = country.Code
GROUP BY CountryCode HAVING COUNT(Language)>1;

	Name	CountryCode	NoLanguages
0	Aruba	ABW	4
1	Afghanistan	AFG	5
2	Angola	AGO	9
3	Albania	ALB	3
4	Andorra	AND	4
5	Netherlands Antilles	ANT	3
6	United Arab Emirates	ARE	2
7	Argentina	ARG	3
8	Armenia	ARM	2
9	American Samoa	ASM	3
10	Antigua and Barbuda	ATG	2
11	Australia	AUS	8
12	Austria	AUT	8
13	Azerbaijan	AZE	4
14	Burundi	BDI	3
15	Belgium	BEL	6
16	Benin	BEN	7
17	Burkina Faso	BFA	6
18	Bangladesh	BGD	7
19	Bulgaria	BGR	4
20	Bahrain	BHR	2
21	Bahamas	BHS	2
22	Belarus	BLR	4
23	Belize	BLZ	4
24	Bolivia	BOL	4
25	Brazil	BRA	5
26	Barbados	BRB	2
27	Brunei	BRN	4
28	Bhutan	BTN	3
29	Botswana	BWA	5
30	Central African Republic	CAF	6
31	Canada	CAN	12
32	Cocos (Keeling) Islands	CCK	2
33	Switzerland	CHE	4
34	Chile	CHL	4
35	China	CHN	12
36	Côte d’Ivoire	CIV	5
37	Cameroon	CMR	8
38	Congo, The Democratic Republic of the	COD	10
39	Congo	COG	6
40	Cook Islands	COK	2
41	Colombia	COL	5
42	Comoros	COM	5
43	Cape Verde	CPV	2
44	Costa Rica	CRI	4
45	Christmas Island	CXR	2
46	Cyprus	CYP	2
47	Czech Republic	CZE	8
48	Germany	DEU	6
49	Djibouti	DJI	3
50	Dominica	DMA	2
51	Denmark	DNK	7
52	Dominican Republic	DOM	2
53	Algeria	DZA	2
54	Ecuador	ECU	2
55	Egypt	EGY	2
56	Eritrea	ERI	6
57	Spain	ESP	4
58	Estonia	EST	5
59	Ethiopia	ETH	7
60	Finland	FIN	5
61	Fiji Islands	FJI	2
62	France	FRA	6
63	Faroe Islands	FRO	2
64	Micronesia, Federated States of	FSM	6
65	Gabon	GAB	4
66	United Kingdom	GBR	3
67	Georgia	GEO	6
68	Ghana	GHA	6
69	Gibraltar	GIB	2
70	Guinea	GIN	7
71	Guadeloupe	GLP	2
72	Gambia	GMB	5
73	Guinea-Bissau	GNB	6
74	Equatorial Guinea	GNQ	2
75	Greece	GRC	2
76	Greenland	GRL	2
77	Guatemala	GTM	5
78	French Guiana	GUF	2
79	Guam	GUM	5
80	Guyana	GUY	3
81	Hong Kong	HKG	5
82	Honduras	HND	4
83	Croatia	HRV	2
84	Haiti	HTI	2
85	Hungary	HUN	6
86	Indonesia	IDN	9
87	India	IND	12
88	Ireland	IRL	2
89	Iran	IRN	10
90	Iraq	IRQ	5
91	Iceland	ISL	2
92	Israel	ISR	3
93	Italy	ITA	8
94	Jamaica	JAM	2
95	Jordan	JOR	3
96	Japan	JPN	6
97	Kazakstan	KAZ	6
98	Kenya	KEN	10
99	Kyrgyzstan	KGZ	7
100	Cambodia	KHM	4
101	Kiribati	KIR	2
102	Saint Kitts and Nevis	KNA	2
103	South Korea	KOR	2
104	Kuwait	KWT	2
105	Laos	LAO	4
106	Lebanon	LBN	3
107	Liberia	LBR	8
108	Libyan Arab Jamahiriya	LBY	2
109	Saint Lucia	LCA	2
110	Liechtenstein	LIE	3
111	Sri Lanka	LKA	3
112	Lesotho	LSO	3
113	Lithuania	LTU	5
114	Luxembourg	LUX	5
115	Latvia	LVA	6
116	Macao	MAC	4
117	Morocco	MAR	2
118	Monaco	MCO	4
119	Moldova	MDA	5
120	Madagascar	MDG	2
121	Maldives	MDV	2
122	Mexico	MEX	6
123	Marshall Islands	MHL	2
124	Macedonia	MKD	5
125	Mali	MLI	6
126	Malta	MLT	2
127	Myanmar	MMR	8
128	Mongolia	MNG	6
129	Northern Mariana Islands	MNP	6
130	Mozambique	MOZ	10
131	Mauritania	MRT	6
132	Martinique	MTQ	2
133	Mauritius	MUS	6
134	Malawi	MWI	4
135	Malaysia	MYS	6
136	Mayotte	MYT	3
137	Namibia	NAM	8
138	New Caledonia	NCL	3
139	Niger	NER	5
140	Nigeria	NGA	10
141	Nicaragua	NIC	4
142	Niue	NIU	2
143	Netherlands	NLD	4
144	Norway	NOR	5
145	Nepal	NPL	7
146	Nauru	NRU	5
147	New Zealand	NZL	2
148	Oman	OMN	2
149	Pakistan	PAK	8
150	Panama	PAN	6
151	Peru	PER	3
152	Philippines	PHL	10
153	Palau	PLW	4
154	Papua New Guinea	PNG	2
155	Poland	POL	4
156	Puerto Rico	PRI	2
157	North Korea	PRK	2
158	Paraguay	PRY	4
159	Palestine	PSE	2
160	French Polynesia	PYF	3
161	Qatar	QAT	2
162	Réunion	REU	5
163	Romania	ROM	6
164	Russian Federation	RUS	12
165	Rwanda	RWA	2
166	Sudan	SDN	10
167	Senegal	SEN	6
168	Singapore	SGP	3
169	Svalbard and Jan Mayen	SJM	2
170	Solomon Islands	SLB	3
171	Sierra Leone	SLE	8
172	El Salvador	SLV	2
173	Somalia	SOM	2
174	Sao Tome and Principe	STP	2
175	Suriname	SUR	2
176	Slovakia	SVK	5
177	Slovenia	SVN	3
178	Sweden	SWE	6
179	Swaziland	SWZ	2
180	Seychelles	SYC	3
181	Syria	SYR	2
182	Chad	TCD	8
183	Togo	TGO	8
184	Thailand	THA	6
185	Tajikistan	TJK	3
186	Tokelau	TKL	2
187	Turkmenistan	TKM	4
188	East Timor	TMP	2
189	Tonga	TON	2
190	Trinidad and Tobago	TTO	3
191	Tunisia	TUN	3
192	Turkey	TUR	3
193	Tuvalu	TUV	3
194	Taiwan	TWN	6
195	Tanzania	TZA	11
196	Uganda	UGA	10
197	Ukraine	UKR	7
198	United States	USA	12
199	Uzbekistan	UZB	6
200	Saint Vincent and the Grenadines	VCT	2
201	Venezuela	VEN	3
202	Virgin Islands, U.S.	VIR	3
203	Vietnam	VNM	9
204	Vanuatu	VUT	3
205	Wallis and Futuna	WLF	2
206	Samoa	WSM	3
207	Yemen	YEM	2
208	Yugoslavia	YUG	6
209	South Africa	ZAF	11
210	Zambia	ZMB	6
211	Zimbabwe	ZWE	4

3. Calcular el total de población de cada continente

Álgebra relacional:

\[ \pi_{\text{Continent}, \text{SUM(Population)}}(\text{Country}) \text{ GROUP BY Continent} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Continent, SUM(Population) AS TotalPoblacion
FROM country 
GROUP BY Continent ORDER BY Continent ASC;

	Continent	TotalPoblacion
0	Asia	3.705026e+09
1	Europe	7.300746e+08
2	North America	4.829930e+08
3	Africa	7.844750e+08
4	Oceania	3.040115e+07
5	Antarctica	0.000000e+00
6	South America	3.457800e+08

4. Contar el número de ciudades en cada país

Álgebra relacional:

\[ \pi_{\text{CountryCode}, \text{COUNT(*)}}(\text{City}) \text{ GROUP BY CountryCode} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT country.Name, CountryCode, COUNT(*) AS NoCities 
FROM city 
LEFT JOIN country ON city.CountryCode = country.Code 
GROUP BY CountryCode ORDER BY NoCities ASC;

	Name	CountryCode	NoCities
0	Aruba	ABW	1
1	Albania	ALB	1
2	Andorra	AND	1
3	Netherlands Antilles	ANT	1
4	Antigua and Barbuda	ATG	1
5	Burundi	BDI	1
6	Bahrain	BHR	1
7	Bahamas	BHS	1
8	Barbados	BRB	1
9	Brunei	BRN	1
10	Bhutan	BTN	1
11	Central African Republic	CAF	1
12	Cook Islands	COK	1
13	Comoros	COM	1
14	Cape Verde	CPV	1
15	Costa Rica	CRI	1
16	Christmas Island	CXR	1
17	Cayman Islands	CYM	1
18	Djibouti	DJI	1
19	Dominica	DMA	1
20	Eritrea	ERI	1
21	Western Sahara	ESH	1
22	Fiji Islands	FJI	1
23	Falkland Islands	FLK	1
24	Faroe Islands	FRO	1
25	Gabon	GAB	1
26	Gibraltar	GIB	1
27	Guinea	GIN	1
28	Guinea-Bissau	GNB	1
29	Equatorial Guinea	GNQ	1
30	Grenada	GRD	1
31	Greenland	GRL	1
32	French Guiana	GUF	1
33	Guyana	GUY	1
34	Iceland	ISL	1
35	Saint Kitts and Nevis	KNA	1
36	Liberia	LBR	1
37	Saint Lucia	LCA	1
38	Lesotho	LSO	1
39	Luxembourg	LUX	1
40	Macao	MAC	1
41	Maldives	MDV	1
42	Marshall Islands	MHL	1
43	Macedonia	MKD	1
44	Mali	MLI	1
45	Mongolia	MNG	1
46	Northern Mariana Islands	MNP	1
47	Montserrat	MSR	1
48	Martinique	MTQ	1
49	Mayotte	MYT	1
50	Namibia	NAM	1
51	New Caledonia	NCL	1
52	Norfolk Island	NFK	1
53	Niue	NIU	1
54	Pitcairn	PCN	1
55	Palau	PLW	1
56	Papua New Guinea	PNG	1
57	Qatar	QAT	1
58	Réunion	REU	1
59	Rwanda	RWA	1
60	Singapore	SGP	1
61	Saint Helena	SHN	1
62	Svalbard and Jan Mayen	SJM	1
63	Solomon Islands	SLB	1
64	Sierra Leone	SLE	1
65	Saint Pierre and Miquelon	SPM	1
66	Sao Tome and Principe	STP	1
67	Suriname	SUR	1
68	Swaziland	SWZ	1
69	Seychelles	SYC	1
70	Turks and Caicos Islands	TCA	1
71	Togo	TGO	1
72	Tokelau	TKL	1
73	East Timor	TMP	1
74	Tonga	TON	1
75	Tuvalu	TUV	1
76	Uganda	UGA	1
77	Uruguay	URY	1
78	Holy See (Vatican City State)	VAT	1
79	Saint Vincent and the Grenadines	VCT	1
80	Virgin Islands, British	VGB	1
81	Virgin Islands, U.S.	VIR	1
82	Vanuatu	VUT	1
83	Wallis and Futuna	WLF	1
84	Samoa	WSM	1
85	Anguilla	AIA	2
86	American Samoa	ASM	2
87	Belize	BLZ	2
88	Bermuda	BMU	2
89	Botswana	BWA	2
90	Cocos (Keeling) Islands	CCK	2
91	Congo	COG	2
92	Cyprus	CYP	2
93	Estonia	EST	2
94	Micronesia, Federated States of	FSM	2
95	Guadeloupe	GLP	2
96	Gambia	GMB	2
97	Guam	GUM	2
98	Hong Kong	HKG	2
99	Ireland	IRL	2
100	Kyrgyzstan	KGZ	2
101	Kiribati	KIR	2
102	Laos	LAO	2
103	Lebanon	LBN	2
104	Liechtenstein	LIE	2
105	Monaco	MCO	2
106	Malta	MLT	2
107	Mauritania	MRT	2
108	Malawi	MWI	2
109	Nauru	NRU	2
110	Panama	PAN	2
111	French Polynesia	PYF	2
112	San Marino	SMR	2
113	Slovenia	SVN	2
114	Chad	TCD	2
115	Tajikistan	TJK	2
116	Trinidad and Tobago	TTO	2
117	Armenia	ARM	3
118	Burkina Faso	BFA	3
119	Bosnia and Herzegovina	BIH	3
120	Honduras	HND	3
121	Jamaica	JAM	3
122	Cambodia	KHM	3
123	Kuwait	KWT	3
124	Latvia	LVA	3
125	Mauritius	MUS	3
126	Niger	NER	3
127	Somalia	SOM	3
128	Slovakia	SVK	3
129	Afghanistan	AFG	4
130	Azerbaijan	AZE	4
131	Benin	BEN	4
132	Guatemala	GTM	4
133	Croatia	HRV	4
134	Haiti	HTI	4
135	Libyan Arab Jamahiriya	LBY	4
136	Moldova	MDA	4
137	Nicaragua	NIC	4
138	Turkmenistan	TKM	4
139	Angola	AGO	5
140	United Arab Emirates	ARE	5
141	Switzerland	CHE	5
142	Côte d’Ivoire	CIV	5
143	Denmark	DNK	5
144	Georgia	GEO	5
145	Ghana	GHA	5
146	Jordan	JOR	5
147	Lithuania	LTU	5
148	Madagascar	MDG	5
149	Norway	NOR	5
150	Nepal	NPL	5
151	Oman	OMN	5
152	Portugal	PRT	5
153	Paraguay	PRY	5
154	Austria	AUT	6
155	Dominican Republic	DOM	6
156	Palestine	PSE	6
157	Yemen	YEM	6
158	Zimbabwe	ZWE	6
159	Cameroon	CMR	7
160	Ethiopia	ETH	7
161	Finland	FIN	7
162	Sri Lanka	LKA	7
163	El Salvador	SLV	7
164	Zambia	ZMB	7
165	Bolivia	BOL	8
166	Greece	GRC	8
167	Kenya	KEN	8
168	Tunisia	TUN	8
169	Yugoslavia	YUG	8
170	Belgium	BEL	9
171	Hungary	HUN	9
172	New Zealand	NZL	9
173	Puerto Rico	PRI	9
174	Senegal	SEN	9
175	Bulgaria	BGR	10
176	Czech Republic	CZE	10
177	Tanzania	TZA	10
178	Syria	SYR	11
179	Mozambique	MOZ	12
180	Sudan	SDN	12
181	Thailand	THA	12
182	North Korea	PRK	13
183	Australia	AUS	14
184	Cuba	CUB	14
185	Israel	ISR	14
186	Ecuador	ECU	15
187	Iraq	IRQ	15
188	Sweden	SWE	15
189	Belarus	BLR	16
190	Myanmar	MMR	16
191	Uzbekistan	UZB	17
192	Congo, The Democratic Republic of the	COD	18
193	Algeria	DZA	18
194	Malaysia	MYS	18
195	Kazakstan	KAZ	21
196	Morocco	MAR	22
197	Peru	PER	22
198	Vietnam	VNM	22
199	Bangladesh	BGD	24
200	Saudi Arabia	SAU	24
201	Netherlands	NLD	28
202	Chile	CHL	29
203	Romania	ROM	29
204	Egypt	EGY	37
205	Colombia	COL	38
206	France	FRA	40
207	Venezuela	VEN	41
208	Taiwan	TWN	42
209	Poland	POL	44
210	South Africa	ZAF	44
211	Canada	CAN	49
212	Argentina	ARG	57
213	Ukraine	UKR	57
214	Italy	ITA	58
215	Spain	ESP	59
216	Pakistan	PAK	59
217	Turkey	TUR	62
218	Nigeria	NGA	64
219	Iran	IRN	67
220	South Korea	KOR	70
221	United Kingdom	GBR	81
222	Indonesia	IDN	85
223	Germany	DEU	93
224	Philippines	PHL	136
225	Mexico	MEX	173
226	Russian Federation	RUS	189
227	Japan	JPN	248
228	Brazil	BRA	250
229	United States	USA	274
230	India	IND	341
231	China	CHN	363

5. Listar los países y su promedio de vida ordenados por el promedio de vida en orden descendente

Álgebra relacional:

\[ \pi_{\text{Name}, \text{LifeExpectancy}}(\text{Country}) \text{ ORDER BY LifeExpectancy DESC} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, LifeExpectancy FROM country
ORDER BY LifeExpectancy DESC;

	Name	LifeExpectancy
0	Andorra	83.5
1	Macao	81.6
2	San Marino	81.1
3	Japan	80.7
4	Singapore	80.1
5	Australia	79.8
6	Switzerland	79.6
7	Sweden	79.6
8	Hong Kong	79.5
9	Canada	79.4
10	Iceland	79.4
11	Gibraltar	79.0
12	Italy	79.0
13	Cayman Islands	78.9
14	Spain	78.8
15	France	78.8
16	Liechtenstein	78.8
17	Monaco	78.8
18	Norway	78.7
19	Israel	78.6
20	Aruba	78.4
21	Faroe Islands	78.4
22	Greece	78.4
23	Martinique	78.3
24	Netherlands	78.3
25	Virgin Islands, U.S.	78.1
26	Montserrat	78.0
27	Malta	77.9
28	Belgium	77.8
29	Guam	77.8
30	New Zealand	77.8
31	Austria	77.7
32	United Kingdom	77.7
33	Saint Pierre and Miquelon	77.6
34	Germany	77.4
35	Finland	77.4
36	Jordan	77.4
37	Luxembourg	77.1
38	United States	77.1
39	Guadeloupe	77.0
40	Bermuda	76.9
41	Ireland	76.8
42	Saint Helena	76.8
43	Cyprus	76.7
44	Denmark	76.5
45	Taiwan	76.4
46	Cuba	76.2
47	Anguilla	76.1
48	French Guiana	76.1
49	Kuwait	76.1
50	Costa Rica	75.8
51	Portugal	75.8
52	Chile	75.7
53	Puerto Rico	75.6
54	Libyan Arab Jamahiriya	75.5
55	Northern Mariana Islands	75.5
56	Panama	75.5
57	Virgin Islands, British	75.4
58	Jamaica	75.2
59	Uruguay	75.2
60	Argentina	75.1
61	American Samoa	75.1
62	Slovenia	74.9
63	French Polynesia	74.8
64	Netherlands Antilles	74.7
65	Czech Republic	74.5
66	South Korea	74.4
67	United Arab Emirates	74.1
68	Macedonia	73.8
69	Croatia	73.7
70	Paraguay	73.7
71	Slovakia	73.7
72	Tunisia	73.7
73	Brunei	73.6
74	Dominica	73.4
75	Turks and Caicos Islands	73.3
76	Dominican Republic	73.2
77	Poland	73.2
78	Venezuela	73.1
79	Bahrain	73.0
80	Barbados	73.0
81	New Caledonia	72.8
82	Réunion	72.7
83	Qatar	72.4
84	Yugoslavia	72.4
85	Saint Lucia	72.3
86	Saint Vincent and the Grenadines	72.3
87	Sri Lanka	71.8
88	Oman	71.8
89	Albania	71.6
90	Bosnia and Herzegovina	71.5
91	Mexico	71.5
92	China	71.4
93	Hungary	71.4
94	Palestine	71.4
95	Suriname	71.4
96	Lebanon	71.3
97	Solomon Islands	71.3
98	Bahamas	71.1
99	Cook Islands	71.1
100	Ecuador	71.1
101	Mauritius	71.0
102	Turkey	71.0
103	Bulgaria	70.9
104	Belize	70.9
105	Malaysia	70.8
106	Saint Kitts and Nevis	70.7
107	North Korea	70.7
108	Antigua and Barbuda	70.5
109	Seychelles	70.4
110	Colombia	70.3
111	Peru	70.0
112	Honduras	69.9
113	Romania	69.9
114	Algeria	69.7
115	Iran	69.7
116	El Salvador	69.7
117	Estonia	69.5
118	Vietnam	69.3
119	Samoa	69.2
120	Lithuania	69.1
121	Morocco	69.1
122	Cape Verde	68.9
123	Nicaragua	68.7
124	Micronesia, Federated States of	68.6
125	Palau	68.6
126	Thailand	68.6
127	Syria	68.5
128	Latvia	68.4
129	Greenland	68.1
130	Belarus	68.0
131	Indonesia	68.0
132	Trinidad and Tobago	68.0
133	Fiji Islands	67.9
134	Tonga	67.9
135	Saudi Arabia	67.8
136	Philippines	67.5
137	Mongolia	67.3
138	Russian Federation	67.2
139	Iraq	66.5
140	Armenia	66.4
141	Tuvalu	66.3
142	Guatemala	66.2
143	Ukraine	66.0
144	Marshall Islands	65.5
145	Sao Tome and Principe	65.3
146	Georgia	64.5
147	Grenada	64.5
148	Moldova	64.5
149	Tajikistan	64.1
150	Guyana	64.0
151	Bolivia	63.7
152	Uzbekistan	63.7
153	Kyrgyzstan	63.4
154	Egypt	63.3
155	Kazakstan	63.2
156	Papua New Guinea	63.1
157	Azerbaijan	62.9
158	Brazil	62.9
159	India	62.5
160	Maldives	62.2
161	Senegal	62.2
162	Pakistan	61.1
163	Turkmenistan	60.9
164	Nauru	60.8
165	Vanuatu	60.6
166	Bangladesh	60.2
167	Comoros	60.0
168	Kiribati	59.8
169	Yemen	59.8
170	Mayotte	59.5
171	Nepal	57.8
172	Ghana	57.4
173	Sudan	56.6
174	Cambodia	56.5
175	Eritrea	55.8
176	Madagascar	55.0
177	Myanmar	54.9
178	Cameroon	54.8
179	Togo	54.7
180	Equatorial Guinea	53.6
181	Gambia	53.2
182	Laos	53.1
183	Bhutan	52.4
184	Tanzania	52.3
185	Nigeria	51.6
186	South Africa	51.1
187	Liberia	51.0
188	Djibouti	50.8
189	Lesotho	50.8
190	Mauritania	50.8
191	Chad	50.5
192	Benin	50.2
193	Gabon	50.1
194	Western Sahara	49.8
195	Haiti	49.2
196	Guinea-Bissau	49.0
197	Congo, The Democratic Republic of the	48.8
198	Kenya	48.0
199	Congo	47.4
200	Burkina Faso	46.7
201	Mali	46.7
202	Burundi	46.2
203	Somalia	46.2
204	East Timor	46.0
205	Afghanistan	45.9
206	Guinea	45.6
207	Sierra Leone	45.3
208	Côte d’Ivoire	45.2
209	Ethiopia	45.2
210	Central African Republic	44.0
211	Uganda	42.9
212	Namibia	42.5
213	Niger	41.3
214	Swaziland	40.4
215	Botswana	39.3
216	Rwanda	39.3
217	Angola	38.3
218	Zimbabwe	37.8
219	Malawi	37.6
220	Mozambique	37.5
221	Zambia	37.2
222	Antarctica	NaN
223	French Southern territories	NaN
224	Bouvet Island	NaN
225	Cocos (Keeling) Islands	NaN
226	Christmas Island	NaN
227	Falkland Islands	NaN
228	Heard Island and McDonald Islands	NaN
229	British Indian Ocean Territory	NaN
230	Norfolk Island	NaN
231	Niue	NaN
232	Pitcairn	NaN
233	South Georgia and the South Sandwich Islands	NaN
234	Svalbard and Jan Mayen	NaN
235	Tokelau	NaN
236	United States Minor Outlying Islands	NaN
237	Holy See (Vatican City State)	NaN
238	Wallis and Futuna	NaN

6. Selección de ciudades cuya población está entre 500,000 y 1,000,000

Álgebra relacional:

\[ \sigma_{500000 \leq \text{Population} \leq 1000000}(\text{City}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, Population FROM city
WHERE Population BETWEEN 500000 AND 1000000
ORDER BY Name;

	Name	Population
0	Acapulco de Juárez	721011
1	Adelaide	978100
2	Agra	891790
3	Aguascalientes	643360
4	Ahvaz	804980
5	Allahabad	792858
6	Almirante Brown	538918
7	Amman	1000000
8	Amoy [Xiamen]	627500
9	Amritsar	708835
10	Amsterdam	731200
11	Ansan	510314
12	Antalya	564914
13	Antananarivo	675669
14	Anyang	591106
15	Arequipa	762000
16	Ashgabat	540600
17	Asunción	557776
18	Athenai	772072
19	Austin	656562
20	Baltimore	651154
21	Bamako	809552
22	Bandar Lampung	680332
23	Bangui	524000
24	Baotou	980000
25	Bareilly	587211
26	Barnaul	580100
27	Barquisimeto	877239
28	Bekasi	644300
29	Bengasi	804000
30	Benxi	770000
31	Bishkek	589400
32	Boston	589141
33	Brazzaville	950000
34	Bremen	540330
35	Bucaramanga	515555
36	Bulawayo	621742
37	Calgary	768082
38	Campinas	950043
39	Campo Grande	649593
40	Cartagena	805757
41	Cebu	718821
42	Centro (Villahermosa)	519873
43	Chandigarh	504094
44	Changzhou	530000
45	Charlotte	540828
46	Chiba	863930
47	Chiclayo	517000
48	Chihuahua	670208
49	Chisinau	719900
50	Chongjin	582480
51	Chongju	531376
52	Chonju	563153
53	Ciudad de Guatemala	823301
54	Ciudad Guayana	663713
55	Cochin (Kochi)	564589
56	Coimbatore	816321
57	Colombo	645000
58	Columbus	711470
59	Contagem	520801
60	Cotonou	536827
61	Cúcuta	606932
62	Culiacán	744859
63	Dakar	785071
64	Dandong	520000
65	Daqing	660000
66	Datong	800000
67	Denver	554636
68	Detroit	951270
69	Dortmund	590213
70	Dubai	669181
71	Duisburg	519793
72	Duque de Caxias	746758
73	Durban	566120
74	Dushanbe	524000
75	Düsseldorf	568855
76	Edmonton	616306
77	El Alto	534466
78	El Paso	563662
79	Essen	599515
80	Faridabad	703592
81	Fès	541162
82	Fort Worth	534694
83	Frankfurt am Main	643821
84	Freetown	850000
85	Funabashi	545299
86	Fuxin	640000
87	Gaziantep	789056
88	Genova	636104
89	Glasgow	619680
90	Gorakhpur	505566
91	Guadalupe	668780
92	Guwahati (Gauhati)	584342
93	Gwalior	690765
94	Habarovsk	609400
95	Hachioji	513451
96	Haiphong	783133
97	Hamamatsu	568796
98	Hamhung	709730
99	Handan	840000
100	Hannover	514718
101	Haora (Howrah)	950435
102	Hegang	520000
103	Helsinki [Helsingfors]	555474
104	Hermosillo	608697
105	Higashiosaka	517785
106	Hims	507404
107	Hohhot	916700
108	Huainan	700000
109	Hubli-Dharwad	648298
110	Inanda	634065
111	Indianapolis	791926
112	Irkutsk	593700
113	Islamabad	524500
114	Izevsk	652800
115	Jabalpur	741927
116	Jaboatão dos Guararapes	558680
117	Jacksonville	735167
118	Jalandhar (Jullundur)	509510
119	Jaroslavl	616700
120	Jerusalem	633700
121	Jinzhou	570000
122	Jixi	683885
123	João Pessoa	584029
124	Jodhpur	666279
125	Johannesburg	756653
126	Kagoshima	549977
127	Kaifeng	510000
128	Kampala	890800
129	Kano	674100
130	Karaj	940968
131	Kathmandu	591835
132	Kermanshah	692986
133	Khartum	947483
134	Khulna	663340
135	Köln	962507
136	Konya	628364
137	Kota	537371
138	Koyang	518282
139	Kraków	738150
140	Krasnodar	639000
141	Krasnojarsk	875500
142	Kryvyi Rig	703000
143	Kumamoto	656734
144	La Paz	758141
145	La Plata	521936
146	Lipetsk	521000
147	Lisboa	563210
148	Liuzhou	610000
149	Lódz	800110
150	Lomas de Zamora	622013
151	Lubumbashi	851381
152	Luoyang	760000
153	Lviv	788000
154	Maceió	786288
155	Madurai	977856
156	Málaga	530553
157	Malang	716862
158	Managua	959000
159	Mandalay	885300
160	Mar del Plata	512880
161	Marrakech	621914
162	Marseille	798430
163	Mbuji-Mayi	806475
164	Medina	608300
165	Meerut	753778
166	Mekka	965700
167	Memphis	650100
168	Mérida	703324
169	Mersin (Içel)	587212
170	Mexicali	764902
171	Milwaukee	596974
172	Mississauga	608072
173	Mogadishu	997000
174	Monrovia	850000
175	Morelia	619958
176	Mosul	879000
177	Mudanjiang	570000
178	Mykolajiv	508000
179	N´Djaména	530965
180	Nabereznyje Tšelny	514700
181	Nampo	566200
182	Nashik (Nasik)	656925
183	Nashville-Davidson	569891
184	Natal	688955
185	Naucalpan de Juárez	857511
186	North York	622632
187	Nouakchott	667300
188	Nova Iguaçu	862225
189	Novokuznetsk	561600
190	Ogbomosho	730000
191	Okayama	624269
192	Oklahoma City	506132
193	Oran	609823
194	Orenburg	523600
195	Osasco	659604
196	Oslo	508726
197	Ouagadougou	824000
198	Padang	534474
199	Palermo	683794
200	Panchiao	523850
201	Pasig	505058
202	Patna	917243
203	Penza	532200
204	Peshawar	988005
205	Phnom Penh	570155
206	Pikine	855287
207	Pimpri-Chinchwad	517083
208	Pohang	508899
209	Pointe-Noire	500000
210	Port Elizabeth	752319
211	Port-au-Prince	884472
212	Portland	529121
213	Poznan	576899
214	Pretoria	658630
215	Puchon	779412
216	Qom	777677
217	Querétaro	639839
218	Quetta	560307
219	Quilmes	559249
220	Rabat	623457
221	Rajkot	559407
222	Ranchi	599306
223	Riga	764328
224	Rjazan	529900
225	Rosario	907718
226	Rotterdam	593321
227	Sagamihara	586300
228	Sakai	797735
229	Salé	504420
230	Saltillo	577352
231	San Francisco	776733
232	San Jose	894943
233	San Luis Potosí	669353
234	Sanaa	503600
235	Santa Cruz de la Sierra	935361
236	Santo André	630073
237	São Bernardo do Campo	723132
238	São Gonçalo	869254
239	São José dos Campos	515553
240	São Luís	837588
241	Saratov	874000
242	Scarborough	594501
243	Seattle	563374
244	Sendai	989975
245	Sevilla	701927
246	Shambajinagar (Aurangabad)	573272
247	Shantou	580000
248	Sharq al-Nil	700887
249	Shenzhen	950500
250	Shubra al-Khayma	870716
251	Solapur (Sholapur)	604215
252	Songnam	869094
253	Soweto	904165
254	Srinagar	892506
255	Stockholm	750348
256	Stuttgart	582443
257	Surakarta	518600
258	Suwon	755550
259	Suzhou	710000
260	Taichung	940589
261	Tainan	728060
262	Tanger	521735
263	Tegucigalpa	813900
264	Teresina	691942
265	Thane (Thana)	803389
266	Thiruvananthapuram (Trivandrum	524006
267	Tjumen	503400
268	Tlalnepantla de Baz	720755
269	Toljatti	722900
270	Toluca	665617
271	Torino	903705
272	Toronto	688275
273	Torreón	529093
274	Trujillo	652000
275	Tula	506100
276	Tunis	690600
277	Ulan Bator	773700
278	Uljanovsk	667400
279	Valencia	794246
280	Valencia	739412
281	Vancouver	514008
282	Varanasi (Benares)	929270
283	Vientiane	531800
284	Vijayawada	701827
285	Vilnius	577969
286	Vishakhapatnam	752037
287	Vladivostok	606200
288	Volgograd	993400
289	Voronez	907700
290	Washington	572059
291	Winnipeg	618477
292	Wroclaw	636765
293	Wuxi	830000
294	Xining	700200
295	Xuzhou	810000
296	Yichun	800000
297	Yinchuan	544500
298	Zagreb	706770
299	Zamboanga	601794
300	Zaporizzja	848000
301	Zaragoza	603367
302	Zhangjiakou	530000

7. Listar los idiomas hablados en países donde la población es mayor a 50 millones

Álgebra relacional:

\[ \pi_{\text{Language}}(\sigma_{\text{Population} > 50000000}(\text{Country}) \bowtie \text{CountryLanguage}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT DISTINCT Language, Name FROM countrylanguage 
JOIN country ON countrylanguage.CountryCode=country.Code
WHERE Population>5e6;

	Language	Name
0	Balochi	Afghanistan
1	Dari	Afghanistan
2	Pashto	Afghanistan
3	Turkmenian	Afghanistan
4	Uzbek	Afghanistan
5	Ambo	Angola
6	Chokwe	Angola
7	Kongo	Angola
8	Luchazi	Angola
9	Luimbe-nganguela	Angola
10	Luvale	Angola
11	Mbundu	Angola
12	Nyaneka-nkhumbi	Angola
13	Ovimbundu	Angola
14	Indian Languages	Argentina
15	Italian	Argentina
16	Spanish	Argentina
17	Arabic	Australia
18	Canton Chinese	Australia
19	English	Australia
20	German	Australia
21	Greek	Australia
22	Italian	Australia
23	Serbo-Croatian	Australia
24	Vietnamese	Australia
25	Czech	Austria
26	German	Austria
27	Hungarian	Austria
28	Polish	Austria
29	Romanian	Austria
30	Serbo-Croatian	Austria
31	Slovene	Austria
32	Turkish	Austria
33	Armenian	Azerbaijan
34	Azerbaijani	Azerbaijan
35	Lezgian	Azerbaijan
36	Russian	Azerbaijan
37	French	Burundi
38	Kirundi	Burundi
39	Swahili	Burundi
40	Arabic	Belgium
41	Dutch	Belgium
42	French	Belgium
43	German	Belgium
44	Italian	Belgium
45	Turkish	Belgium
46	Adja	Benin
47	Aizo	Benin
48	Bariba	Benin
49	Fon	Benin
50	Ful	Benin
51	Joruba	Benin
52	Somba	Benin
53	Busansi	Burkina Faso
54	Dagara	Burkina Faso
55	Dyula	Burkina Faso
56	Ful	Burkina Faso
57	Gurma	Burkina Faso
58	Mossi	Burkina Faso
59	Bengali	Bangladesh
60	Chakma	Bangladesh
61	Garo	Bangladesh
62	Khasi	Bangladesh
63	Marma	Bangladesh
64	Santhali	Bangladesh
65	Tripuri	Bangladesh
66	Bulgariana	Bulgaria
67	Macedonian	Bulgaria
68	Romani	Bulgaria
69	Turkish	Bulgaria
70	Belorussian	Belarus
71	Polish	Belarus
72	Russian	Belarus
73	Ukrainian	Belarus
74	Aimará	Bolivia
75	Guaraní	Bolivia
76	Ketšua	Bolivia
77	Spanish	Bolivia
78	German	Brazil
79	Indian Languages	Brazil
80	Italian	Brazil
81	Japanese	Brazil
82	Portuguese	Brazil
83	Chinese	Canada
84	Dutch	Canada
85	English	Canada
86	Eskimo Languages	Canada
87	French	Canada
88	German	Canada
89	Italian	Canada
90	Polish	Canada
91	Portuguese	Canada
92	Punjabi	Canada
93	Spanish	Canada
94	Ukrainian	Canada
95	French	Switzerland
96	German	Switzerland
97	Italian	Switzerland
98	Romansh	Switzerland
99	Aimará	Chile
100	Araucan	Chile
101	Rapa nui	Chile
102	Spanish	Chile
103	Chinese	China
104	Dong	China
105	Hui	China
106	Mantšu	China
107	Miao	China
108	Mongolian	China
109	Puyi	China
110	Tibetan	China
111	Tujia	China
112	Uighur	China
113	Yi	China
114	Zhuang	China
115	[South]Mande	Côte d’Ivoire
116	Akan	Côte d’Ivoire
117	Gur	Côte d’Ivoire
118	Kru	Côte d’Ivoire
119	Malinke	Côte d’Ivoire
120	Bamileke-bamum	Cameroon
121	Duala	Cameroon
122	Fang	Cameroon
123	Ful	Cameroon
124	Maka	Cameroon
125	Mandara	Cameroon
126	Masana	Cameroon
127	Tikar	Cameroon
128	Boa	Congo, The Democratic Republic of the
129	Chokwe	Congo, The Democratic Republic of the
130	Kongo	Congo, The Democratic Republic of the
131	Luba	Congo, The Democratic Republic of the
132	Mongo	Congo, The Democratic Republic of the
133	Ngala and Bangi	Congo, The Democratic Republic of the
134	Rundi	Congo, The Democratic Republic of the
135	Rwanda	Congo, The Democratic Republic of the
136	Teke	Congo, The Democratic Republic of the
137	Zande	Congo, The Democratic Republic of the
138	Arawakan	Colombia
139	Caribbean	Colombia
140	Chibcha	Colombia
141	Creole English	Colombia
142	Spanish	Colombia
143	Spanish	Cuba
144	Czech	Czech Republic
145	German	Czech Republic
146	Hungarian	Czech Republic
147	Moravian	Czech Republic
148	Polish	Czech Republic
149	Romani	Czech Republic
150	Silesiana	Czech Republic
151	Slovak	Czech Republic
152	German	Germany
153	Greek	Germany
154	Italian	Germany
155	Polish	Germany
156	Southern Slavic Languages	Germany
157	Turkish	Germany
158	Arabic	Denmark
159	Danish	Denmark
160	English	Denmark
161	German	Denmark
162	Norwegian	Denmark
163	Swedish	Denmark
164	Turkish	Denmark
165	Creole French	Dominican Republic
166	Spanish	Dominican Republic
167	Arabic	Algeria
168	Berberi	Algeria
169	Ketšua	Ecuador
170	Spanish	Ecuador
171	Arabic	Egypt
172	Sinaberberi	Egypt
173	Basque	Spain
174	Catalan	Spain
175	Galecian	Spain
176	Spanish	Spain
177	Amhara	Ethiopia
178	Gurage	Ethiopia
179	Oromo	Ethiopia
180	Sidamo	Ethiopia
181	Somali	Ethiopia
182	Tigrinja	Ethiopia
183	Walaita	Ethiopia
184	Estonian	Finland
185	Finnish	Finland
186	Russian	Finland
187	Saame	Finland
188	Swedish	Finland
189	Arabic	France
190	French	France
191	Italian	France
192	Portuguese	France
193	Spanish	France
194	Turkish	France
195	English	United Kingdom
196	Gaeli	United Kingdom
197	Kymri	United Kingdom
198	Akan	Ghana
199	Ewe	Ghana
200	Ga-adangme	Ghana
201	Gurma	Ghana
202	Joruba	Ghana
203	Mossi	Ghana
204	Ful	Guinea
205	Kissi	Guinea
206	Kpelle	Guinea
207	Loma	Guinea
208	Malinke	Guinea
209	Susu	Guinea
210	Yalunka	Guinea
211	Greek	Greece
212	Turkish	Greece
213	Cakchiquel	Guatemala
214	Kekchí	Guatemala
215	Mam	Guatemala
216	Quiché	Guatemala
217	Spanish	Guatemala
218	Canton Chinese	Hong Kong
219	Chiu chau	Hong Kong
220	English	Hong Kong
221	Fukien	Hong Kong
222	Hakka	Hong Kong
223	Creole English	Honduras
224	Garifuna	Honduras
225	Miskito	Honduras
226	Spanish	Honduras
227	French	Haiti
228	Haiti Creole	Haiti
229	German	Hungary
230	Hungarian	Hungary
231	Romani	Hungary
232	Romanian	Hungary
233	Serbo-Croatian	Hungary
234	Slovak	Hungary
235	Bali	Indonesia
236	Banja	Indonesia
237	Batakki	Indonesia
238	Bugi	Indonesia
239	Javanese	Indonesia
240	Madura	Indonesia
241	Malay	Indonesia
242	Minangkabau	Indonesia
243	Sunda	Indonesia
244	Asami	India
245	Bengali	India
246	Gujarati	India
247	Hindi	India
248	Kannada	India
249	Malajalam	India
250	Marathi	India
251	Orija	India
252	Punjabi	India
253	Tamil	India
254	Telugu	India
255	Urdu	India
256	Arabic	Iran
257	Azerbaijani	Iran
258	Bakhtyari	Iran
259	Balochi	Iran
260	Gilaki	Iran
261	Kurdish	Iran
262	Luri	Iran
263	Mazandarani	Iran
264	Persian	Iran
265	Turkmenian	Iran
266	Arabic	Iraq
267	Assyrian	Iraq
268	Azerbaijani	Iraq
269	Kurdish	Iraq
270	Persian	Iraq
271	Arabic	Israel
272	Hebrew	Israel
273	Russian	Israel
274	Albaniana	Italy
275	French	Italy
276	Friuli	Italy
277	German	Italy
278	Italian	Italy
279	Romani	Italy
280	Sardinian	Italy
281	Slovene	Italy
282	Arabic	Jordan
283	Armenian	Jordan
284	Circassian	Jordan
285	Ainu	Japan
286	Chinese	Japan
287	English	Japan
288	Japanese	Japan
289	Korean	Japan
290	Philippene Languages	Japan
291	German	Kazakstan
292	Kazakh	Kazakstan
293	Russian	Kazakstan
294	Tatar	Kazakstan
295	Ukrainian	Kazakstan
296	Uzbek	Kazakstan
297	Gusii	Kenya
298	Kalenjin	Kenya
299	Kamba	Kenya
300	Kikuyu	Kenya
301	Luhya	Kenya
302	Luo	Kenya
303	Masai	Kenya
304	Meru	Kenya
305	Nyika	Kenya
306	Turkana	Kenya
307	Chinese	Cambodia
308	Khmer	Cambodia
309	Tšam	Cambodia
310	Vietnamese	Cambodia
311	Chinese	South Korea
312	Korean	South Korea
313	Lao	Laos
314	Lao-Soung	Laos
315	Mon-khmer	Laos
316	Thai	Laos
317	Arabic	Libyan Arab Jamahiriya
318	Berberi	Libyan Arab Jamahiriya
319	Mixed Languages	Sri Lanka
320	Singali	Sri Lanka
321	Tamil	Sri Lanka
322	Arabic	Morocco
323	Berberi	Morocco
324	French	Madagascar
325	Malagasy	Madagascar
326	Mixtec	Mexico
327	Náhuatl	Mexico
328	Otomí	Mexico
329	Spanish	Mexico
330	Yucatec	Mexico
331	Zapotec	Mexico
332	Bambara	Mali
333	Ful	Mali
334	Senufo and Minianka	Mali
335	Songhai	Mali
336	Soninke	Mali
337	Tamashek	Mali
338	Burmese	Myanmar
339	Chin	Myanmar
340	Kachin	Myanmar
341	Karen	Myanmar
342	Kayah	Myanmar
343	Mon	Myanmar
344	Rakhine	Myanmar
345	Shan	Myanmar
346	Chuabo	Mozambique
347	Lomwe	Mozambique
348	Makua	Mozambique
349	Marendje	Mozambique
350	Nyanja	Mozambique
351	Ronga	Mozambique
352	Sena	Mozambique
353	Shona	Mozambique
354	Tsonga	Mozambique
355	Tswa	Mozambique
356	Chichewa	Malawi
357	Lomwe	Malawi
358	Ngoni	Malawi
359	Yao	Malawi
360	Chinese	Malaysia
361	Dusun	Malaysia
362	English	Malaysia
363	Iban	Malaysia
364	Malay	Malaysia
365	Tamil	Malaysia
366	Ful	Niger
367	Hausa	Niger
368	Kanuri	Niger
369	Songhai-zerma	Niger
370	Tamashek	Niger
371	Bura	Nigeria
372	Edo	Nigeria
373	Ful	Nigeria
374	Hausa	Nigeria
375	Ibibio	Nigeria
376	Ibo	Nigeria
377	Ijo	Nigeria
378	Joruba	Nigeria
379	Kanuri	Nigeria
380	Tiv	Nigeria
381	Creole English	Nicaragua
382	Miskito	Nicaragua
383	Spanish	Nicaragua
384	Sumo	Nicaragua
385	Arabic	Netherlands
386	Dutch	Netherlands
387	Fries	Netherlands
388	Turkish	Netherlands
389	Bhojpuri	Nepal
390	Hindi	Nepal
391	Maithili	Nepal
392	Nepali	Nepal
393	Newari	Nepal
394	Tamang	Nepal
395	Tharu	Nepal
396	Balochi	Pakistan
397	Brahui	Pakistan
398	Hindko	Pakistan
399	Pashto	Pakistan
400	Punjabi	Pakistan
401	Saraiki	Pakistan
402	Sindhi	Pakistan
403	Urdu	Pakistan
404	Aimará	Peru
405	Ketšua	Peru
406	Spanish	Peru
407	Bicol	Philippines
408	Cebuano	Philippines
409	Hiligaynon	Philippines
410	Ilocano	Philippines
411	Maguindanao	Philippines
412	Maranao	Philippines
413	Pampango	Philippines
414	Pangasinan	Philippines
415	Pilipino	Philippines
416	Waray-waray	Philippines
417	Belorussian	Poland
418	German	Poland
419	Polish	Poland
420	Ukrainian	Poland
421	Chinese	North Korea
422	Korean	North Korea
423	Portuguese	Portugal
424	German	Paraguay
425	Guaraní	Paraguay
426	Portuguese	Paraguay
427	Spanish	Paraguay
428	German	Romania
429	Hungarian	Romania
430	Romani	Romania
431	Romanian	Romania
432	Serbo-Croatian	Romania
433	Ukrainian	Romania
434	Avarian	Russian Federation
435	Bashkir	Russian Federation
436	Belorussian	Russian Federation
437	Chechen	Russian Federation
438	Chuvash	Russian Federation
439	Kazakh	Russian Federation
440	Mari	Russian Federation
441	Mordva	Russian Federation
442	Russian	Russian Federation
443	Tatar	Russian Federation
444	Udmur	Russian Federation
445	Ukrainian	Russian Federation
446	French	Rwanda
447	Rwanda	Rwanda
448	Arabic	Saudi Arabia
449	Arabic	Sudan
450	Bari	Sudan
451	Beja	Sudan
452	Chilluk	Sudan
453	Dinka	Sudan
454	Fur	Sudan
455	Lotuko	Sudan
456	Nubian Languages	Sudan
457	Nuer	Sudan
458	Zande	Sudan
459	Diola	Senegal
460	Ful	Senegal
461	Malinke	Senegal
462	Serer	Senegal
463	Soninke	Senegal
464	Wolof	Senegal
465	Nahua	El Salvador
466	Spanish	El Salvador
467	Arabic	Somalia
468	Somali	Somalia
469	Czech and Moravian	Slovakia
470	Hungarian	Slovakia
471	Romani	Slovakia
472	Slovak	Slovakia
473	Ukrainian and Russian	Slovakia
474	Arabic	Sweden
475	Finnish	Sweden
476	Norwegian	Sweden
477	Southern Slavic Languages	Sweden
478	Spanish	Sweden
479	Swedish	Sweden
480	Arabic	Syria
481	Kurdish	Syria
482	Arabic	Chad
483	Gorane	Chad
484	Hadjarai	Chad
485	Kanem-bornu	Chad
486	Mayo-kebbi	Chad
487	Ouaddai	Chad
488	Sara	Chad
489	Tandjile	Chad
490	Chinese	Thailand
491	Khmer	Thailand
492	Kuy	Thailand
493	Lao	Thailand
494	Malay	Thailand
495	Thai	Thailand
496	Russian	Tajikistan
497	Tadzhik	Tajikistan
498	Uzbek	Tajikistan
499	Arabic	Tunisia
500	Arabic-French	Tunisia
501	Arabic-French-English	Tunisia
502	Arabic	Turkey
503	Kurdish	Turkey
504	Turkish	Turkey
505	Ami	Taiwan
506	Atayal	Taiwan
507	Hakka	Taiwan
508	Mandarin Chinese	Taiwan
509	Min	Taiwan
510	Paiwan	Taiwan
511	Chaga and Pare	Tanzania
512	Gogo	Tanzania
513	Ha	Tanzania
514	Haya	Tanzania
515	Hehet	Tanzania
516	Luguru	Tanzania
517	Makonde	Tanzania
518	Nyakusa	Tanzania
519	Nyamwesi	Tanzania
520	Shambala	Tanzania
521	Swahili	Tanzania
522	Acholi	Uganda
523	Ganda	Uganda
524	Gisu	Uganda
525	Kiga	Uganda
526	Lango	Uganda
527	Lugbara	Uganda
528	Nkole	Uganda
529	Rwanda	Uganda
530	Soga	Uganda
531	Teso	Uganda
532	Belorussian	Ukraine
533	Bulgariana	Ukraine
534	Hungarian	Ukraine
535	Polish	Ukraine
536	Romanian	Ukraine
537	Russian	Ukraine
538	Ukrainian	Ukraine
539	Chinese	United States
540	English	United States
541	French	United States
542	German	United States
543	Italian	United States
544	Japanese	United States
545	Korean	United States
546	Polish	United States
547	Portuguese	United States
548	Spanish	United States
549	Tagalog	United States
550	Vietnamese	United States
551	Karakalpak	Uzbekistan
552	Kazakh	Uzbekistan
553	Russian	Uzbekistan
554	Tadzhik	Uzbekistan
555	Tatar	Uzbekistan
556	Uzbek	Uzbekistan
557	Goajiro	Venezuela
558	Spanish	Venezuela
559	Warrau	Venezuela
560	Chinese	Vietnam
561	Khmer	Vietnam
562	Man	Vietnam
563	Miao	Vietnam
564	Muong	Vietnam
565	Nung	Vietnam
566	Thai	Vietnam
567	Tho	Vietnam
568	Vietnamese	Vietnam
569	Arabic	Yemen
570	Soqutri	Yemen
571	Albaniana	Yugoslavia
572	Hungarian	Yugoslavia
573	Macedonian	Yugoslavia
574	Romani	Yugoslavia
575	Serbo-Croatian	Yugoslavia
576	Slovak	Yugoslavia
577	Afrikaans	South Africa
578	English	South Africa
579	Ndebele	South Africa
580	Northsotho	South Africa
581	Southsotho	South Africa
582	Swazi	South Africa
583	Tsonga	South Africa
584	Tswana	South Africa
585	Venda	South Africa
586	Xhosa	South Africa
587	Zulu	South Africa
588	Bemba	Zambia
589	Chewa	Zambia
590	Lozi	Zambia
591	Nsenga	Zambia
592	Nyanja	Zambia
593	Tonga	Zambia
594	English	Zimbabwe
595	Ndebele	Zimbabwe
596	Nyanja	Zimbabwe
597	Shona	Zimbabwe

8. Calcular el promedio de población por ciudad en cada país

Álgebra relacional:

\[ \pi_{\text{CountryCode}, \text{AVG(Population)}}(\text{City}) \text{ GROUP BY CountryCode} \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT country.Name, AVG(city.Population)
FROM city 
JOIN country ON city.CountryCode=country.Code
GROUP BY country.Name;

	Name	AVG(city.Population)
0	Afghanistan	5.830250e+05
1	Netherlands	1.850018e+05
2	Netherlands Antilles	2.345000e+03
3	Albania	2.700000e+05
4	Algeria	2.884544e+05
5	American Samoa	3.761500e+03
6	Andorra	2.118900e+04
7	Angola	5.123200e+05
8	Anguilla	7.780000e+02
9	Antigua and Barbuda	2.400000e+04
10	United Arab Emirates	3.456672e+05
11	Argentina	3.508169e+05
12	Armenia	5.443667e+05
13	Aruba	2.903400e+04
14	Australia	8.081190e+05
15	Azerbaijan	6.160000e+05
16	Bahamas	1.720000e+05
17	Bahrain	1.480000e+05
18	Bangladesh	3.570794e+05
19	Barbados	6.070000e+03
20	Belgium	1.788136e+05
21	Belize	3.145750e+04
22	Benin	2.421258e+05
23	Bermuda	1.500000e+03
24	Bhutan	2.200000e+04
25	Bolivia	4.223305e+05
26	Bosnia and Herzegovina	1.997020e+05
27	Botswana	1.574110e+05
28	Brazil	3.435074e+05
29	United Kingdom	2.769960e+05
30	Virgin Islands, British	8.000000e+03
31	Brunei	2.148400e+04
32	Bulgaria	2.696915e+05
33	Burkina Faso	4.096667e+05
34	Burundi	3.000000e+05
35	Cayman Islands	1.960000e+04
36	Chile	3.351024e+05
37	Cook Islands	1.190000e+04
38	Costa Rica	3.391310e+05
39	Djibouti	3.830000e+05
40	Dominica	1.624300e+04
41	Dominican Republic	4.063793e+05
42	Ecuador	3.829428e+05
43	Egypt	5.427859e+05
44	El Salvador	1.626044e+05
45	Eritrea	4.310000e+05
46	Spain	2.825286e+05
47	South Africa	3.453720e+05
48	Ethiopia	4.557620e+05
49	Falkland Islands	1.636000e+03
50	Fiji Islands	7.736600e+04
51	Philippines	2.274617e+05
52	Faroe Islands	1.454200e+04
53	Gabon	4.190000e+05
54	Gambia	7.246300e+04
55	Georgia	3.761800e+05
56	Ghana	3.639778e+05
57	Gibraltar	2.702500e+04
58	Grenada	4.621000e+03
59	Greenland	1.344500e+04
60	Guadeloupe	3.769000e+04
61	Guam	5.319500e+03
62	Guatemala	3.062970e+05
63	Guinea	1.090610e+06
64	Guinea-Bissau	2.410000e+05
65	Guyana	2.540000e+05
66	Haiti	3.793345e+05
67	Honduras	4.290000e+05
68	Hong Kong	1.650316e+06
69	Svalbard and Jan Mayen	1.438000e+03
70	Indonesia	4.410082e+05
71	India	3.615793e+05
72	Iraq	5.950694e+05
73	Iran	3.885521e+05
74	Ireland	3.045205e+05
75	Iceland	1.091840e+05
76	Israel	2.009286e+05
77	Italy	2.601210e+05
78	East Timor	4.790000e+04
79	Austria	3.973788e+05
80	Jamaica	1.047133e+05
81	Japan	3.143754e+05
82	Yemen	2.906167e+05
83	Jordan	3.695354e+05
84	Christmas Island	7.000000e+02
85	Yugoslavia	2.736884e+05
86	Cambodia	2.683517e+05
87	Cameroon	5.032220e+05
88	Canada	2.586498e+05
89	Cape Verde	9.480000e+04
90	Kazakstan	2.611524e+05
91	Kenya	4.403491e+05
92	Central African Republic	5.240000e+05
93	China	4.847207e+05
94	Kyrgyzstan	4.060500e+05
95	Kiribati	3.640500e+03
96	Colombia	5.329208e+05
97	Comoros	3.600000e+04
98	Congo	7.250000e+05
99	Congo, The Democratic Republic of the	5.480342e+05
100	Cocos (Keeling) Islands	3.350000e+02
101	North Korea	4.982116e+05
102	South Korea	5.571413e+05
103	Greece	2.466054e+05
104	Croatia	2.922208e+05
105	Cuba	3.307089e+05
106	Kuwait	8.708400e+04
107	Cyprus	1.747000e+05
108	Laos	3.142260e+05
109	Latvia	3.228653e+05
110	Lesotho	2.970000e+05
111	Lebanon	6.700000e+05
112	Liberia	8.500000e+05
113	Libyan Arab Jamahiriya	6.742518e+05
114	Liechtenstein	5.194500e+03
115	Lithuania	2.946634e+05
116	Luxembourg	8.070000e+04
117	Western Sahara	1.690000e+05
118	Macao	4.375000e+05
119	Madagascar	2.246322e+05
120	Macedonia	4.442990e+05
121	Malawi	4.570595e+05
122	Maldives	7.100000e+04
123	Malaysia	2.558412e+05
124	Mali	8.095520e+05
125	Malta	1.425900e+04
126	Morocco	3.980710e+05
127	Marshall Islands	2.800000e+04
128	Martinique	9.405000e+04
129	Mauritania	3.824500e+05
130	Mauritius	1.124267e+05
131	Mayotte	1.200000e+04
132	Mexico	3.453903e+05
133	Micronesia, Federated States of	1.530000e+04
134	Moldova	2.983250e+05
135	Monaco	7.194000e+03
136	Mongolia	7.737000e+05
137	Montserrat	2.000000e+03
138	Mozambique	2.619288e+05
139	Myanmar	3.876875e+05
140	Namibia	1.690000e+05
141	Nauru	2.304500e+03
142	Nepal	2.264806e+05
143	Nicaragua	3.173058e+05
144	Niger	2.179523e+05
145	Nigeria	2.713578e+05
146	Niue	6.820000e+02
147	Norfolk Island	8.000000e+02
148	Norway	2.200056e+05
149	Côte d’Ivoire	6.382274e+05
150	Oman	1.074192e+05
151	Pakistan	5.346906e+05
152	Palau	1.200000e+04
153	Panama	3.933775e+05
154	Papua New Guinea	2.470000e+05
155	Paraguay	2.040040e+05
156	Peru	5.521474e+05
157	Pitcairn	4.200000e+01
158	Northern Mariana Islands	9.200000e+03
159	Portugal	2.290022e+05
160	Puerto Rico	1.737971e+05
161	Poland	2.656234e+05
162	Equatorial Guinea	4.000000e+04
163	Qatar	3.550000e+05
164	France	2.311124e+05
165	French Guiana	5.069900e+04
166	French Polynesia	2.572050e+04
167	Réunion	1.314800e+05
168	Romania	2.575519e+05
169	Rwanda	2.860000e+05
170	Sweden	1.927621e+05
171	Saint Helena	1.500000e+03
172	Saint Kitts and Nevis	1.160000e+04
173	Saint Lucia	2.301000e+03
174	Saint Vincent and the Grenadines	1.710000e+04
175	Saint Pierre and Miquelon	5.808000e+03
176	Germany	2.822095e+05
177	Solomon Islands	5.010000e+04
178	Zambia	3.533571e+05
179	Samoa	3.590000e+04
180	San Marino	3.548000e+03
181	Sao Tome and Principe	4.954100e+04
182	Saudi Arabia	4.431958e+05
183	Senegal	3.078287e+05
184	Seychelles	4.100000e+04
185	Sierra Leone	8.500000e+05
186	Singapore	4.017733e+06
187	Slovakia	2.613810e+05
188	Slovenia	1.932590e+05
189	Somalia	3.923333e+05
190	Sri Lanka	2.207143e+05
191	Sudan	3.960156e+05
192	Finland	2.189884e+05
193	Suriname	1.120000e+05
194	Swaziland	6.100000e+04
195	Switzerland	1.828400e+05
196	Syria	4.070713e+05
197	Tajikistan	3.427500e+05
198	Taiwan	3.230794e+05
199	Tanzania	2.944034e+05
200	Denmark	2.431890e+05
201	Thailand	6.627634e+05
202	Togo	3.750000e+05
203	Tokelau	3.000000e+02
204	Tonga	2.240000e+04
205	Trinidad and Tobago	4.999850e+04
206	Chad	3.152325e+05
207	Czech Republic	2.634711e+05
208	Tunisia	2.248125e+05
209	Turkey	4.568875e+05
210	Turkmenistan	2.431500e+05
211	Turks and Caicos Islands	4.800000e+03
212	Tuvalu	4.600000e+03
213	Uganda	8.908000e+05
214	Ukraine	3.521754e+05
215	Hungary	3.281456e+05
216	Uruguay	1.236000e+06
217	New Caledonia	7.629300e+04
218	New Zealand	2.052889e+05
219	Uzbekistan	3.049353e+05
220	Belarus	2.963125e+05
221	Wallis and Futuna	1.137000e+03
222	Vanuatu	3.370000e+04
223	Holy See (Vatican City State)	4.550000e+02
224	Venezuela	2.988071e+05
225	Russian Federation	3.658767e+05
226	Vietnam	4.256733e+05
227	Estonia	2.526135e+05
228	United States	2.869554e+05
229	Virgin Islands, U.S.	1.300000e+04
230	Zimbabwe	4.550700e+05
231	Palestine	1.503933e+05

9. Seleccionar los países cuya calificación de vida está por encima del promedio mundial

Álgebra relacional:

\[ \sigma_{\text{LifeExpectancy} > \text{AVG(LifeExpectancy)}}(\text{Country}) \]

SQL equivalente:

Show code cell content Hide code cell content

SELECT Name, LifeExpectancy FROM country 
WHERE LifeExpectancy>(SELECT AVG(LifeExpectancy) AS WorldAVGLE FROM country)
ORDER BY LifeExpectancy ASC;

	Name	LifeExpectancy
0	Iraq	66.5
1	Russian Federation	67.2
2	Mongolia	67.3
3	Philippines	67.5
4	Saudi Arabia	67.8
5	Fiji Islands	67.9
6	Tonga	67.9
7	Belarus	68.0
8	Indonesia	68.0
9	Trinidad and Tobago	68.0
10	Greenland	68.1
11	Latvia	68.4
12	Syria	68.5
13	Micronesia, Federated States of	68.6
14	Palau	68.6
15	Thailand	68.6
16	Nicaragua	68.7
17	Cape Verde	68.9
18	Lithuania	69.1
19	Morocco	69.1
20	Samoa	69.2
21	Vietnam	69.3
22	Estonia	69.5
23	Algeria	69.7
24	Iran	69.7
25	El Salvador	69.7
26	Honduras	69.9
27	Romania	69.9
28	Peru	70.0
29	Colombia	70.3
30	Seychelles	70.4
31	Antigua and Barbuda	70.5
32	Saint Kitts and Nevis	70.7
33	North Korea	70.7
34	Malaysia	70.8
35	Bulgaria	70.9
36	Belize	70.9
37	Mauritius	71.0
38	Turkey	71.0
39	Bahamas	71.1
40	Cook Islands	71.1
41	Ecuador	71.1
42	Lebanon	71.3
43	Solomon Islands	71.3
44	China	71.4
45	Hungary	71.4
46	Palestine	71.4
47	Suriname	71.4
48	Bosnia and Herzegovina	71.5
49	Mexico	71.5
50	Albania	71.6
51	Sri Lanka	71.8
52	Oman	71.8
53	Saint Lucia	72.3
54	Saint Vincent and the Grenadines	72.3
55	Qatar	72.4
56	Yugoslavia	72.4
57	Réunion	72.7
58	New Caledonia	72.8
59	Bahrain	73.0
60	Barbados	73.0
61	Venezuela	73.1
62	Dominican Republic	73.2
63	Poland	73.2
64	Turks and Caicos Islands	73.3
65	Dominica	73.4
66	Brunei	73.6
67	Croatia	73.7
68	Paraguay	73.7
69	Slovakia	73.7
70	Tunisia	73.7
71	Macedonia	73.8
72	United Arab Emirates	74.1
73	South Korea	74.4
74	Czech Republic	74.5
75	Netherlands Antilles	74.7
76	French Polynesia	74.8
77	Slovenia	74.9
78	Argentina	75.1
79	American Samoa	75.1
80	Jamaica	75.2
81	Uruguay	75.2
82	Virgin Islands, British	75.4
83	Libyan Arab Jamahiriya	75.5
84	Northern Mariana Islands	75.5
85	Panama	75.5
86	Puerto Rico	75.6
87	Chile	75.7
88	Costa Rica	75.8
89	Portugal	75.8
90	Anguilla	76.1
91	French Guiana	76.1
92	Kuwait	76.1
93	Cuba	76.2
94	Taiwan	76.4
95	Denmark	76.5
96	Cyprus	76.7
97	Ireland	76.8
98	Saint Helena	76.8
99	Bermuda	76.9
100	Guadeloupe	77.0
101	Luxembourg	77.1
102	United States	77.1
103	Germany	77.4
104	Finland	77.4
105	Jordan	77.4
106	Saint Pierre and Miquelon	77.6
107	Austria	77.7
108	United Kingdom	77.7
109	Belgium	77.8
110	Guam	77.8
111	New Zealand	77.8
112	Malta	77.9
113	Montserrat	78.0
114	Virgin Islands, U.S.	78.1
115	Martinique	78.3
116	Netherlands	78.3
117	Aruba	78.4
118	Faroe Islands	78.4
119	Greece	78.4
120	Israel	78.6
121	Norway	78.7
122	Spain	78.8
123	France	78.8
124	Liechtenstein	78.8
125	Monaco	78.8
126	Cayman Islands	78.9
127	Gibraltar	79.0
128	Italy	79.0
129	Canada	79.4
130	Iceland	79.4
131	Hong Kong	79.5
132	Switzerland	79.6
133	Sweden	79.6
134	Australia	79.8
135	Singapore	80.1
136	Japan	80.7
137	San Marino	81.1
138	Macao	81.6
139	Andorra	83.5

10. Encontrar los continentes con una calificación de vida superior al promedio de su continente

Álgebra relacional:

\[ \pi_{\text{Continent, AVG(LifeExpectancy)}}(\text{Country}) \text{ GROUP BY Continent} \]

SQL equivalente:

Show code cell content Hide code cell content

-- Muestra el promedio de la expectativa de vida por continente
SELECT Continent, AVG(LifeExpectancy) FROM country
GROUP BY Continent;

-- Responde la pregunta
SELECT Continent, Name, LifeExpectancy
FROM country
WHERE LifeExpectancy > (
    SELECT AVG(LifeExpectancy)
    FROM country AS sub_country
    WHERE sub_country.Continent = country.Continent
)
ORDER BY Continent, LifeExpectancy ASC;

	Continent	Name	LifeExpectancy
0	Asia	Philippines	67.5
1	Asia	Saudi Arabia	67.8
2	Asia	Indonesia	68.0
3	Asia	Syria	68.5
4	Asia	Thailand	68.6
5	Asia	Vietnam	69.3
6	Asia	Iran	69.7
7	Asia	North Korea	70.7
8	Asia	Malaysia	70.8
9	Asia	Turkey	71.0
10	Asia	Lebanon	71.3
11	Asia	China	71.4
12	Asia	Palestine	71.4
13	Asia	Sri Lanka	71.8
14	Asia	Oman	71.8
15	Asia	Qatar	72.4
16	Asia	Bahrain	73.0
17	Asia	Brunei	73.6
18	Asia	United Arab Emirates	74.1
19	Asia	South Korea	74.4
20	Asia	Kuwait	76.1
21	Asia	Taiwan	76.4
22	Asia	Cyprus	76.7
23	Asia	Jordan	77.4
24	Asia	Israel	78.6
25	Asia	Hong Kong	79.5
26	Asia	Singapore	80.1
27	Asia	Japan	80.7
28	Asia	Macao	81.6
29	Europe	Portugal	75.8
30	Europe	Denmark	76.5
31	Europe	Ireland	76.8
32	Europe	Luxembourg	77.1
33	Europe	Germany	77.4
34	Europe	Finland	77.4
35	Europe	Austria	77.7
36	Europe	United Kingdom	77.7
37	Europe	Belgium	77.8
38	Europe	Malta	77.9
39	Europe	Netherlands	78.3
40	Europe	Faroe Islands	78.4
41	Europe	Greece	78.4
42	Europe	Norway	78.7
43	Europe	Spain	78.8
44	Europe	France	78.8
45	Europe	Liechtenstein	78.8
46	Europe	Monaco	78.8
47	Europe	Gibraltar	79.0
48	Europe	Italy	79.0
49	Europe	Iceland	79.4
50	Europe	Switzerland	79.6
51	Europe	Sweden	79.6
52	Europe	San Marino	81.1
53	Europe	Andorra	83.5
54	North America	Barbados	73.0
55	North America	Dominican Republic	73.2
56	North America	Turks and Caicos Islands	73.3
57	North America	Dominica	73.4
58	North America	Netherlands Antilles	74.7
59	North America	Jamaica	75.2
60	North America	Virgin Islands, British	75.4
61	North America	Panama	75.5
62	North America	Puerto Rico	75.6
63	North America	Costa Rica	75.8
64	North America	Anguilla	76.1
65	North America	Cuba	76.2
66	North America	Bermuda	76.9
67	North America	Guadeloupe	77.0
68	North America	United States	77.1
69	North America	Saint Pierre and Miquelon	77.6
70	North America	Montserrat	78.0
71	North America	Virgin Islands, U.S.	78.1
72	North America	Martinique	78.3
73	North America	Aruba	78.4
74	North America	Cayman Islands	78.9
75	North America	Canada	79.4
76	Africa	Gambia	53.2
77	Africa	Equatorial Guinea	53.6
78	Africa	Togo	54.7
79	Africa	Cameroon	54.8
80	Africa	Madagascar	55.0
81	Africa	Eritrea	55.8
82	Africa	Sudan	56.6
83	Africa	Ghana	57.4
84	Africa	Mayotte	59.5
85	Africa	Comoros	60.0
86	Africa	Senegal	62.2
87	Africa	Egypt	63.3
88	Africa	Sao Tome and Principe	65.3
89	Africa	Cape Verde	68.9
90	Africa	Morocco	69.1
91	Africa	Algeria	69.7
92	Africa	Seychelles	70.4
93	Africa	Mauritius	71.0
94	Africa	Réunion	72.7
95	Africa	Tunisia	73.7
96	Africa	Libyan Arab Jamahiriya	75.5
97	Africa	Saint Helena	76.8
98	Oceania	Cook Islands	71.1
99	Oceania	Solomon Islands	71.3
100	Oceania	New Caledonia	72.8
101	Oceania	French Polynesia	74.8
102	Oceania	American Samoa	75.1
103	Oceania	Northern Mariana Islands	75.5
104	Oceania	Guam	77.8
105	Oceania	New Zealand	77.8
106	Oceania	Australia	79.8
107	South America	Ecuador	71.1
108	South America	Suriname	71.4
109	South America	Venezuela	73.1
110	South America	Paraguay	73.7
111	South America	Argentina	75.1
112	South America	Uruguay	75.2
113	South America	Chile	75.7
114	South America	French Guiana	76.1

Más Consultas

Propongan 10 preguntas, con su respectiva representación en el álgebra relacional, que puedan ser resueltas con consultas a la base de datos World. Deben proponer la pregunta y responderla utilizando comandos de MySQL.

Plantilla

Utilicen la siguiente plantilla para la creación de cada pregunta:

No. Enunciado Pregunta

Álgebra relacional

\[ Álgebra Relacional \]

SQL equivalente

-- Consulta en comandos de MySQL

Ejercicio

Taller

Realizar todo el taller. Debe presentarse como un archivo de markdown que utilice los bloques de código y de matemáticas.

Entregables:

Deben entregar un archivo tipo markdown con las respuestas de las preguntas escritas en MySQL, puede llamarse consultas.md. En este también deben colocar los pantallazos de los resultados, para ello en la misma carpeta donde esta el archivo creen una carpeta de imagenes y guardan alli todos los pantallazos. Para llamarlas dentro del archivo markdown usen el comando:

<div align="center">
  <img src="./images/nombre_imagen" width=90%>
</div>

Truco

Utilicen este archivo como plantilla para la solución.

Conclusiones

1. Comprensión de Operadores y Sintaxis SQL: Al finalizar el taller, los estudiantes habrán desarrollado una comprensión sólida de los operadores básicos y de nivel medio en SQL y podrán utilizar comandos como GROUP BY, HAVING, LIKE, DISTINCT, y operadores de agregación (MAX, MIN, AVG, COUNT) en diversas situaciones.

2. Uso de Álgebra Relacional como Fundamento Teórico: La introducción de la notación de álgebra relacional proporciona a los estudiantes una base teórica fundamental, permitiéndoles visualizar mejor las operaciones y comprender la traducción de conceptos abstractos a sintaxis SQL práctica.

3. Capacidad para Resolver Consultas Complejas: Gracias a las consultas de nivel medio, los estudiantes adquieren habilidades para resolver problemas más complejos en SQL, como agrupamiento y filtrado de datos en base a condiciones específicas. Esta habilidad es esencial para el análisis y manejo de grandes volúmenes de datos en aplicaciones del mundo real.

4. Preparación para Escenarios Reales: El uso de una base de datos con información global permite a los estudiantes visualizar cómo los datos interrelacionados pueden ser consultados y organizados, lo cual es útil en aplicaciones como reportes, visualización de datos, y en el contexto de decisiones empresariales.

Referencias

Libros

• Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.

• Murach, J. (2017). Murach’s MySQL. Mike Murach & Associates, Inc.

• Ramakrishnan, R., & Gehrke, J. (2003). Database Management Systems (3rd ed.). McGraw-Hill.

Bases de Datos

• world.db

• world.db

Documentación

• Chapter 7 Examples of Common Queries

• MySQL GROUP BY Statement

• MySQL SQL

• W3Schools. (n.d.). SQL Tutorial. Retrieved from W3Schools SQL Tutorial