By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| ID | PAST_DUE_COL | grp | new_past_due_col |
|---|---|---|---|
| 1 | 91 or more days pastdue | 1 | 91 or more days pastdue |
| 2 | null | 1 | 91 or more days pastdue |
| 3 | null | 1 | 91 or more days pastdue |
| 4 | 61-90 days past due | 2 | 61-90 days past due |
| 5 | null | 2 | 61-90 days past due |
| 6 | null | 2 | 61-90 days past due |
| 7 | 31-60 days past due | 3 | 31-60 days past due |
| 8 | null | 3 | 31-60 days past due |
| 9 | 0-30 days past due | 4 | 0-30 days past due |
| 10 | null | 4 | 0-30 days past due |
| 11 | null | 4 | 0-30 days past due |
| 12 | null | 4 | 0-30 days past due |
Warning: Null value is eliminated by an aggregate or other SET operation.