By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | status | timestamp |
---|---|---|
1 | logout | 2021-01-01 05:01:00 |
2 | login | 2021-01-01 06:02:00 |
3 | online | 2021-01-01 06:03:00 |
4 | away | 2021-01-01 06:04:00 |
5 | online | 2021-01-01 06:05:00 |
6 | logout | 2021-01-02 04:00:00 |
7 | login | 2021-01-02 04:05:00 |
8 | online | 2021-01-02 04:07:00 |
9 | away | 2021-01-02 04:08:00 |
10 | break | 2021-01-02 04:10:00 |
11 | online | 2021-01-02 04:15:00 |
12 | logout | 2021-01-02 04:55:00 |
13 | login | 2021-01-02 05:04:00 |
14 | online | 2021-01-02 05:05:00 |
15 | away | 2021-01-03 05:01:00 |
16 | logout | 2021-01-03 05:02:00 |
17 | login | 2021-01-03 05:04:00 |
18 | online | 2021-01-03 05:05:00 |
19 | logout | 2021-01-04 03:05:00 |
id | status | timestamp |
---|---|---|
1 | logout | 2021-01-01 05:01:00 |
2 | login | 2021-01-01 06:02:00 |
3 | online | 2021-01-01 06:03:00 |
5 | online | 2021-01-01 06:05:00 |
6 | logout | 2021-01-02 04:00:00 |
7 | login | 2021-01-02 04:05:00 |
8 | online | 2021-01-02 04:07:00 |
11 | online | 2021-01-02 04:15:00 |
12 | logout | 2021-01-02 04:55:00 |
13 | login | 2021-01-02 05:04:00 |
14 | online | 2021-01-02 05:05:00 |
16 | logout | 2021-01-03 05:02:00 |
17 | login | 2021-01-03 05:04:00 |
18 | online | 2021-01-03 05:05:00 |
19 | logout | 2021-01-04 03:05:00 |
login | online | logout |
---|---|---|
2021-01-01 06:02:00 | 2021-01-01 06:03:00 | 2021-01-02 04:00:00 |
2021-01-02 04:05:00 | 2021-01-02 04:07:00 | 2021-01-02 04:55:00 |
2021-01-03 05:04:00 | 2021-01-03 05:05:00 | 2021-01-04 03:05:00 |
date | login | online | logout |
---|---|---|---|
2021-01-01 | 2021-01-02 04:05:00 | 2021-01-02 04:07:00 | 2021-01-02 04:55:00 |
2021-01-02 | 2021-01-02 05:04:00 | 2021-01-02 05:05:00 | 2021-01-03 05:02:00 |
2021-01-03 | 2021-01-03 05:04:00 | 2021-01-03 05:05:00 | 2021-01-04 03:05:00 |
date | online | logout |
---|---|---|
2021-01-01 | 2021-01-02 04:07:00 | 2021-01-02 04:55:00 |
2021-01-02 | 2021-01-02 05:05:00 | 2021-01-03 04:59:59 |
2021-01-03 | 2021-01-03 05:05:00 | 2021-01-04 03:05:00 |