By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
user_id | third_day | twenty_fourth_day | start_date | end_date |
---|---|---|---|---|
11122 | 2017-04-03 | 2017-04-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-05-03 | 2017-05-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-06-03 | 2017-06-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-07-03 | 2017-07-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-08-03 | 2017-08-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-09-03 | 2017-09-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-10-03 | 2017-10-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-11-03 | 2017-11-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2017-12-03 | 2017-12-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2018-01-03 | 2018-01-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
11122 | 2018-02-03 | 2018-02-24 | 2017-04-20 00:00:00 | 2018-02-17 00:00:00 |
user_id | number_of_third_day | number_of_twenty_fourth_day |
---|---|---|
11122 | 10 | 10 |
11123 | 1 | 1 |