By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | class | amount |
---|---|---|
1 | A | 0.25 |
1 | B | 0.25 |
1 | B | 0.25 |
1 | C | 0.25 |
1 | C | 0.25 |
1 | C | 0.25 |
2 | A | 0.25 |
2 | B | 0.25 |
2 | B | 0.25 |
2 | C | 0.25 |
2 | C | 0.25 |
2 | C | 0.25 |
id | totals |
---|---|
1 | A:0.5 / B:1 / C:1.5 |
2 | A:0.5 / B:1 / C:1.5 |