By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EventId | EventName | EventTime |
|---|---|---|
| 1 | Start | 2019-08-31 13:09:48.000 |
| 2 | EVENT A | 2019-08-31 13:10:32.000 |
| 3 | EVENT B | 2019-08-31 15:45:04.000 |
| 4 | EVENT B | 2019-08-31 15:51:09.000 |
| 5 | EVENT A | 2019-08-31 15:55:41.000 |
| 6 | EVENT C | 2019-08-31 15:57:14.000 |
| 7 | Stop | 2019-08-31 15:58:12.000 |
| 8 | EVENT D | 2019-08-31 16:17:04.000 |
| 9 | EVENT E | 2019-08-31 16:19:09.000 |
| 10 | EVENT W | 2019-08-31 16:21:41.000 |
| 11 | EVENT Y | 2019-08-31 16:27:14.000 |
| 12 | Start | 2019-08-31 16:30:48.000 |
| EventId | EventName | EventTime | ex |
|---|---|---|---|
| 1 | Start | 2019-08-31 13:09:48.000 | 1 |
| 2 | EVENT A | 2019-08-31 13:10:32.000 | 1 |
| 3 | EVENT B | 2019-08-31 15:45:04.000 | 1 |
| 4 | EVENT B | 2019-08-31 15:51:09.000 | 1 |
| 5 | EVENT A | 2019-08-31 15:55:41.000 | 1 |
| 6 | EVENT C | 2019-08-31 15:57:14.000 | 1 |
| 7 | Stop | 2019-08-31 15:58:12.000 | 0 |
| 8 | EVENT D | 2019-08-31 16:17:04.000 | 0 |
| 9 | EVENT E | 2019-08-31 16:19:09.000 | 0 |
| 10 | EVENT W | 2019-08-31 16:21:41.000 | 0 |
| 11 | EVENT Y | 2019-08-31 16:27:14.000 | 0 |
| 12 | Start | 2019-08-31 16:30:48.000 | 1 |