Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select marke.tankstellemarkenr, marke.bezeichnung, sum(b.betrag)
- from beleg b
- left join tankstelle t on b.tankstellenr = t.tankstellenr
- left join tankstellemarke marke on t.tankstellemarkenr = marke.tankstellemarkenr
- group by marke.tankstellemarkenr
- order by 3 desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement