This one was obnoxiously difficult for me. Now that I completed it I know what my issue was, the data is provided from a consumer standpoint. A discount is an expense from a supplier standpoint, whereas it's an "amount saved" from a consumer standpoint. Everything fell into place once I realized this, I just had to spend a lot of time comparing the answer key to the data in order to figure it out.
Practice ex 3
Order_ID | Sum_Subtotal | Sum_Discount | Days to Ship |
87222 | 56.86 | 3.28 | 5 |
87399 | 21.32 | 1.41 | 1 |
87399 | 130.96 | 10.06 | 2 |
87399 | 23.57 | 1 | 3 |
88060 | 1502.9 | 119.06 | 0 |
90353 | 76.8 | 2.15 | 1 |
90354 | 12.99 | 0.4 | 1 |
90354 | 6324.4 | 440.99 | 2 |
90355 | 113.46 | 8.36 | 2 |
91515 | 533.84 | 42.23 | 0 |
91516 | 15.25 | 0.38 | 1 |
91519 | 1550.54 | 121.18 | 5 |
91560 | 172.97 | 1.68 | 2 |
91560 | 69.62 | 5.45 | 3 |