| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 12:33:14 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=79d1a1f951f57db4e573eb00c34afb5b8bdad340ea6081f6307e2c10c879f00fa%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22Uv8nVKC7qyhPQ_k-g00rR-Img8GCrEAe%22%3B%7D; HttpOnly; Path=/
cf-ray: 98ce627fca818839-BLR
Task 4 - SQL - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT
- SKUNDEN.NAME1 AS "Name of carrier",
- ATOUR.TOURNUMMER AS "Tour number",
- ATOUR.PREISVORGABEBETRAGGS AS "Price for transport",
- SWAEHRUNG.ISOWAEHRUNGSCODE AS "Currency",
- MIN(ATASEND.VONLADEDATUM) AS "Loading date",
- MAX(ATASEND.VONLIEFERDATUM) AS "Unloading date",
- SHIERARCHIE.EXTERNEREFERENZ1 AS "Team",
- CONCAT(CONCAT(ATOUR.LKWKZ, '/') ,ATOUR.ANHAENGERKZ) AS "Truck and Trailer number"
- FROM
- ATOUR
- LEFT JOIN
- SKUNDEN ON SKUNDEN.NR = ATOUR.UNTERNEHMER
- LEFT JOIN
- ATASEND ON atour.NR = atasend.TOURNR
- LEFT JOIN
- SHIERARCHIE ON SHIERARCHIE.ID = ATOUR.HIERARCHIE
- LEFT JOIN
- swaehrung ON SWAEHRUNG.ID = ATOUR.PREISVORGABEWAEHRUNGIDGS
- GROUP BY
- SKUNDEN.NAME1,
- ATOUR.TOURNUMMER,
- ATOUR.PREISVORGABEBETRAGGS,
- SWAEHRUNG.ISOWAEHRUNGSCODE,
- SHIERARCHIE.EXTERNEREFERENZ1,
- ATOUR.LKWKZ,
- ATOUR.ANHAENGERKZ
- ORDER BY
- ATOUR.TOURNUMMER DESC,
- MIN(ATASEND.VONLADEDATUM) ASC,
- MAX(ATASEND.VONLIEFERDATUM);
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐✅ MAKE $2500 IN 15 MIN⭐⭐⭐ 4
JavaScript | 4 sec ago | 0.24 KB
-
⭐ G2A Bug ⭐ (Get more on BTC swaps) ✅ NEVER S...
JavaScript | 4 sec ago | 0.24 KB
-
⭐✅ Jack's Profit Method ✅ NEVER SEEN BEF...
JavaScript | 13 sec ago | 0.24 KB
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ C
JavaScript | 15 sec ago | 0.24 KB
-
⭐✅ Online Marketplace Exploit ✅ NEVER SEEN BE...
JavaScript | 22 sec ago | 0.24 KB
-
⭐✅ Trading Profit Method ✅ NEVER SEEN BEFORE...
JavaScript | 31 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ 4
JavaScript | 36 sec ago | 0.24 KB
-
⭐ Instant BTC Profit Method ✅ NEVER SEEN BEFO...
JavaScript | 40 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
