By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
| product | date | revenue | prevdate | prevrevenue |
|---|---|---|---|---|
| A | 2021-05-10 | 20 | 2020-04-10 | 7 |
| A | 2021-03-20 | 10 | 2020-03-10 | 6 |
| A | 2020-01-10 | 5 | null | null |
| A | 2020-03-10 | 6 | null | null |
| A | 2020-04-10 | 7 | null | null |