By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| fullname | unit | code | shift_datetime | timespan | time_remaining | lev |
|---|---|---|---|---|---|---|
| John Smith | Heroes | 239 | 2020-03-04 13:35:00.000 | 15 | 55 | 1 |
| John Smith | Heroes | 239 | 2020-03-04 13:50:00.000 | 15 | 40 | 2 |
| John Smith | Heroes | 239 | 2020-03-04 14:05:00.000 | 15 | 25 | 3 |
| John Smith | Heroes | 239 | 2020-03-04 14:20:00.000 | 15 | 10 | 4 |
| My Mom | Heroes | 483 | 2020-02-01 08:57:00.000 | 15 | 16 | 1 |
| My Mom | Heroes | 483 | 2020-02-01 09:12:00.000 | 15 | 1 | 2 |
| Tom Cruise | Heroes | 213 | 2020-03-05 09:13:00.000 | 8 | 8 | 1 |