SELECT
A1.AUFTRAGSNUMMER AS "Order number", A1.AEXTERNAUFTRAGSNR AS "Client reference", SKUNDEN.NAME1 AS "Client name", SKUNDEN.MAINLAND AS "Country of the client",
SHIER.NR AS "Number of organisation", SHIER.BEZEICHNUNG AS "Name of organisation", LISTAGG(AT.TOURNUMMER, ', ') WITHIN GROUP (ORDER BY AT.TOURNUMMER) AS "Tour numbers",
TO_CHAR(MIN(ATASEND.VONLADEDATUM), 'DD-MM-YYYY') AS "First loading date"
FROM AKOPF A1