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