text: 
  /* Country */
  
  DROP TABLE IF EXISTS Country 
  ;
  
  CREATE TABLE Country(
  	Name VARCHAR2(50) NOT NULL UNIQUE,
  	Code VARCHAR2(4) CONSTRAINT CountryKey PRIMARY KEY,
  	Capital VARCHAR2(50),
  	Province VARCHAR2(50),
  	Area NUMBER CONSTRAINT CountryArea 
  		CHECK (Area >= 0),
  	Population NUMBER CONSTRAINT CountryPop
  		CHECK (Population >= 0)
  )
  ;
  
  INSERT INTO Country (Name,Code,Capital,Province,Area,Population) VALUES 
  	('Albania','AL','Tirana','Albania',28750,2821977),
  	('Greece','GR','Athina','Attikis',131940,10816286),
  	('Macedonia','MK','Skopje','Macedonia',25333,2059794),
  	('Serbia','SRB','Beograd','Serbia',77474,7120666),
  	('Montenegro','MNE','Podgorica','Montenegro',14026,620029),
  	('Kosovo','KOS','Prishtine','Kosovo',10887,1733872),
  	('Andorra','AND','Andorra la Vella','Andorra',450,78115),
  	('France','F','Paris','Île-de-France',547030,64933400),
  	('Spain','E','Madrid','Madrid',504750,46815916),
  	('Austria','A','Wien','Wien',83850,8499759),
  	('Czech Republic','CZ','Praha','Praha',78703,10562214),
  	('Germany','D','Berlin','Berlin',356910,82521653),
  	('Hungary','H','Budapest','Budapest',93030,9937628),
  	('Italy','I','Roma','Lazio',301230,59433744),
  	('Liechtenstein','FL','Vaduz','Liechtenstein',160,36149),
  	('Slovakia','SK','Bratislava','Bratislavský',48845,5397036),
  	('Slovenia','SLO','Ljubljana','Slovenia',20256,2058821),
  	('Switzerland','CH','Bern','Bern',41290,8139631),
  	('Belarus','BY','Minsk','Minsk City',207600,9460692),
  	('Latvia','LV','R?ga','Latvia',64100,2201196),
  	('Lithuania','LT','Vilnius','Lithuania',65200,2979310),
  	('Poland','PL','Warszawa','Mazowieckie',312683,38533789),
  	('Ukraine','UA','Kyïv','Kyïv',603700,45633637),
  	('Russia','R','Moskva','Moscow',17075200,143666931),
  	('Belgium','B','Bruxelles','Bruxelles',30510,11099554),
  	('Luxembourg','L','Luxembourg','Luxembourg',2586,524853),
  	('Netherlands','NL','Amsterdam','Noord-Holland',37330,16843181),
  	('Bosnia and Herzegovina','BIH','Sarajevo','Federacija Bosne i Hercegovine',51233,3791622),
  	('Croatia','HR','Zagreb','Croatia',56538,4290612),
  	('Bulgaria','BG','Sofia','Bulgaria',110910,7284552),
  	('Romania','RO','Bucure?ti','Bucure?ti',237500,20121641),
  	('Turkey','TR','Ankara','Ankara',780580,75627384),
  	('Denmark','DK','Copenhagen','Hovedstaden',43070,5678348),
  	('Estonia','EW','Tallinn','Estonia',45100,1294455),
  	('Faroe Islands','FARX','Tórshavn','Faroe Islands',1400,50494),
  	('Finland','SF','Helsinki','Uusimaa',337030,5513130),
  	('Norway','N','Oslo','Oslo',324220,5051275),
  	('Sweden','S','Stockholm','Stockholm',449964,9555893),
  	('Monaco','MC','Monaco','Monaco',1.9,36845),
  	('Gibraltar','GBZ','Gibraltar','Gibraltar',6.5,32577),
  	('Guernsey','GBG','Saint Peter Port','Guernsey',194,64540),
  	('Holy See','V','Vatican City','Holy See',0.44,842),
  	('Ceuta','CEU','Ceuta','Ceuta',18,82376),
  	('Melilla','MEL','Melilla','Melilla',12,78476),
  	('Iceland','IS','Reykjavik','Iceland',103000,329100),
  	('Ireland','IRL','Dublin','Ireland',70280,4588252),
  	('San Marino','RSM','San Marino','San Marino',60,32440),
  	('Jersey','GBJ','Saint Helier','Jersey',117,97857),
  	('Malta','M','Valletta','Malta',316,417432),
  	('Isle of Man','GBM','Douglas','Isle of Man',588,84497),
  	('Moldova','MD','Chi?in?u','Moldova',33700,3559541),
  	('Portugal','P','Lisboa','Lisboa',92080,10561614),
  	('Svalbard','SVAX','Longyearbyen','Svalbard',62049,1872),
  	('United Kingdom','GB','London','London',244820,64105654),
  	('Afghanistan','AFG','Kabul','Afghanistan',647500,26023100),
  	('China','CN','Beijing','Beijing',9596960,1360720000),
  	('Iran','IR','Tehran','Tehran',1648000,79926270),
  	('Pakistan','PK','Islamabad','FCT Islamabad',803940,207776954),
  	('Tajikistan','TAD','Dushanbe','Dushanbe',143100,8161100),
  	('Turkmenistan','TM','Ashgabat','Ashgabat',488100,6550000),
  	('Uzbekistan','UZB','Toshkent','Toshkent City',447400,27769270),
  	('Armenia','ARM','Yerevan','Armenia',29800,3026879),
  	('Georgia','GE','Tbilisi','Georgia',69700,4483800),
  	('Azerbaijan','AZ','Baku','Azerbaijan',86600,9356500),
  	('Bahrain','BRN','Al Man?mah','Bahrain',620,1234596),
  	('Bangladesh','BD','Dhaka','Dhaka',144000,149772364),
  	('Myanmar','MYA','Nay Pyi Taw','Nay Pyi Taw',678500,51419420),
  	('India','IND','Delhi','Delhi',3287590,1210854977),
  	('Bhutan','BHT','Thimphu','Bhutan',47000,733004),
  	('Brunei','BRU','Bandar Seri Begawan','Brunei',5770,393372),
  	('Malaysia','MAL','Kuala Lumpur','Kuala Lumpur',329750,27565821),
  	('Laos','LAO','Vientiane','Laos',236800,6514432),
  	('Thailand','THA','Bangkok','Thailand',514000,65981659),
  	('Cambodia','K','Phnom Penh','Cambodia',181040,14364931),
  	('Vietnam','VN','Hanoi','Red River Delta',329560,88772900),
  	('Kazakhstan','KAZ','Astana','Astana',2717300,17165239),
  	('North Korea','NOK','Pyongyang','North Korea',120540,24500520),
  	('Kyrgyzstan','KGZ','Bishkek','Kyrgyzstan',198500,6256700),
  	('Hong Kong','HONX','Hong Kong','Hong Kong',1092,7071576),
  	('Macao','MACX','Macao','Macao',16,552503),
  	('Mongolia','MNG','Ulaanbaatar','Mongolia',1565000,2754685),
  	('Nepal','NEP','Kathmandu','Nepal',140800,26494504),
  	('Christmas Island','XMAS','Flying Fish Cove','Christmas Island',135,2072),
  	('Cocos Islands','COCO','West Island','Cocos Islands',14,596),
  	('Cyprus','CY','Lefkosia','Cyprus',9251,840407),
  	('Gaza Strip','GAZA',NULL,NULL,365,1899291),
  	('Israel','IL','Yerushalayim','Yerushalayim',22072,7420368),
  	('Egypt','ET','Al Qahirah','Egypt',1001450,94798827),
  	('Indonesia','RI','Jakarta','DKI Jakarta',1919440,252124458),
  	('Timor-Leste','TL','Dili','Timor-Leste',15007,1066582),
  	('Papua New Guinea','PNG','Port Moresby','Papua New Guinea',461690,7275324),
  	('Iraq','IRQ','Baghdad','Baghdad',437072,33330512),
  	('Jordan','JOR','Amman','Jordan',89213,6249000),
  	('Kuwait','KWT','Al Kuwayt','Kuwait',17820,2991580),
  	('Saudi Arabia','SA','Riyadh','Al-Riyadh',1960582,27136977),
  	('Syria','SYR','Dimashq','Dimashq',185180,20866000),
  	('Lebanon','RL','Bayr?t','Lebanon',10400,4341092),
  	('West Bank','WEST','Ramallah','West Bank',5655,2881687),
  	('Japan','J','Tokyo','Tokyo',377835,127298000),
  	('South Korea','ROK','Seoul','South Korea',98480,51269554),
  	('Maldives','MV','Male','Maldives',300,341256),
  	('Oman','OM','Muscat','Oman',212460,3623001),
  	('United Arab Emirates','UAE','Abu Dhabi','United Arab Emirates',75581,9121167),
  	('Yemen','YE','Sana''a','Yemen',527970,24527000),
  	('Philippines','RP','Manila','Metro Manila',299764,92337852),
  	('Qatar','Q','Doha','Qatar',11000,1699435),
  	('Singapore','SGP','Singapore','Singapore',632.6,5076700),
  	('Sri Lanka','CL','Sri Jayawardhanapura','Sri Lanka',65610,20263723),
  	('Taiwan','RC','Taipei','Taiwan',36179,23571227),
  	('Anguilla','AXA','The Valley','Anguilla',102,13037),
  	('Antigua and Barbuda','AG','Saint Johns','Antigua and Barbuda',442,81799),
  	('Aruba','ARU','Oranjestad','Aruba',193,101484),
  	('Bahamas','BS','Nassau','Bahamas',13940,353658),
  	('Barbados','BDS','Bridgetown','Barbados',430,277821),
  	('Belize','BZ','Belmopan','Belize',22960,312971),
  	('Guatemala','GCA','Ciudad de Guatemala','Guatemala',108890,15073375),
  	('Mexico','MEX','Ciudad de México','Distrito Federal',1972550,112336538),
  	('Bermuda','BERM','Hamilton','Bermuda',53.3,64628),
  	('British Virgin Islands','BVIR','Road Town','British Virgin Islands',153,28054),
  	('Canada','CDN','Ottawa','Ontario',9976140,35151728),
  	('United States','USA','Washington','District of Columbia',9372610,318857056),
  	('Cayman Islands','CAYM','George Town','Cayman Islands',262,55691),
  	('Costa Rica','CR','San José','San José',51100,4773119),
  	('Nicaragua','NIC','Managua','Nicaragua',129494,6327927),
  	('Panama','PA','Panamá City','Panamá',78200,3405813),
  	('Cuba','C','La Habana','La Habana',110860,11167325),
  	('Dominica','WD','Roseau','Dominica',746,70739),
  	('Dominican Republic','DOM','Santo Domingo','Dominican Republic',48730,9445281),
  	('Haiti','RH','Port-au-Prince','Haiti',27750,9896400),
  	('El Salvador','ES','San Salvador','El Salvador',21040,6290420),
  	('Honduras','HCA','Tegucigalpa','Francisco Morazán',112090,8045990),
  	('Greenland','GROX','Nuuk','Greenland',2175600,56370),
  	('Grenada','WG','Saint George''s','Grenada',344,103328),
  	('Guadeloupe','GUAD','Basse-Terre','Guadeloupe',1628,404635),
  	('Jamaica','JA','Kingston','Jamaica',10991,2697983),
  	('Martinique','MART','Fort-de-France','Martinique',1128,392291),
  	('Montserrat','MNTS','Plymouth','Montserrat',102,4922),
  	('Curacao','CUR','Willemstad','Curacao',444,150563),
  	('Sint Maarten','NLSM','Philipsburg','Sint Maarten',34,37429),
  	('Saint Martin','SMAR','Marigot','Saint Martin',54,37630),
  	('Saint Barthelemy','SBAR','Gustavia','Saint Barthelemy',21,9072),
  	('Colombia','CO','Bogotá','Santa Fe de Bogotá',1138910,47661787),
  	('Puerto Rico','PR','San Juan','Puerto Rico',8870,3725789),
  	('Saint Kitts and Nevis','KN','Basseterre','Saint Kitts and Nevis',269,52352),
  	('Saint Lucia','WL','Castries','Saint Lucia',620,165595),
  	('Saint Pierre and Miquelon','SPMI','Saint-Pierre','Saint Pierre and Miquelon',242,6312),
  	('Saint Vincent and the Grenadines','WV','Kingstown','Saint Vincent and the Grenadines',389,109991),
  	('Trinidad and Tobago','TT','Port-of-Spain','Trinidad and Tobago',5130,1328019),
  	('Turks and Caicos Islands','TUCA','Grand Turk','Turks and Caicos Islands',430,31458),
  	('Virgin Islands','VIRG','Charlotte Amalie','Virgin Islands',352,106405),
  	('American Samoa','AMSA','Pago Pago','American Samoa',199,55519),
  	('Australia','AUS','Canberra','Australia Capital Territory',7692024,23135281),
  	('Cook Islands','COOK','Avarua','Cook Islands',240,17794),
  	('Fiji','FJI','Suva','Fiji',18270,884887),
  	('French Polynesia','FPOL','Papeete','French Polynesia',4167,268270),
  	('Guam','GUAM','Hagåtña','Guam',545,159358),
  	('Kiribati','KIR','Tarawa','Kiribati',717,103058),
  	('Marshall Islands','MH','Majuro','Marshall Islands',181.3,53158),
  	('Micronesia','FSM','Palikir','Micronesia',702,102843),
  	('Nauru','NAU','Yaren','Nauru',21,10025),
  	('New Caledonia','NCA','Noumea','New Caledonia',19060,268767),
  	('New Zealand','NZ','Wellington','New Zealand',268680,4242048),
  	('Niue','NIUE','Alofi','Niue',260,1611),
  	('Norfolk Island','NORF','Kingston','Norfolk Island',34.6,2169),
  	('Northern Mariana Islands','NMIS','Saipan','Northern Mariana Islands',477,53883),
  	('Palau','PAL','Melekeok','Palau',458,17501),
  	('Pitcairn','PITC','Adamstown','Pitcairn',47,56),
  	('Solomon Islands','SLB','Honiara','Solomon Islands',28450,526447),
  	('Tonga','TO','Nukualofa','Tonga',748,103252),
  	('Tuvalu','TUV','Funafuti','Tuvalu',26,9827),
  	('Tokelau','TOK','Fakaofo','Tokelau',12,1383),
  	('Vanuatu','VU','Port Vila','Vanuatu',14760,236299),
  	('Wallis and Futuna','WAFU','Mata-Utu','Wallis and Futuna',274,12197),
  	('Samoa','WS','Apia','Samoa',2860,187820),
  	('Argentina','RA','Buenos Aires','Distrito Federal',2766890,42669500),
  	('Bolivia','BOL','La Paz','La Paz',1098580,10027262),
  	('Brazil','BR','Brasília','Distrito Federal',8511965,202768562),
  	('Chile','RCH','Santiago','Santiago',756950,16341929),
  	('Paraguay','PY','Asunción','Paraguay',406750,6672631),
  	('Uruguay','ROU','Montevideo','Uruguay',176220,3286314),
  	('Peru','PE','Lima','Lima City',1285220,30135875),
  	('French Guiana','FGU','Cayenne','French Guiana',83534,237549),
  	('Guyana','GUY','Georgetown','Guyana',214970,747884),
  	('Suriname','SME','Paramaribo','Suriname',163270,541638),
  	('Venezuela','YV','Caracas','Distrito Federal',912050,28946101),
  	('Ecuador','EC','Quito','Ecuador',283560,14483499),
  	('Falkland Islands','FALK','Stanley','Falkland Islands',12173,2931),
  	('Algeria','DZ','Algiers','Algeria',2381740,37062820),
  	('Libya','LAR','Tripoli','Libya',1759540,6040612),
  	('Mali','RMM','Bamako','Bamako',1240000,13985961),
  	('Mauritania','RIM','Nouakchott','Nouakchott',1030700,3537368),
  	('Morocco','MA','Rabat','Rabat Sale Zemmour Zaer',446550,32901622),
  	('Niger','RN','Niamey','Niamey',1267000,17138707),
  	('Tunisia','TN','Tunis','Tunisia',163610,10982754),
  	('Western Sahara','WSA','El Aaiun','Western Sahara',266000,554795),
  	('Angola','ANG','Luanda','Luanda',1246700,25789024),
  	('Congo','RCB','Brazzaville','Brazzaville',342000,4001831),
  	('Namibia','NAM','Windhoek','Namibia',825418,2113077),
  	('Zaire','ZRE','Kinshasa','Kinshasa',2345410,86026000),
  	('Zambia','Z','Lusaka','Lusaka',752610,13092666),
  	('Benin','BEN','Porto-Novo','Benin',112620,9983884),
  	('Burkina Faso','BF','Ouagadougou','Burkina Faso',274200,17322796),
  	('Nigeria','WAN','Abuja','Abuja',923770,193392500),
  	('Togo','RT','Lomé','Togo',56790,6191155),
  	('Botswana','RB','Gaborone','Botswana',600370,2038228),
  	('South Africa','RSA','Tshwane','Gauteng',1219912,51770560),
  	('Zimbabwe','ZW','Harare','Zimbabwe',390580,13061239),
  	('Cote d''Ivoire','CI','Yamoussoukro','Yamoussoukro',322460,22671331),
  	('Ghana','GH','Accra','Greater Accra',238540,24658823),
  	('Burundi','BI','Bujumbura','Burundi',27830,8444784),
  	('Rwanda','RWA','Kigali','Rwanda',26340,10515973),
  	('Tanzania','EAT','Dodoma','Dodoma',945090,44928923),
  	('Cameroon','CAM','Yaoundé','Centre',475440,19406100),
  	('Central African Republic','RCA','Bangui','Central African Republic',622980,4349921),
  	('Chad','TCH','N''Djamena','Chad',1284000,11720781),
  	('Equatorial Guinea','GQ','Malabo','Insular',28050,696167),
  	('Gabon','G','Libreville','Gabon',267670,1556222),
  	('Cape Verde','CV','Praia','Cape Verde',4033,491875),
  	('Sudan','SUD','Khartoum','Sudan',1861484,35652002),
  	('South Sudan','SSD','Juba','South Sudan',644329,8260490),
  	('Comoros','COM','Moroni','Comoros',2170,683081),
  	('Guinea','RG','Conakry','Guinea',245860,10628972),
  	('Liberia','LB','Monrovia','Liberia',111370,3957990),
  	('Djibouti','DJI','Djibouti','Djibouti',22000,834036),
  	('Eritrea','ER','Asmara','Eritrea',121320,5741159),
  	('Ethiopia','ETH','Addis Ababa','Addis Ababa',1127127,84320987),
  	('Somalia','SP','Mogadishu','Somalia',637660,9636173),
  	('Kenya','EAK','Nairobi','Kenya',582650,40909194),
  	('Gambia','WAG','Banjul','Gambia',11300,1882450),
  	('Senegal','SN','Dakar','Dakar',196190,13508715),
  	('Guinea-Bissau','GNB','Bissau','Guinea-Bissau',36120,1586624),
  	('Sierra Leone','WAL','Freetown','Sierra Leone',71740,5751976),
  	('Uganda','EAU','Kampala','Central',236040,34634650),
  	('Lesotho','LS','Maseru','Lesotho',30350,2007201),
  	('Madagascar','RM','Antananarivo','Madagascar',587041,21842167),
  	('Malawi','MW','Lilongwe','Malawi',118480,15013694),
  	('Mozambique','MOC','Maputo','Cidade de Maputo',801590,23700715),
  	('Mauritius','MS','Port Louis','Mauritius',2040,1237091),
  	('Mayotte','MAYO','Mamoutzou','Mayotte',374,256518),
  	('Swaziland','SD','Mbabane','Swaziland',17360,1193148),
  	('Reunion','REUN','Saint-Denis','Reunion',2510,828581),
  	('Saint Helena','HELX','Jamestown','Saint Helena',391,5663),
  	('Sao Tome and Principe','STP','São Tomé','Sao Tome and Principe',1001,187356),
  	('Seychelles','SY','Victoria','Seychelles',455,90945)
  ;