By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| GRP | RNK | CATEGORY | NEW_CATEGORY |
|---|---|---|---|
| A | 1 | New business | New business |
| A | 2 | Adjustment | New business |
| A | 3 | Adjustment | New business |
| A | 4 | Renewal | Renewal |
| A | 5 | Adjustment | Renewal |
| A | 6 | Cancellation | Cancellation |
| B | 1 | New Business | New Business |
| B | 2 | Renewal | Renewal |
| B | 3 | Adjustment | Renewal |
| B | 4 | Cancellation | Cancellation |
| C | 1 | Adjustment | Adjustment |