By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TRAN_ID | USER_ID | START_DATE | END_DATE |
|---|---|---|---|
| 1 | 100 | 01-JUN-18 | 18-JUN-18 |
| 2 | 100 | 14-JUN-18 | 14-JUN-18 |
| 4 | 100 | 19-JUL-18 | 19-JUL-18 |
| 7 | 101 | 05-JAN-18 | 06-JAN-18 |
| 9 | 101 | 08-JAN-18 | 08-JAN-18 |
| 3 | 101 | 03-JAN-18 | 03-JAN-18 |