---
# System prepended metadata

title: 'Übung 3 Aufgabe 3 - Simon Stadlinger, Julian Baumann'

---

# Übung 3 Aufgabe 3 - Simon Stadlinger, Julian Baumann
#### a)
``` sql
SELECT Name, Kontinent FROM Land WHERE Bevoelkerung > 200.000.000
```
#### b)
``` sql
SELECT Name FROM Stadt JOIN Land ON Stadt.StadtName = Land.Hauptstadt WHERE Land.Bevoelkerung<(2*Stadt.p1950) OR Land.Bevoelkerung < (4*Stadt.p200)
```
#### c)
``` sql
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))
    
```