By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 14 Duplicates: 0 Warnings: 0
lag_1 | created_date | lead_1 | f_val | c_f_diff | min_diff | ut_d | o_url | c_sess_id |
---|---|---|---|---|---|---|---|---|
null | 2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | 2021-01-18 10:30:24.00 | 0.00 | 147 | -8820.00 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
null | 2021-01-18 11:02:24.00 | 2021-01-18 11:02:35.00 | 2021-01-18 11:02:24.00 | 0.00 | 0 | -11.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:24.00 | 2021-01-18 11:02:35.00 | 2021-01-18 11:03:03.00 | 2021-01-18 11:02:24.00 | 11.00 | 0 | -28.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:35.00 | 2021-01-18 11:03:03.00 | 2021-01-18 11:04:15.00 | 2021-01-18 11:02:24.00 | 39.00 | 1 | -72.00 | https://zes.com/ | znkjoc |
2021-01-18 11:03:03.00 | 2021-01-18 11:04:15.00 | 2021-01-18 11:04:30.00 | 2021-01-18 11:02:24.00 | 111.00 | 0 | -15.00 | https://zes.com/ | znkjoc |
2021-01-18 11:04:15.00 | 2021-01-18 11:04:30.00 | null | 2021-01-18 11:02:24.00 | 126.00 | null | null | https://zes.com/ | znkjoc |
null | 2021-01-18 11:49:28.00 | 2021-01-18 11:49:48.00 | 2021-01-18 11:49:28.00 | 0.00 | 0 | -20.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:49:28.00 | 2021-01-18 11:49:48.00 | 2021-01-18 11:50:13.00 | 2021-01-18 11:49:28.00 | 20.00 | 0 | -25.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:49:48.00 | 2021-01-18 11:50:13.00 | null | 2021-01-18 11:49:28.00 | 45.00 | null | null | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | null | 2021-01-18 10:30:24.00 | 8820.00 | null | null | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
null | 2021-02-18 09:02:24.00 | 2021-02-18 09:02:35.00 | 2021-02-18 09:02:24.00 | 0.00 | 0 | -11.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:24.00 | 2021-02-18 09:02:35.00 | 2021-02-18 09:03:03.00 | 2021-02-18 09:02:24.00 | 11.00 | 0 | -28.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:35.00 | 2021-02-18 09:03:03.00 | 2021-02-18 09:04:15.00 | 2021-02-18 09:02:24.00 | 39.00 | 1 | -72.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:03:03.00 | 2021-02-18 09:04:15.00 | null | 2021-02-18 09:02:24.00 | 111.00 | null | null | https://rar.com/ | znkjoc3 |
fv | lv | lag_1 | created_date | lead_1 | XXX | YYY | testy | c_f_diff | min_diff | ut_d | o_url | c_sess_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-18 10:30:24.00 | 2021-01-18 10:30:24.00 | null | 2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | 8820.00 | null | 1 | 0.00 | 147 | -8820.00 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:02:24.00 | 2021-01-18 11:02:24.00 | null | 2021-01-18 11:02:24.00 | 2021-01-18 11:02:35.00 | 11.00 | null | 1 | 0.00 | 0 | -11.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:24.00 | 2021-01-18 11:02:35.00 | 2021-01-18 11:02:24.00 | 2021-01-18 11:02:35.00 | 2021-01-18 11:03:03.00 | 28.00 | 11.00 | 0 | 11.00 | 0 | -28.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:24.00 | 2021-01-18 11:03:03.00 | 2021-01-18 11:02:35.00 | 2021-01-18 11:03:03.00 | 2021-01-18 11:04:15.00 | 72.00 | 28.00 | 0 | 39.00 | 1 | -72.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:24.00 | 2021-01-18 11:04:15.00 | 2021-01-18 11:03:03.00 | 2021-01-18 11:04:15.00 | 2021-01-18 11:04:30.00 | 15.00 | 72.00 | 0 | 111.00 | 0 | -15.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 2021-01-18 11:04:15.00 | 2021-01-18 11:04:30.00 | null | null | 15.00 | 0 | 126.00 | null | null | https://zes.com/ | znkjoc |
2021-01-18 11:49:28.00 | 2021-01-18 11:49:28.00 | null | 2021-01-18 11:49:28.00 | 2021-01-18 11:49:48.00 | 20.00 | null | 1 | 0.00 | 0 | -20.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:49:28.00 | 2021-01-18 11:49:48.00 | 2021-01-18 11:49:28.00 | 2021-01-18 11:49:48.00 | 2021-01-18 11:50:13.00 | 25.00 | 20.00 | 0 | 20.00 | 0 | -25.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:49:28.00 | 2021-01-18 11:50:13.00 | 2021-01-18 11:49:48.00 | 2021-01-18 11:50:13.00 | null | null | 25.00 | 0 | 45.00 | null | null | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | 2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | null | null | 8820.00 | 1 | 8820.00 | null | null | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
2021-02-18 09:02:24.00 | 2021-02-18 09:02:24.00 | null | 2021-02-18 09:02:24.00 | 2021-02-18 09:02:35.00 | 11.00 | null | 1 | 0.00 | 0 | -11.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:24.00 | 2021-02-18 09:02:35.00 | 2021-02-18 09:02:24.00 | 2021-02-18 09:02:35.00 | 2021-02-18 09:03:03.00 | 28.00 | 11.00 | 0 | 11.00 | 0 | -28.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:24.00 | 2021-02-18 09:03:03.00 | 2021-02-18 09:02:35.00 | 2021-02-18 09:03:03.00 | 2021-02-18 09:04:15.00 | 72.00 | 28.00 | 0 | 39.00 | 1 | -72.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 2021-02-18 09:03:03.00 | 2021-02-18 09:04:15.00 | null | null | 72.00 | 0 | 111.00 | null | null | https://rar.com/ | znkjoc3 |
created_date | YYY | s | rn | st | fv | lv | o_url | c_sess_id |
---|---|---|---|---|---|---|---|---|
2021-01-18 10:30:24.00 | null | 1 | 1 | 1 | 2021-01-18 10:30:24.00 | 2021-01-18 10:30:24.00 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:02:24.00 | null | 2 | 2 | 2 | 2021-01-18 10:30:24.00 | 2021-01-18 11:02:24.00 | https://zes.com/ | znkjoc |
2021-01-18 11:02:35.00 | 11.00 | 0 | 1 | 2 | 2021-01-18 11:02:35.00 | 2021-01-18 11:02:35.00 | https://zes.com/ | znkjoc |
2021-01-18 11:03:03.00 | 28.00 | 0 | 2 | 2 | 2021-01-18 11:02:35.00 | 2021-01-18 11:03:03.00 | https://zes.com/ | znkjoc |
2021-01-18 11:04:15.00 | 72.00 | 0 | 3 | 2 | 2021-01-18 11:02:35.00 | 2021-01-18 11:04:15.00 | https://zes.com/ | znkjoc |
2021-01-18 11:04:30.00 | 15.00 | 0 | 4 | 2 | 2021-01-18 11:02:35.00 | 2021-01-18 11:04:30.00 | https://zes.com/ | znkjoc |
2021-01-18 11:49:28.00 | null | 3 | 3 | 3 | 2021-01-18 10:30:24.00 | 2021-01-18 11:49:28.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:49:48.00 | 20.00 | 0 | 5 | 3 | 2021-01-18 11:02:35.00 | 2021-01-18 11:49:48.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 11:50:13.00 | 25.00 | 0 | 6 | 3 | 2021-01-18 11:02:35.00 | 2021-01-18 11:50:13.00 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
2021-01-18 12:57:24.00 | 8820.00 | 4 | 4 | 4 | 2021-01-18 10:30:24.00 | 2021-01-18 12:57:24.00 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
2021-02-18 09:02:24.00 | null | 5 | 5 | 5 | 2021-01-18 10:30:24.00 | 2021-02-18 09:02:24.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:02:35.00 | 11.00 | 0 | 7 | 5 | 2021-01-18 11:02:35.00 | 2021-02-18 09:02:35.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:03:03.00 | 28.00 | 0 | 8 | 5 | 2021-01-18 11:02:35.00 | 2021-02-18 09:03:03.00 | https://rar.com/ | znkjoc3 |
2021-02-18 09:04:15.00 | 72.00 | 0 | 9 | 5 | 2021-01-18 11:02:35.00 | 2021-02-18 09:04:15.00 | https://rar.com/ | znkjoc3 |
sid | created_date | st | min_cd | max_cd | f_ts | l_ts | c_ts_asc | c_ts_desc | o_url | c_sess_id |
---|---|---|---|---|---|---|---|---|---|---|
1 | 2021-01-18 10:30:24.00 | 1 | 2021-01-18 10:30:24.00 | 2021-01-18 10:30:24.00 | 1 | 1 | 1 | 1 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
2 | 2021-01-18 11:02:24.00 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 1 | 5 | 1 | 5 | https://zes.com/ | znkjoc |
3 | 2021-01-18 11:02:35.00 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 2 | 4 | 2 | 4 | https://zes.com/ | znkjoc |
4 | 2021-01-18 11:03:03.00 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 3 | 3 | 3 | 3 | https://zes.com/ | znkjoc |
5 | 2021-01-18 11:04:15.00 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 4 | 2 | 4 | 2 | https://zes.com/ | znkjoc |
50 | 2021-01-18 11:04:30.00 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 5 | 1 | 5 | 1 | https://zes.com/ | znkjoc |
6 | 2021-01-18 11:49:28.00 | 3 | 2021-01-18 11:49:28.00 | 2021-01-18 11:50:13.00 | 1 | 3 | 1 | 3 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
7 | 2021-01-18 11:49:48.00 | 3 | 2021-01-18 11:49:28.00 | 2021-01-18 11:50:13.00 | 2 | 2 | 2 | 2 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
8 | 2021-01-18 11:50:13.00 | 3 | 2021-01-18 11:49:28.00 | 2021-01-18 11:50:13.00 | 3 | 1 | 3 | 1 | https://rararar.com/ | znkjoc3gfth2c3m0t1klii |
9 | 2021-01-18 12:57:24.00 | 4 | 2021-01-18 12:57:24.00 | 2021-01-18 12:57:24.00 | 1 | 1 | 1 | 1 | https://zendes.com/ | znkjoc3gfth2c3m0t1klii |
10 | 2021-02-18 09:02:24.00 | 5 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 1 | 4 | 1 | 4 | https://rar.com/ | znkjoc3 |
11 | 2021-02-18 09:02:35.00 | 5 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 2 | 3 | 2 | 3 | https://rar.com/ | znkjoc3 |
12 | 2021-02-18 09:03:03.00 | 5 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 3 | 2 | 3 | 2 | https://rar.com/ | znkjoc3 |
13 | 2021-02-18 09:04:15.00 | 5 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 4 | 1 | 4 | 1 | https://rar.com/ | znkjoc3 |
sid | Session no. | Start of sessions | End of sessions | Session count | o_url | c_sess_id |
---|---|---|---|---|---|---|
2 | 2 | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 | 5 | https://zes.com/ | znkjoc |
10 | 5 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 | 4 | https://rar.com/ | znkjoc3 |
rn | st | sids | URL: | Session id: | Session start time: | Session end time: |
---|---|---|---|---|---|---|
1 | 2 | 2,3,4,5,50 | https://zes.com/ | znkjoc | 2021-01-18 11:02:24.00 | 2021-01-18 11:04:30.00 |
2 | 5 | 10,11,12,13 | https://rar.com/ | znkjoc3 | 2021-02-18 09:02:24.00 | 2021-02-18 09:04:15.00 |