By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BUDGET_ID | BUDGET_TYPE | PRODUCT_NO | BUDGET_TWD_AMOUNT | BUDGET_QTY |
---|---|---|---|---|
1 | Order | AZ0001 | 200.00 | 20.00 |
2 | Order | AX0001 | 25.00 | 5.00 |
3 | Sales | AZ0001 | 150.00 | 15.00 |
4 | Sales | AZ0001 | 25.00 | 5.00 |
5 | Order | AC0001 | 80.00 | 10.00 |
6 | Order | AC0002 | 50.00 | 5.00 |
7 | Order | AC0003 | 70.00 | 7.00 |