Advertisement
Guest User

Untitled

a guest
Nov 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. select marke.tankstellemarkenr, marke.bezeichnung, sum(b.betrag)
  2. from beleg b
  3. left join tankstelle t on b.tankstellenr = t.tankstellenr
  4. left join tankstellemarke marke on t.tankstellemarkenr = marke.tankstellemarkenr
  5. group by marke.tankstellemarkenr
  6. order by 3 desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement