By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| Date | Quota | Yield | shortage | surplus | rn | netshort |
|---|---|---|---|---|---|---|
| 2000-01-01 | 30 | 30 | 0 | 0 | 1 | 0 |
| 2000-01-05 | 30 | 25 | -5 | 0 | 2 | -5 |
| 2000-01-06 | 30 | 30 | 0 | 0 | 3 | -5 |
| 2000-01-09 | 30 | 28 | -2 | 0 | 4 | -7 |
| 2000-01-15 | 30 | 34 | 0 | 4 | 5 | -3 |
| 2000-01-17 | 30 | 30 | 0 | 0 | 6 | -3 |
| 2000-01-19 | 30 | 29 | -1 | 0 | 7 | -4 |
| 2000-01-20 | 30 | 37 | 0 | 7 | 8 | 0 |
| 2000-01-21 | 30 | 32 | 0 | 2 | 9 | 0 |
| 2000-01-24 | 30 | 27 | -3 | 0 | 10 | -3 |
| 2000-01-25 | 30 | 30 | 0 | 0 | 11 | -3 |