By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
GP | YRMO | DATEDIFF | ACTIVE_MOS | DESIRED_RESULT |
---|---|---|---|---|
54 | 202012 | 0 | 1 | 12 |
54 | 202101 | 0 | 2 | 12 |
54 | 202102 | 0 | 3 | 12 |
54 | 202103 | 0 | 4 | 12 |
54 | 202104 | 0 | 5 | 12 |
54 | 202105 | 0 | 6 | 12 |
54 | 202106 | 0 | 7 | 12 |
54 | 202107 | 0 | 8 | 12 |
54 | 202108 | 0 | 9 | 12 |
54 | 202109 | 0 | 10 | 12 |
54 | 202110 | 0 | 11 | 12 |
54 | 202111 | 0 | 12 | 12 |
54 | 202112 | 0 | 12 | 12 |
54 | 202201 | 0 | 12 | 12 |
54 | 202202 | 0 | 12 | 12 |
54 | 202203 | 0 | 12 | 12 |
54 | 202204 | 0 | 12 | 12 |
54 | 202205 | 0 | 12 | 12 |
54 | 202206 | 0 | 12 | 12 |
54 | 202207 | 0 | 12 | 12 |
54 | 202208 | 0 | 12 | 12 |
54 | 202209 | 0 | 12 | 12 |
54 | 202210 | 0 | 12 | 12 |
54 | 202211 | 0 | 12 | 12 |
54 | 202310 | 1 | 1 | 4 |
54 | 202311 | 1 | 2 | 4 |
54 | 202312 | 1 | 3 | 4 |
54 | 202401 | 1 | 4 | 4 |