By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| PERSON | MONTH | PROFIT | LAST_YEAR_PROFIT |
|---|---|---|---|
| John | 01-JUN-21 | 430 | null |
| John | 01-JUN-22 | 100 | 430 |
| Mary | 01-MAY-22 | 200 | null |
3 rows affected
| PERSON | MONTH | PROFIT | LAST_YEAR_PROFIT |
|---|---|---|---|
| John | 01-JUN-21 | 430 | null |
| John | 01-JUN-22 | 100 | 430 |
| Mary | 01-MAY-22 | 200 | null |