By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| Id | Weight | Type | actual_id | actual_weight |
|---|---|---|---|---|
| 00011223344 | 35 | A | 12311223344 | 35 |
| 00011223344 | 10 | A | 12311223344 | 10 |
| 12311223344 | 100 | B | 12311223344 | 55 |
| 88855667788 | 100 | D | 88855667788 | 100 |
| 00034343434 | 25 | A | 99934343434 | 25 |
| 00034343434 | 25 | A | 99934343434 | 25 |
| 99934343434 | 200 | C | 99934343434 | 150 |