By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
OrderDate | lag | diff | ld |
---|---|---|---|
2020-01-12 | null | -1 | 1 |
2020-01-13 | 2020-01-12 | 1 | 0 |
2020-01-14 | 2020-01-13 | 1 | 0 |
2020-01-15 | 2020-01-14 | 1 | 0 |
2020-01-16 | 2020-01-15 | 1 | 0 |
2020-01-17 | 2020-01-16 | 1 | 0 |
2020-01-18 | 2020-01-17 | 1 | 0 |
2020-01-20 | 2020-01-18 | 2 | 1 |
2020-01-21 | 2020-01-20 | 1 | 0 |
2020-01-22 | 2020-01-21 | 1 | 0 |
2020-01-23 | 2020-01-22 | 1 | 0 |
streak |
---|
5 |