TEMP

// Deel 3
INSERT INTO nasa.nationality (id,iso,un,nationality) VALUES (56, 'BE', 'BEL', 'Belgium');
INSERT INTO nasa.nationality (id,iso,un,nationality) VALUES (528, 'NL', 'NLD', 'Netherlands');
INSERT INTO nasa.nationality (id,iso,un,nationality) VALUES (643, 'RU', 'RUS', 'Russian Federation');
INSERT INTO nasa.nationality (id,iso,un,nationality) VALUES (380, 'IT', 'ITA', 'Italy');
UPDATE astronauts SET nationality = 643 WHERE id>=11;
UPDATE astronauts SET nationality = 380 WHERE id=10;
UPDATE astronauts SET nationality = 528 WHERE id=9;
UPDATE astronauts SET nationality = 56 WHERE id=8;

SELECT astronauts.firstname, astronauts.lastname, nationality.iso
FROM astronauts
INNER JOIN nationality
ON astronauts.nationality=nationality.id;

SELECT astronauts.firstname, astronauts.lastname, nationality.nationality
FROM astronauts
INNER JOIN nationality
ON astronauts.nationality=nationality.id

// Deel 4
Gentse Tripel, Uilenspiegel, Jupiler