Task 15 - SQL

SELECT
AUFTRAGSNUMMER AS "Order number",
NAME1 AS "Customer name",
MIN(BISLADEDATUM) AS "First loading date",
MAX(LIEFERDATUMENDEIST) AS "Final delivery date"
FROM
    AKOPF
JOIN
    SKUNDEN ON SKUNDEN.NR = AKOPF.FRACHTAGNR
JOIN
    ASENDUNG ON AKOPF.NR = ASENDUNG.AKOPFNR
JOIN
    ATASEND ON ASENDUNG.SENDUNGID = ATASEND.ASENDUNGID
WHERE
    AUFTRAGSNUMMER IN (946030, 951548)
GROUP BY
    AUFTRAGSNUMMER,
    NAME1;