By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| a1 | a2 | a3 |
|---|---|---|
| 2021-05-09 | 1 | 2376.1 |
| 2021-05-10 | 1 | 2396.4 |
| 2021-05-11 | 1 | 2403.9 |
| 2021-05-12 | 1 | 2413.8 |
| 2021-05-13 | 1 | 2415.6 |
| 2021-05-10 | 2 | 12396.5 |
| 2021-05-11 | 2 | 12453.8 |
| 2021-05-12 | 2 | 12493.3 |
| 2021-05-13 | 2 | 12515.7 |
| 2021-05-14 | 2 | 12625.2 |
| XDate | XType | PreDegree | Degree | Qty |
|---|---|---|---|---|
| 2021-05-09 | 1 | 2376.1 | 2376.1 | 0 |
| 2021-05-10 | 1 | 2376.1 | 2396.4 | 20.3 |
| 2021-05-11 | 1 | 2396.4 | 2403.9 | 7.5 |
| 2021-05-12 | 1 | 2403.9 | 2413.8 | 9.9 |
| 2021-05-13 | 1 | 2413.8 | 2415.6 | 1.8 |
| 2021-05-10 | 2 | 12396.5 | 12396.5 | 0 |
| 2021-05-11 | 2 | 12396.5 | 12453.8 | 57.3 |
| 2021-05-12 | 2 | 12453.8 | 12493.3 | 39.5 |
| 2021-05-13 | 2 | 12493.3 | 12515.7 | 22.4 |
| 2021-05-14 | 2 | 12515.7 | 12625.2 | 109.5 |
| XDate | P_PreDegree | P_Degree | P_Qty | W_PreDegree | W_Degree | W_Qty |
|---|---|---|---|---|---|---|
| 2021-05-09 | 2376.1 | 2376.1 | 0 | null | null | null |
| 2021-05-10 | 2376.1 | 2396.4 | 20.3 | 12396.5 | 12396.5 | 0 |
| 2021-05-11 | 2396.4 | 2403.9 | 7.5 | 12396.5 | 12453.8 | 57.3 |
| 2021-05-12 | 2403.9 | 2413.8 | 9.9 | 12453.8 | 12493.3 | 39.5 |
| 2021-05-13 | 2413.8 | 2415.6 | 1.8 | 12493.3 | 12515.7 | 22.4 |
| 2021-05-14 | null | null | null | 12515.7 | 12625.2 | 109.5 |