By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| clientID | VIPStart | VIPEnd |
|---|---|---|
| 1 | 2020-01-30 | 2020-04-01 |
| 1 | 2020-05-03 | 2020-07-04 |
| 2 | 2020-02-01 | 2020-04-28 |
| 3 | 2020-02-07 | 2020-04-20 |
Warning: Null value is eliminated by an aggregate or other SET operation.