diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2015-12-09 12:43:27 +0100 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2015-12-09 12:43:27 +0100 |
| commit | e8c39f8f4cd6037046fd360a8c0024718ec3b293 (patch) | |
| tree | a39a9231ef066f8e904ccd1eecd9caf2e72f39ae /ws2015 | |
| parent | d414ce3baea8202cd832773fbfd48725cef33dd8 (diff) | |
| download | uni-e8c39f8f4cd6037046fd360a8c0024718ec3b293.tar uni-e8c39f8f4cd6037046fd360a8c0024718ec3b293.tar.gz uni-e8c39f8f4cd6037046fd360a8c0024718ec3b293.tar.bz2 uni-e8c39f8f4cd6037046fd360a8c0024718ec3b293.tar.xz uni-e8c39f8f4cd6037046fd360a8c0024718ec3b293.zip | |
fix
Diffstat (limited to 'ws2015')
| -rw-r--r-- | ws2015/dbs/blaetter/08/abgabe.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/ws2015/dbs/blaetter/08/abgabe.md b/ws2015/dbs/blaetter/08/abgabe.md index 634a07e..c5c5913 100644 --- a/ws2015/dbs/blaetter/08/abgabe.md +++ b/ws2015/dbs/blaetter/08/abgabe.md | |||
| @@ -26,5 +26,5 @@ SELECT L.lnr, L.lname, COUNT(LTP.pnr) FROM L, LTP WHERE L.lnr = LTP.lnr, COUNT(L | |||
| 26 | d) | 26 | d) |
| 27 | 27 | ||
| 28 | ~~~ {.sql} | 28 | ~~~ {.sql} |
| 29 | SELECT L.lnr, L.lname, L.lsitz, T.tname, LTP.menge * L.gewicht / LTPSS.aggr * 100 FROM L, T, LTP JOIN (SELECT SUM(LTPS.menge) * TS.gewicht as aggr FROM LTP as LTPS, T as TS WHERE LTP.tnr = LTPS.tnr AND TS.tnr = LTPS.tnr GROUP BY LTPS.tnr) as LTPSS USING LTP.tnr WHERE L.lnr = LTP.lnr AND T.tnr = LTP.tnr GROUP BY LTP.tnr | 29 | SELECT LTP.tnr as tnr, L.lnr, L.lname, L.lsitz, T.tname, LTP.menge * L.gewicht / LTPSS.aggr * 100 FROM L, T, LTP JOIN (SELECT LTPS.tnr as tnr, SUM(LTPS.menge) * TS.gewicht as aggr FROM LTP as LTPS, T as TS WHERE LTP.tnr = LTPS.tnr AND TS.tnr = LTPS.tnr GROUP BY LTPS.tnr) as LTPSS USING tnr WHERE L.lnr = LTP.lnr AND T.tnr = LTP.tnr GROUP BY LTP.tnr |
| 30 | ~~~ | 30 | ~~~ |