# Übung 3 Aufgabe 3 - Simon Stadlinger, Julian Baumann
#### a)

SELECT Name, Kontinent FROM Land WHERE Bevoelkerung > 200.000.000

#### b)

SELECT Name FROM Stadt JOIN Land ON Stadt.StadtName = Land.Hauptstadt WHERE Land.Bevoelkerung<(2*Stadt.p1950) OR Land.Bevoelkerung < (4*Stadt.p200)

#### c)

SELECT Name FROM Land JOIN Geographie 
EXCEPT 
SELECT Name 
FROM Land JOIN (SELECT * 
                FROM (SELECT * 
                    FROM Geographie AS G1, (SELECT urbar FROM Geographie AS G2)
                    WHERE G1.urbar<G2.urbar))