+------+------+------+-----------+----------+
| :sid | :pid | :qty | :position | :sum_qty |
+------+------+------+-----------+----------+
| S1   | P6   |  100 |         1 |      100 |
| S1   | P5   |  100 |         2 |      200 |
| S1   | P2   |  200 |         3 |      400 |
| S1   | P4   |  200 |         4 |      600 |
| S1   | P1   |  300 |         5 |      900 |
| S1   | P3   |  400 |         6 |     1300 |
| S2   | P1   |  300 |         1 |      300 |
| S2   | P2   |  400 |         2 |      700 |
| S3   | P2   |  200 |         1 |      200 |
| S4   | P2   |  200 |         1 |      200 |
| S4   | P4   |  300 |         2 |      500 |
| S4   | P5   |  400 |         3 |      900 |
+------+------+------+-----------+----------+