SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table kontoauszug 
(
  behaelter_id int, 
  lieferschein int,
  stueck int
)
✓
insert into kontoauszug (behaelter_id, stueck, lieferschein)
values
(3101208, 6, 14543819),
(3101208, 1, 14543819),
(3101208, -6, 14543819),
(3101208, -1, 14543819),
(3101208, 6, 14543819),
(3101208, 1, 14543819)
✓
select behaelter_id, lieferschein, sum(stueck) 
from kontoauszug
group by behaelter_id, lieferschein


behaelter_id
lieferschein
sum(stueck)


3101208
14543819
7