CREATE TABLE countries (

id SERIAL PRIMARY KEY,

name VARCHAR(100) NOT NULL,

continent VARCHAR(50) NOT NULL,

area NUMERIC(15,0),

population BIGINT,

gdp NUMERIC(18,0),

capital VARCHAR(100),

tld VARCHAR(10)

);

INSERT INTO countries (name, continent, area, population, gdp, capital, tld)

('Albania', 'Europe', 28748, 2821977, 12044000000, 'Tirana', '.al'),

('Algeria', 'Africa', 2381741, 38700000, 207021000000, 'Algiers', '.dz'),

('Andorra', 'Europe', 468, 76098, 3222000000, 'Andorra la Vella', '.ad'),

('Angola', 'Africa', 1246700, 19183590, 116308000000, 'Luanda', '.ao'),

('Argentina', 'South America', 2780400, 42669500, 477028000000, 'Buenos Aires', '.ar'),

('Antigua and Barbuda', 'Caribbean', 442, 86295, 1176000000, 'St. John''s', '.ag'),

('Armenia', 'Eurasia', 29743, 3017400, 9950000000, 'Yerevan', '.am'),

('Australia', 'Oceania', 7692024, 23545500, 1564419000000, 'Canberra', '.au'),

('Austria', 'Europe', 83871, 8504850, 394458000000, 'Vienna', '.at'),

('Azerbaijan', 'Asia', 86600, 9477100, 68727000000, 'Baku', '.az'),

('Bahamas', 'Caribbean', 13878, 351461, 8043000000, 'Nassau', '.bs'),

('Bahrain', 'Asia', 765, 1234571, 30362000000, 'Manama', '.bh'),

('Bangladesh', 'Asia', 147570, 156557000, 127195000000, 'Dhaka', '.bd'),

('Barbados', 'Caribbean', 430, 285000, 4533000000, 'Bridgetown', '.bb'),

('Belarus', 'Europe', 207600, 9467000, 63259000000, 'Minsk', '.by'),

('Belgium', 'Europe', 30528, 11198638, 483402000000, 'City of Brussels', '.be'),

('Belize', 'North America', 22966, 349728, 1554000000, 'Belmopan', '.bz'),

('Benin', 'Africa', 112622, 9988068, 7557000000, 'Porto-Novo', '.bj'),

('Bhutan', 'Asia', 38394, 749090, 1861000000, 'Thimphu', '.bt'),

('Bolivia', 'South America', 1098581, 10027254, 27035000000, 'Sucre', '.bo'),

('Bosnia and Herzegovina', 'Europe', 51209, 3791622, 17319000000, 'Sarajevo', '.ba'),

('Botswana', 'Africa', 582000, 2024904, 14410000000, 'Gaborone', '.bw'),

('Brazil', 'South America', 8515767, 202794000, 2254109000000, 'Brasília', '.br'),

('Brunei', 'Asia', 5765, 393162, 16954000000, 'Bandar Seri Begawan', '.bn'),

('Bulgaria', 'Europe', 110879, 7245677, 50972000000, 'Sofia', '.bg'),

('Burkina Faso', 'Africa', 272967, 17322796, 10687000000, 'Ouagadougou', '.bf'),

('Burundi', 'Africa', 27834, 9420248, 2257000000, 'Bujumbura', '.bi'),

('Cambodia', 'Asia', 181035, 15184116, 14038000000, 'Phnom Penh', '.kh'),

('Cameroon', 'Africa', 475442, 20386799, 26094000000, 'Yaoundé', '.cm'),

('Canada', 'North America', 9984670, 35427524, 1585000000000, 'Ottowa', '.ca'),

('Cape Verde', 'Africa', 4033, 491875, 1903000000, 'Praia', '.cv'),

('Central African Republic', 'Africa', 622984, 4709000, 2184000000, 'Bangui', '.cf'),

('Chad', 'Africa', 1284000, 13211000, 10183000000, 'N''Djamena', '.td'),

('Chile', 'South America', 756102, 17773000, 268314000000, 'Santiago', '.cl'),

('China', 'Asia', 9596961, 1365370000, 8358400000000, 'Beijing', '.cn'),

('Colombia', 'South America', 1141748, 47662000, 369813000000, 'Bogotá', '.co'),

('Comoros', 'Africa', 1862, 743798, 616000000, 'Moroni', '.km'),

('Congo, Democratic Republic of', 'Africa', 2345000, 69360000, 0, 'Kinshasa', '.cd'),

('Congo, Republic of', 'Africa', 342000, 4559000, 0, 'Brazzaville', '.cg'),

('Costa Rica', 'North America', 51100, 4667096, 45107000000, 'San José', '.cr'),

('Côte d''Ivoire', 'Africa', 322483, 23919000, 34506000000, 'Yamoussoukro', '.ci'),

('Croatia', 'Europe', 56594, 4290612, 56447000000, 'Zagreb', '.hr'),

('Cuba', 'Caribbean', 109884, 11167325, 71017000000, 'Havana', '.cu'),

('Cyprus', 'Asia', 9251, 865878, 22768000000, 'Nicosia', '.cy'),

('Czech Republic', 'Europe', 78865, 10517400, 196446000000, 'Prague', '.cz'),

('Denmark', 'Europe', 43094, 5634437, 314889000000, 'Copenhagen', '.dk'),

('Djibouti', 'Africa', 23200, 886000, 1361000000, 'Djibouti', '.dj'),

('Dominica', 'Caribbean', 751, 71293, 499000000, 'Roseau', '.dm'),

('Dominican Republic', 'Caribbean', 48671, 9445281, 58898000000, 'Santo Domingo', '.do'),

('Ecuador', 'South America', 276841, 15774200, 87495000000, 'Quito', '.ec'),

('Egypt', 'Asia', 1002450, 86736900, 254671000000, 'Cairo', '.eg'),

('El Salvador', 'North America', 21041, 6384000, 23864000000, 'San Salvador', '.sv'),

('Equatorial Guinea', 'Africa', 28051, 1622000, 14491000000, 'Malabo', '.gq'),

('Eritrea', 'Africa', 117600, 6536000, 3108000000, 'Asmara', '.er'),

('Estonia', 'Europe', 45227, 1315819, 22376000000, 'Tallinn', '.ee'),

('Ethiopia', 'Africa', 1104300, 87952991, 41605000000, 'Addis Ababa', '.et'),

('Fiji', 'Oceania', 18272, 858038, 3999000000, 'Suva', '.fj'),

('Finland', 'Europe', 338424, 5458038, 247389000000, 'Helsinki', '.fi'),

('France', 'Europe', 640679, 65906000, 2611221000000, 'Paris', '.fr'),

('Gabon', 'Africa', 267668, 1711000, 24076000000, 'Libreville', '.ga'),

('Gambia', 'Africa', 11295, 1882450, 0, 'Banjul', '.gm'),

('Georgia', 'Asia', 69700, 4490500, 15830000000, 'Tbilisi', '.ge'),

('Germany', 'Europe', 357114, 80716000, 3425956000000, 'Bonn', '.de'),

('Ghana', 'Africa', 238533, 27043093, 40711000000, 'Accra', '.gh'),

('Greece', 'Europe', 131990, 11123034, 248941000000, 'Athens', '.gr'),

('Grenada', 'Caribbean', 344, 103328, 783000000, 'St. George''s', '.gd'),

('Guatemala', 'North America', 108889, 15806675, 50377000000, 'Guatemala City', '.gt'),

('Guinea', 'Africa', 245857, 10824200, 6092000000, 'Conakry', '.gn'),

('Guinea-Bissau', 'Africa', 36125, 1746000, 849000000, 'Bissau', '.gw'),

('Guyana', 'South America', 214969, 784894, 2851000000, 'Georgetown', '.gy'),

('Haiti', 'Caribbean', 27750, 10413211, 7187000000, 'Port-au-Prince', '.ht'),

('Honduras', 'North America', 112492, 8555072, 18564000000, 'Tegucigalpa', '.hn'),

('Hungary', 'Europe', 93028, 9879000, 124600000000, 'Budapest', '.hu'),

('Iceland', 'Europe', 103000, 326340, 13579000000, 'Reykjavík', '.is'),

('India', 'Asia', 3166414, 1246160000, 1875213000000, 'New Delhi', '.in'),

('Indonesia', 'Asia', 1904569, 252164800, 878043000000, 'Jakarta', '.id'),

('Iran', 'Asia', 1648195, 77552000, 551588000000, 'Tehran', '.ir'),

('Iraq', 'Asia', 438317, 36004552, 149370000000, 'Baghdad', '.iq'),

('Ireland', 'Europe', 70273, 4593100, 210638000000, 'Dublin', '.ie'),

('Israel', 'Asia', 20770, 8193900, 241069000000, 'Jerusalem', '.il'),

('Italy', 'Europe', 301336, 60782668, 2013392000000, 'Rome', '.it'),

('Jamaica', 'Caribbean', 10991, 2717991, 14795000000, 'Kingston', '.jm'),

('Japan', 'Asia', 377930, 127090000, 5960180000000, 'Imperial Tokyo', '.jp'),

('Jordan', 'Asia', 89342, 6602190, 30937000000, 'Amman', '.jo'),

('Kazakhstan', 'Europe', 2724900, 17244000, 202656000000, 'Astana', '.kz'),

('Kenya', 'Africa', 580367, 45546000, 40697000000, 'Nairobi', '.ke'),

('Kiribati', 'Oceania', 811, 106461, 176000000, 'South Tarawa', '.ki'),

('Kuwait', 'Asia', 17818, 3065850, 183219000000, 'Kuwait City', '.kw'),

('Kyrgyzstan', 'Asia', 199951, 5776570, 6475000000, 'Bishkek', '.kg'),

('Laos', 'Asia', 236800, 6580800, 9100000000, 'Vientiane', '.la'),

('Latvia', 'Europe', 64559, 1996500, 28379000000, 'Riga', '.lv'),

('Lebanon', 'Asia', 10452, 4966000, 42490000000, 'Beirut', '.lb'),

('Lesotho', 'Africa', 30355, 2098000, 2443000000, 'Maseru', '.ls'),

('Liberia', 'Africa', 111369, 4397000, 1491000000, 'Monrovia', '.lr'),

('Libya', 'Africa', 1759540, 6253000, 95802000000, 'Tripoli', '.ly'),

('Liechtenstein', 'Europe', 160, 37132, 5827000000, 'Vaduz', '.li'),

('Lithuania', 'Europe', 65300, 2939431, 42339000000, 'Vilnius', '.lt'),

('Luxembourg', 'Europe', 2586, 549700, 55143000000, 'Luxembourg', '.lu'),

('Macedonia', 'Europe', 25713, 2062294, 0, 'Skopje', '.mk'),

('Madagascar', 'Africa', 587041, 21263403, 9968000000, 'Antananarivo', '.mg'),

('Malawi', 'Africa', 118484, 16829000, 5653000000, 'Lilongwe', '.mw'),

('Malaysia', 'Asia', 330803, 30177000, 304726000000, 'Kuala Lumpur', '.my'),

('Maldives', 'Asia', 300, 317280, 2606000000, 'Malé', '.mv'),

('Mali', 'Africa', 1240192, 15768000, 10262000000, 'Bamako', '.ml'),

('Malta', 'Europe', 316, 416055, 8775000000, 'Valletta', '.mt'),

('Marshall Islands', 'Oceania', 181, 56086, 198000000, 'Majuro', '.mh'),

('Mauritania', 'Africa', 1030700, 3461041, 3866000000, 'Nouakchott', '.mr'),

('Mauritius', 'Africa', 2040, 1257900, 11452000000, 'Port Louis', '.mu'),

('Mexico', 'North America', 1964375, 119713203, 1183655000000, 'Mexico City', '.mx'),

('Micronesia, Federated States of', 'Oceania', 702, 101351, 327000000, 'Palikir', '.fm'),

('Moldova', 'Europe', 33846, 3557600, 7253000000, 'Chișinău', '.md'),

('Monaco', 'Europe', 2, 36950, 5707000000, 'Monaco-Ville', '.mc'),

('Mongolia', 'Asia', 1564110, 2931300, 10271000000, 'Ulaanbaatar', '.mn'),

('Montenegro', 'Europe', 13812, 620029, 4046000000, 'Podgorica', '.me'),

('Morocco', 'Africa', 446550, 33307500, 95992000000, 'Rabat', '.ma'),

('Mozambique', 'Africa', 801590, 23700715, 14605000000, 'Maputo', '.mz'),

('Myanmar', 'Asia', 676578, 61120000, 59444000000, 'Naypyidaw', '.mm'),

('Namibia', 'Africa', 825615, 2113077, 12807000000, 'Windhoek', '.na'),

('Nauru', 'Oceania', 21, 9945, 121000000, 'Yaren District', '.nr'),

('Nepal', 'Asia', 147181, 26494504, 18029000000, 'Kathmandu', '.np'),

('Netherlands', 'Europe', 41543, 16857500, 800535000000, 'Amsterdam', '.nl'),

('New Zealand', 'Oceania', 270467, 4538520, 171256000000, 'Wellington', '.nz'),

('Nicaragua', 'North America', 130373, 6071045, 10508000000, 'Managua', '.ni'),

('Niger', 'Africa', 1267000, 17138707, 6773000000, 'Niamey', '.ne'),

('Nigeria', 'Africa', 923768, 178517000, 286470000000, 'Abuja', '.ng'),

('North Korea', 'Asia', 120538, 25027000, 14411000000, 'Pyongyang', '.kp'),

('Norway', 'Europe', 323802, 5124383, 499667000000, 'Oslo', '.no'),

('Oman', 'Asia', 309500, 4020000, 78111000000, 'Muscat', '.om'),

('Pakistan', 'Asia', 881912, 188020000, 215117000000, 'Islamabad', '.pk'),

('Palau', 'Oceania', 459, 20901, 213000000, 'Ngerulmud', '.pw'),

('Panama', 'North America', 75417, 3405813, 36253000000, 'Panama City', '.pa'),

('Papua New Guinea', 'Oceania', 462840, 7398500, 15677000000, 'Port Moresby', '.pg'),

('Paraguay', 'South America', 406752, 6783374, 25935000000, 'Asunción', '.py'),

('Peru', 'South America', 1285216, 30475144, 204681000000, 'Lima', '.pe'),

('Philippines', 'Asia', 342353, 99804200, 250182000000, 'Manila', '.ph'),

('Poland', 'Europe', 312679, 38496000, 489852000000, 'Warsaw', '.pl'),

('Portugal', 'Europe', 92090, 10477800, 212139000000, 'Lisbon', '.pt'),

('Qatar', 'Asia', 11586, 2174035, 192402000000, 'Doha', '.qa'),

('Romania', 'Europe', 238391, 19942642, 169396000000, 'Bucharest', '.ro'),

('Russia', 'Eurasia', 17125242, 146000000, 2029812000000, 'Moscow', '.ru'),

('Rwanda', 'Africa', 26338, 10537222, 7103000000, 'Kigali', '.rw'),

('Saint Kitts and Nevis', 'North America', 261, 55000, 765000000, 'Basseterre', '.kn'),

('Saint Lucia', 'Caribbean', 616, 180000, 1318000000, 'Castries', '.lc'),

('Saint Vincent and the Grenadines', 'South America', 389, 109000, 694000000, 'Kingstown', '.vc'),

('Samoa', 'Oceania', 2842, 187820, 681000000, 'Apia', '.ws'),

('San Marino', 'Europe', 61, 32637, 1853000000, 'San Marino', '.sm'),

('Sao Tomé and Príncipe', 'Africa', 964, 190428, 707000000, 'São Tomé', '.st'),

('Saudi Arabia', 'Asia', 2149690, 29994272, 711050000000, 'Riyadh', '.sa'),

('Senegal', 'Africa', 196722, 12873601, 13962000000, 'Dakar', '.sn'),

('Serbia', 'Europe', 88361, 7181505, 38491000000, 'Belgrade', '.rs'),

('Seychelles', 'Africa', 452, 90945, 1031000000, 'Victoria', '.sc'),

('Sierra Leone', 'Africa', 71740, 6190280, 43366000000, 'Freetown', '.sl'),

('Singapore', 'Asia', 710, 5399200, 276520000000, 'Singapore', '.sg'),

('Slovakia', 'Europe', 49037, 5415949, 91349000000, 'Bratislava', '.sk'),

('Slovenia', 'Europe', 20273, 2063151, 45380000000, 'Ljubljana', '.si'),

('Solomon Islands', 'Oceania', 28896, 581344, 1010000000, 'Honiara', '.sb'),

('Somalia', 'Africa', 637657, 10806000, 1306000000, 'Mogadishu', '.so'),

('South Africa', 'Africa', 1221037, 52981991, 384313000000, 'Pretoria', '.za'),

('South Korea', 'Asia', 100210, 50423955, 1129598000000, 'Seoul', '.kr'),

('South Sudan', 'Africa', 619745, 11739000, 10060000000, 'Juba', '.ss'),

('Spain', 'Europe', 505992, 46609700, 1322126000000, 'Madrid', '.es'),

('Sri Lanka', 'Asia', 65610, 20277597, 59421000000, 'Sri Jayawardenepura Kotte', '.lk'),

('Sudan', 'Africa', 1886068, 37289406, 51453000000, 'Khartoum', '.sd'),

('Suriname', 'South America', 163820, 534189, 5012000000, 'Paramaribo', '.sr'),

('Swaziland', 'Africa', 17364, 1268000, 3861000000, 'Lobamba', '.sz'),

('Sweden', 'Europe', 450295, 9675885, 523804000000, 'Stockholm', '.se'),

('Switzerland', 'Europe', 41284, 8160900, 631183000000, 'Bern', '.ch'),

('Syria', 'Asia', 185180, 21987000, 46540000000, 'Damascus', '.sy'),

('Taiwan', 'Asia', 36193, 23386883, 0, 'Taipei', '.tw'),

('Tajikistan', 'Asia', 143100, 8160000, 7633000000, 'Dushanbe', '.tj'),

('Tanzania', 'Africa', 945087, 44928923, 28249000000, 'Dodoma', '.tz'),

('Thailand', 'Asia', 513120, 64456700, 385694000000, 'Bangkok', '.th'),

('Timor-Leste', 'Asia', 14874, 1212107, 5387000000, 'Dili', '.tl'),

('Togo', 'Africa', 56785, 6993000, 3917000000, 'Lomé', '.tg'),

('Tonga', 'Oceania', 747, 103036, 465000000, 'Nuku''alofa', '.to'),

('Trinidad and Tobago', 'Caribbean', 5130, 1328019, 23225000000, 'Port of Spain', '.tt'),

('Tunisia', 'Africa', 163610, 10886500, 45132000000, 'Tunis', '.tn'),

('Turkey', 'Asia', 783562, 76667864, 788299000000, 'Ankara', '.tr'),

('Turkmenistan', 'Asia', 488100, 5307000, 33466000000, 'Aşgabat', '.tm'),

('Tuvalu', 'Oceania', 26, 11323, 40000000, 'Funafuti', '.tv'),

('Uganda', 'Africa', 241550, 35357000, 21736000000, 'Kampala', '.ug'),

('Ukraine', 'Europe', 603500, 43009258, 176309000000, 'Kiev', '.ua'),

('United Arab Emirates', 'Asia', 83600, 9446000, 383799000000, 'Abu Dhabi', '.ae'),

('United Kingdom', 'Europe', 242900, 64105700, 2471600000000, 'London', '.uk'),

('United States', 'North America', 9826675, 318320000, 16244600000000, 'Washington, D.C.', '.us'),

('Uruguay', 'South America', 181034, 3286314, 49919000000, 'Montevideo', '.uy'),

('Uzbekistan', 'Asia', 447400, 30492800, 51414000000, 'Tashkent', '.uz'),

('Vanuatu', 'Oceania', 12189, 264652, 752000000, 'Port Vila', '.vu'),

('Vatican City', 'Europe', 0, 839, 0, 'null', '.va'),

('Venezuela', 'South America', 916445, 28946101, 382424000000, 'Caracas', '.ve'),

('Vietnam', 'Asia', 331212, 89708900, 155820000000, 'Hanoi', '.vn'),

('Yemen', 'Asia', 527968, 25235000, 32831000000, 'Sana''a', '.ye'),

('Zambia', 'Africa', 752612, 15023315, 21490000000, 'Lusaka', '.zm'),

('Zimbabwe', 'Africa', 390757, 13061239, 9802000000, 'Harare', '.zw');

CREATE TABLE teachers (

id SERIAL PRIMARY KEY,

dept NUMERIC(15,0),

name VARCHAR(100) NOT NULL,

phone VARCHAR(50),

mobile VARCHAR(50),

employed_at DATE,

birth_date DATE,

salary NUMERIC(15,0)

);

CREATE TABLE departments (

id SERIAL PRIMARY KEY,

name VARCHAR(100) NOT NULL,

phone VARCHAR(50)

);

INSERT INTO teachers (dept, name, phone, mobile, employed_at, birth_date, salary)

(1, 'Shrivell', 'EXT 2753', '0476 40 35 09', '2000-12-05', '1980-09-06', 1000),

(1, 'Throd', 'EXT 2754', '0477 99 66 55', '1982-09-01', '1960-10-03', 2000),

(1, 'Splint', 'EXT 2793', NULL, '2022-03-22', '1995-07-12', 3000),

(NULL, 'Spiregrain', 'EXT 3212', '0799 55 56 57', '1999-06-01', '1979-11-19', 1000),

(2, 'Cutflower', NULL, NULL, '2015-02-16', '1990-03-15', 1000),

(NULL, 'Deadyawn', 'EXT 3345', NULL, '2000-12-05', '1980-11-01', 2000);

INSERT INTO departments (name, phone)

('Computing', 'EXT 2700'),

('Design', 'EXT 3200'),

('Engineering', 'EXT 3000');