56 lines
866 B
Markdown
56 lines
866 B
Markdown
1
|
||
a)
|
||
```SQL
|
||
SELECT VORNAME, NACHNAME
|
||
FROM KUNDE
|
||
NATURAL join BESTELLUNG
|
||
NATURAL join BESTELLPOSITION
|
||
WHERE ARTIKELNUMMER=4
|
||
```
|
||
|
||
```SQL
|
||
SELECT VORNAME, NACHNAME
|
||
FROM KUNDE
|
||
WHERE KUNDENNUMMER in(
|
||
SELECT KUNDENNUMMER
|
||
FROM BESTELLUNG
|
||
WHERE BESTELLNUMMER in(
|
||
SELECT BESTELLNUMMER
|
||
FROM BESTELLPOSITION
|
||
WHERE ARTIKELNUMMER=4
|
||
)
|
||
)
|
||
```
|
||
|
||
b)
|
||
kinda wrong
|
||
```SQL
|
||
SELECT vorname, NACHNAME, ARTIKELNAME
|
||
FROM LIEFERER
|
||
natural join LAGER
|
||
join ARTIKEL on LAGER.ANUMMER=ARTIKEL.ARTIKELNUMMER
|
||
order BY ARTIKELNAME
|
||
```
|
||
|
||
```SQL
|
||
|
||
```
|
||
|
||
c)
|
||
```SQL
|
||
SELECT vorname, nachname, ARTIKELNAME
|
||
FROM KUNDE
|
||
NATURAL JOIN BESTELLUNG
|
||
NATURAL JOIN BESTELLPOSITION
|
||
NATURAL join ARTIKEL
|
||
```
|
||
|
||
```SQL
|
||
SELECT vorname, nachname, ARTIKELNAME
|
||
FROM KUNDE
|
||
NATURAL JOIN ( BESTELLUNG
|
||
NATURAL JOIN BESTELLPOSITION
|
||
NATURAL join ARTIKEL)
|
||
```
|
||
|