| CARVIEW |
Select Language
HTTP/2 200
date: Fri, 10 Oct 2025 22:42:52 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=2538bfc92fee2a2213ad668d4e5784724f2265f6ba97a77cca762ae5b84b977ca%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%229cjvDEwRDkto0Y3zTFlBeo8lgb8oBIbj%22%3B%7D; HttpOnly; Path=/
cf-ray: 98c9a2257c4be8e0-BLR
Task 9 - SQL - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SUM(ASD.BETRAG) + SUM(ASD.BETRAGSTP) + SUM(ASD.CALCSTATSTEUERBETRAG) AS "Total Income",
- SWA.ISOWAEHRUNGSCODE AS "Currency order",
- SUM(ASDG.BETRAG) + SUM(ASDG.BETRAGSTP) + SUM(ASDG.CALCSTATSTEUERBETRAG) AS "Total Expenses",
- SW.ISOWAEHRUNGSCODE AS "Currency Tour",
- AKOPF.AUFTRAGSNUMMER AS "Order number",
- SH.BEZEICHNUNG AS "Order organisation",
- SK.NAME1 AS "Customer Name",
- SUM(ASD.BETRAG) AS "Amount order",
- SUM(ASD.BETRAGSTP) AS "Amount without TAX order",
- SUM(ASD.CALCSTATSTEUERBETRAG) AS "TAX Amount order",
- -- SHI.BEZEICHNUNG AS "Tour Organisation",
- -- ATOUR.TOURNUMMER AS "Tour numbers",
- LISTAGG(ATOUR.TOURNUMMER, ', ') WITHIN GROUP (ORDER BY ATOUR.TOURNUMMER) AS "Tour numbers",
- LISTAGG(SKUN.NAME1, ', ') WITHIN GROUP (ORDER BY SKUN.NAME1) AS "Carrier Name",
- LISTAGG(SHI.BEZEICHNUNG, ', ') WITHIN GROUP (ORDER BY SHI.BEZEICHNUNG) AS "Tour Organisation",
- -- SKUN.NAME1 AS "Carrier Name",
- SUM(ASDG.BETRAG) AS "Amount tour",
- SUM(ASDG.BETRAGSTP) AS "Amount without TAX tour",
- SUM(ASDG.CALCSTATSTEUERBETRAG) AS "TAX Amount tour"
- FROM
- AKOPF
- LEFT JOIN
- SHIERARCHIE SH ON SH.ID = AKOPF.HIERARCHIE
- LEFT JOIN
- ASENDUNG ON ASENDUNG.AKOPFNR = AKOPF.NR
- LEFT JOIN
- SKUNDEN SK ON SK.NR = AKOPF.FRACHTAGNR
- LEFT JOIN
- ASDGABRECHNUNG ASD ON ASD.ASENDUNGID = ASENDUNG.SENDUNGID
- LEFT JOIN
- SWAEHRUNG SWA ON SWA.ID = ASD.WAEHRUNGID
- LEFT JOIN
- ATASEND ON ASENDUNG.SENDUNGID = ATASEND.ASENDUNGID
- LEFT JOIN
- ATOUR ON ATASEND.TOURNR = ATOUR.NR
- LEFT JOIN
- SHIERARCHIE SHI ON SHI.ID = ATOUR.HIERARCHIE
- LEFT JOIN
- SKUNDEN SKUN ON SKUN.NR = ATOUR.UNTERNEHMER
- LEFT JOIN
- ASDGABRECHNUNG ASDG ON ASDG.ATAID = ATASEND.NR
- LEFT JOIN
- SWAEHRUNG SW ON SW.ID = ASDG.WAEHRUNGID
- WHERE
- AKOPF.AUFTRAGSNUMMER IN (633168, 633104, 634503)
- GROUP BY
- AKOPF.AUFTRAGSNUMMER,
- SH.BEZEICHNUNG,
- SK.NAME1,
- SWA.ISOWAEHRUNGSCODE,
- -- ATOUR.TOURNUMMER,
- -- SHI.BEZEICHNUNG,
- SW.ISOWAEHRUNGSCODE;
- -- SKUN.NAME1;
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐Exchange Exploit T 3⭐⭐
Java | 2 sec ago | 0.10 KB
-
⭐⭐Exchange Exploit⭐⭐ L
JavaScript | 6 sec ago | 0.24 KB
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ 7
JavaScript | 9 sec ago | 0.24 KB
-
⭐⭐⭐Profit Method⭐⭐
Java | 14 sec ago | 0.10 KB
-
✅⭐ Make huge profits on trading ⭐⭐ A
JavaScript | 18 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ C
JavaScript | 20 sec ago | 0.24 KB
-
⭐⭐⭐Crypto Accounts⭐⭐
Java | 27 sec ago | 0.10 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ G
JavaScript | 31 sec ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
