By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | item_no | store_no | quantity | priority |
|---|---|---|---|---|
| 1 | 100115 | P026 | 1 | 15 |
| 2 | 100115 | P030 | 1 | 19 |
| 3 | 100116 | P015 | 3 | 14 |
| 4 | 100116 | P017 | 1 | 2 |
| 5 | 100116 | P002 | 1 | 11 |
| 6 | 100117 | P021 | 1 | 9 |
| 7 | 100117 | P033 | 3 | 20 |
| 8 | 100117 | P008 | 1 | 22 |
| 9 | 100117 | P007 | 5 | 5 |
| id | item_no | store_no | quantity | priority | new_quantity |
|---|---|---|---|---|---|
| 1 | 100115 | P026 | 1 | 15 | 2 |
| 2 | 100115 | P030 | 1 | 19 | 0 |
| 4 | 100116 | P017 | 1 | 2 | 2 |
| 5 | 100116 | P002 | 1 | 11 | 2 |
| 3 | 100116 | P015 | 3 | 14 | 2 |
| 9 | 100117 | P007 | 5 | 5 | 6 |
| 6 | 100117 | P021 | 1 | 9 | 2 |
| 7 | 100117 | P033 | 3 | 20 | 2 |
| 8 | 100117 | P008 | 1 | 22 | 0 |