By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | yr_mon | status |
|---|---|---|
| 1002 | 201703 | New |
| 1002 | 201704 | Retained |
| 1002 | 201711 | Lapsed |
| 1003 | 201703 | New |
| 1003 | 201704 | Retained |
| 1003 | 201705 | Lapsed |
| 1003 | 201706 | Lapsed |
| 1003 | 201707 | Reactivated |
| 1003 | 201708 | Lapsed |
| 1002 | 201705 | Unretained |
| 1002 | 201706 | Lapsed |
| 1002 | 201707 | Lapsed |
| 1002 | 201708 | Reactivated |
| 1002 | 201709 | lapsed |
| 1002 | 201710 | Unretained |
| 1003 | 201709 | Lapsed |
| 1002 | 201712 | Lapsed |
| 1003 | 201710 | Lapsed |
| id | yr_mon | status | lapsed_months |
|---|---|---|---|
| 1002 | 201703 | New | 0 |
| 1002 | 201704 | Retained | 0 |
| 1002 | 201705 | Unretained | 0 |
| 1002 | 201706 | Lapsed | 1 |
| 1002 | 201707 | Lapsed | 2 |
| 1002 | 201708 | Reactivated | 0 |
| 1002 | 201709 | lapsed | 1 |
| 1002 | 201710 | Unretained | 0 |
| 1002 | 201711 | Lapsed | 2 |
| 1002 | 201712 | Lapsed | 3 |
| 1003 | 201703 | New | 0 |
| 1003 | 201704 | Retained | 0 |
| 1003 | 201705 | Lapsed | 1 |
| 1003 | 201706 | Lapsed | 2 |
| 1003 | 201707 | Reactivated | 0 |
| 1003 | 201708 | Lapsed | 1 |
| 1003 | 201709 | Lapsed | 2 |
| 1003 | 201710 | Lapsed | 3 |
| id | yr_mon | status | RowNumber |
|---|---|---|---|
| 1002 | 201703 | New | 0 |
| 1002 | 201704 | Retained | 0 |
| 1002 | 201711 | Lapsed | null |
| 1003 | 201703 | New | 0 |
| 1003 | 201704 | Retained | 0 |
| 1003 | 201705 | Lapsed | null |
| 1003 | 201706 | Lapsed | null |
| 1003 | 201707 | Reactivated | 0 |
| 1003 | 201708 | Lapsed | null |
| 1002 | 201705 | Unretained | 0 |
| 1002 | 201706 | Lapsed | null |
| 1002 | 201707 | Lapsed | null |
| 1002 | 201708 | Reactivated | 0 |
| 1002 | 201709 | lapsed | null |
| 1002 | 201710 | Unretained | 0 |
| 1003 | 201709 | Lapsed | null |
| 1002 | 201712 | Lapsed | null |
| 1003 | 201710 | Lapsed | null |