Relationale Datenbanken kennenlernen und ausprobieren!

CREATE TABLE Staat (
   id INT PRIMARY KEY,
   Name VARCHAR(50),
   Bevölkerung INT,
   Fläche INT,
   Gründungsdatum DATE)
 
INSERT INTO staat (id, name, bevölkerung, fläche, gründungsdatum) VALUES
(1,'Afghanistan',44700000,652230,'1919-08-19'),
(2,'Ägypten',119000000,1002450,'1922-02-28'),
(3,'Albanien',2751000,28748,'1912-11-28'),
(4,'Algerien',48000000,2381741,'1962-07-05'),
(5,'Andorra',84000,468,'1278-09-08'),
(6,'Angola',40000000,1246700,'1975-11-11'),
(7,'Antigua und Barbuda',95000,442,'1981-11-01'),
(8,'Äquatorialguinea',1984000,28051,'1968-10-12'),
(9,'Argentinien',46000000,2780400,'1816-07-09'),
(10,'Armenien',2970000,29743,'1991-09-21'),
(11,'Aserbaidschan',10450000,86600,'1991-10-18'),
(12,'Äthiopien',138000000,1104300,'0001-01-01'),
(13,'Australien',27227000,7692024,'1901-01-01'),
(14,'Bahamas',405000,13943,'1973-07-10'),
(15,'Bahrain',1640000,786,'1971-08-15'),
(16,'Bangladesch',177800000,148460,'1971-03-26'),
(17,'Barbados',283000,430,'1966-11-30'),
(18,'Belarus',8937000,207600,'1991-08-25'),
(19,'Belgien',11800000,30528,'1830-10-04'),
(20,'Belize',429000,22966,'1981-09-21'),
(21,'Benin',15170000,114763,'1960-08-01'),
(22,'Bhutan',802000,38394,'1907-12-17'),
(23,'Bolivien',12750000,1098581,'1825-08-06'),
(24,'Bosnien und Herzegowina',3150000,51197,'1992-03-01'),
(25,'Botswana',2603000,581730,'1966-09-30'),
(26,'Brasilien',213563000,8515767,'1822-09-07'),
(27,'Brunei',470000,5765,'1984-01-01'),
(28,'Bulgarien',6668000,110879,'1908-09-22'),
(29,'Burkina Faso',24900000,274200,'1960-08-05'),
(30,'Burundi',14730000,27834,'1962-07-01'),
(31,'Cabo Verde',530000,4033,'1975-07-05'),
(32,'Chile',19946000,756102,'1818-02-12'),
(33,'China',1412914000,9596961,'1949-10-01'),
(34,'Costa Rica',5175000,51100,'1821-09-15'),
(35,'Côte d’Ivoire',33494000,322463,'1960-08-07'),
(36,'Dänemark',6000000,43094,'0965-01-01'),
(37,'Deutschland',83644000,357588,'1990-10-03'),
(38,'Dominica',66000,751,'1978-11-03'),
(39,'Dominikanische Republik',11600000,48671,'1844-02-27'),
(40,'Dschibuti',1200000,23200,'1977-06-27'),
(41,'Ecuador',18445000,276841,'1830-05-13'),
(42,'El Salvador',6370000,21041,'1821-09-15'),
(43,'Eritrea',3683000,117600,'1993-05-24'),
(44,'Estland',1370000,45227,'1991-08-20'),
(45,'Eswatini',1250000,17364,'1968-09-06'),
(46,'Fidschi',937000,18274,'1970-10-10'),
(47,'Finnland',5622000,338455,'1917-12-06'),
(48,'Frankreich',66746000,643801,'1792-09-22'),
(49,'Gabun',2647000,267668,'1960-08-17'),
(50,'Gambia',2880000,11295,'1965-02-18'),
(51,'Georgien',3805000,69700,'1991-04-09'),
(52,'Ghana',35698000,238533,'1957-03-06'),
(53,'Grenada',117000,344,'1974-02-07'),
(54,'Griechenland',9897000,131957,'1830-02-03'),
(55,'Guatemala',18968000,108889,'1821-09-15'),
(56,'Guinea',15442000,245857,'1958-10-02'),
(57,'Guinea-Bissau',2298000,36125,'1973-09-24'),
(58,'Guyana',841000,214969,'1966-05-26'),
(59,'Haiti',12000000,27750,'1804-01-01'),
(60,'Honduras',11100000,112492,'1821-09-15'),
(61,'Indien',1476626000,3287263,'1947-08-15'),
(62,'Indonesien',287886000,1904569,'1945-08-17'),
(63,'Irak',48000000,438317,'1932-10-03'),
(64,'Iran',93168000,1648195,'1979-04-01'),
(65,'Irland',5357000,70273,'1922-12-06'),
(66,'Island',402000,103000,'1944-06-17'),
(67,'Israel',9648000,22072,'1948-05-14'),
(68,'Italien',59100000,301340,'1861-03-17'),
(69,'Jamaika',2830000,10991,'1962-08-06'),
(70,'Japan',122500000,377975,'0660-02-11'),
(71,'Jemen',42200000,527968,'1990-05-22'),
(72,'Jordanien',11600000,89342,'1946-05-25'),
(73,'Kambodscha',18051000,181035,'1953-11-09'),
(74,'Kamerun',30641000,475442,'1960-01-01'),
(75,'Kanada',41600000,9984670,'1867-07-01'),
(76,'Kasachstan',21084000,2724900,'1991-12-16'),
(77,'Katar',3170000,11586,'1971-09-03'),
(78,'Kenia',58400000,580367,'1963-12-12'),
(79,'Kirgisistan',7400000,199951,'1991-08-31'),
(80,'Kiribati',138000,726,'1979-07-12'),
(81,'Kolumbien',53600000,1141748,'1810-07-20'),
(82,'Komoren',899000,1862,'1975-07-06'),
(83,'Kongo, Demokratische Republik',116000000,2344858,'1960-06-30'),
(84,'Kongo, Republik',6400000,342000,'1960-08-15'),
(85,'Kroatien',3822000,56594,'1991-06-25'),
(86,'Kuba',10893000,109884,'1902-05-20'),
(87,'Kuwait',5103000,17818,'1961-06-19'),
(88,'Laos',7974000,236800,'1953-10-22'),
(89,'Lesotho',2389000,30355,'1966-10-04'),
(90,'Lettland',1836000,64589,'1991-08-21'),
(91,'Libanon',5900000,10452,'1943-11-22'),
(92,'Liberia',5800000,111369,'1847-07-26'),
(93,'Libyen',7540000,1759540,'1951-12-24'),
(94,'Liechtenstein',40000,160,'1719-01-23'),
(95,'Litauen',2830000,65300,'1990-03-11'),
(96,'Luxemburg',687000,2586,'1839-04-19'),
(97,'Madagaskar',33522000,587041,'1960-06-26'),
(98,'Malawi',22200000,118484,'1964-07-06'),
(99,'Malaysia',36385000,330803,'1957-08-31'),
(100,'Malediven',532000,300,'1965-07-26'),
(101,'Mali',25000000,1240192,'1960-09-22'),
(102,'Malta',549000,316,'1964-09-21'),
(103,'Marokko',38762000,446550,'1956-03-02'),
(104,'Marshallinseln',35000,181,'1986-10-21'),
(105,'Mauretanien',5461000,1030700,'1960-11-28'),
(106,'Mauritius',1270000,2040,'1968-03-12'),
(107,'Mexiko',133000000,1964375,'1810-09-16'),
(108,'Mikronesien',114000,702,'1986-11-03'),
(109,'Moldau',2400000,33846,'1991-08-27'),
(110,'Monaco',38000,2,'1297-01-08'),
(111,'Mongolei',3557000,1564116,'1921-07-11'),
(112,'Montenegro',626000,13812,'2006-06-03'),
(113,'Mosambik',36640000,801590,'1975-06-25'),
(114,'Myanmar',55000000,676578,'1948-01-04'),
(115,'Namibia',3100000,824292,'1990-03-21'),
(116,'Nauru',12100,21,'1968-01-31'),
(117,'Nepal',29629000,147516,'1768-12-21'),
(118,'Neuseeland',5287000,268838,'1907-09-26'),
(119,'Nicaragua',7097000,130373,'1821-09-15'),
(120,'Niederlande',18449000,41543,'1581-07-26'),
(121,'Niger',28815000,1267000,'1960-08-03'),
(122,'Nigeria',242432000,923768,'1960-10-01'),
(123,'Nordkorea',26660000,120538,'1948-09-09'),
(124,'Nordmazedonien',1820000,25713,'1991-09-08'),
(125,'Norwegen',5653000,385207,'1905-06-07'),
(126,'Oman',5671000,309500,'1650-01-01'),
(127,'Österreich',9107000,83879,'1955-05-15'),
(128,'Pakistan',259300000,881913,'1947-08-14'),
(129,'Palau',18000,459,'1994-10-01'),
(130,'Palästina',5500000,6020,'1988-11-15'),
(131,'Panama',4626000,75417,'1903-11-03'),
(132,'Papua-Neuguinea',10948000,462840,'1975-09-16'),
(133,'Paraguay',7095000,406752,'1811-05-14'),
(134,'Peru',34922000,1285216,'1821-07-28'),
(135,'Philippinen',117000000,300000,'1946-07-04'),
(136,'Polen',37843000,312696,'1918-11-11'),
(137,'Portugal',10395000,92212,'1143-10-05'),
(138,'Ruanda',14890000,26338,'1962-07-01'),
(139,'Rumänien',18801000,238397,'1877-05-09'),
(140,'Russland',143000000,17098246,'1991-12-25'),
(141,'Salomonen',858000,28896,'1978-07-07'),
(142,'Sambia',22500000,752612,'1964-10-24'),
(143,'Samoa',221000,2842,'1962-01-01'),
(144,'San Marino',34000,61,'0301-09-03'),
(145,'São Tomé und Príncipe',245000,964,'1975-07-12'),
(146,'Saudi-Arabien',34500000,2149690,'1932-09-23'),
(147,'Schweden',10701000,450295,'1523-06-06'),
(148,'Schweiz',9008000,41285,'1291-08-01'),
(149,'Senegal',19367000,196722,'1960-04-04'),
(150,'Serbien',6642000,88361,'2006-06-05'),
(151,'Seychellen',135000,455,'1976-06-29'),
(152,'Sierra Leone',8997000,71740,'1961-04-27'),
(153,'Simbabwe',17274000,390757,'1980-04-18'),
(154,'Singapur',5960000,734,'1965-08-09'),
(155,'Slowakei',5451000,49035,'1993-01-01'),
(156,'Slowenien',2115000,20273,'1991-06-25'),
(157,'Somalia',20306000,637657,'1960-07-01'),
(158,'Spanien',48900000,505990,'1492-01-01'),
(159,'Sri Lanka',23300000,65610,'1948-02-04'),
(160,'St. Kitts und Nevis',47000,261,'1983-09-19'),
(161,'St. Lucia',180000,616,'1979-02-22'),
(162,'St. Vincent und die Grenadinen',99000,389,'1979-10-27'),
(163,'Südafrika',65000000,1221037,'1910-05-31'),
(164,'Sudan',52000000,1886068,'1956-01-01'),
(165,'Südkorea',51700000,100210,'1948-08-15'),
(166,'Südsudan',12000000,619745,'2011-07-09'),
(167,'Suriname',645000,163820,'1975-11-25'),
(168,'Syrien',26000000,185180,'1946-04-17'),
(169,'Tadschikistan',10979000,143100,'1991-09-09'),
(170,'Tansania',72564000,947303,'1964-04-26'),
(171,'Thailand',71560000,513120,'1238-01-01'),
(172,'Timor-Leste',1410000,14874,'2002-05-20'),
(173,'Togo',9931000,56785,'1960-04-27'),
(174,'Tonga',103000,747,'1970-06-04'),
(175,'Trinidad und Tobago',1510000,5130,'1962-08-31'),
(176,'Tschad',21560000,1284000,'1960-08-11'),
(177,'Tschechien',10528000,78867,'1993-01-01'),
(178,'Tunesien',12400000,163610,'1956-03-20'),
(179,'Türkei',87926000,783562,'1923-10-29'),
(180,'Turkmenistan',7737000,488100,'1991-10-27'),
(181,'Tuvalu',9400,26,'1978-10-01'),
(182,'Uganda',52700000,241550,'1962-10-09'),
(183,'Ukraine',39536000,603500,'1991-08-24'),
(184,'Ungarn',9586000,93028,'1000-08-20'),
(185,'Uruguay',3382000,176215,'1825-08-25'),
(186,'Usbekistan',37724000,447400,'1991-09-01'),
(187,'Vanuatu',343000,12189,'1980-07-30'),
(188,'Vatikanstadt',800,0,'1929-02-11'),
(189,'Venezuela',28634000,916445,'1811-07-05'),
(190,'Vereinigte Arabische Emirate',11500000,83600,'1971-12-02'),
(191,'Vereinigte Staaten',349035000,9833517,'1776-07-04'),
(192,'Vereinigtes Königreich',69932000,243610,'1707-05-01'),
(193,'Vietnam',102177000,331212,'1945-09-02'),
(194,'Zentralafrikanische Republik',5700000,622984,'1960-08-13'),
(195,'Zypern',1370000,9251,'1960-08-16');