diff options
Diffstat (limited to 'ws2015/dbs/blaetter/08/abgabe.md')
| -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 | ~~~ |