From e8c39f8f4cd6037046fd360a8c0024718ec3b293 Mon Sep 17 00:00:00 2001 From: Gregor Kleen Date: Wed, 9 Dec 2015 12:43:27 +0100 Subject: fix --- ws2015/dbs/blaetter/08/abgabe.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'ws2015') 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 d) ~~~ {.sql} -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 +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 ~~~ -- cgit v1.2.3