By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
msid | id | start | cancelled |
---|---|---|---|
1 | 1 | 2020-01-01 09:00:00 | null |
2 | 2 | 2020-01-01 09:00:00 | 2020-12-31 09:00:00 |
3 | 2 | 2021-01-01 09:00:00 | null |
4 | 3 | 2020-01-01 09:00:00 | 2020-06-30 09:00:00 |
5 | 3 | 2020-02-01 09:00:00 | 2020-06-30 09:00:00 |
6 | 3 | 2020-07-01 09:00:00 | null |
period_start | period_end |
---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 |
id | start |
---|---|
1 | 2020-01-01 09:00:00 |
2 | 2020-01-01 09:00:00 |
3 | 2020-01-01 09:00:00 |
id | cancelled |
---|---|
2 | 2020-12-31 09:00:00 |
3 | 2020-06-30 09:00:00 |
id | rejoined |
---|---|
2 | 2021-01-01 09:00:00 |
3 | 2020-07-01 09:00:00 |
period_start | period_end | new |
---|---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 | 3 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 | 3 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 | 3 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 | 3 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 | 3 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 | 0 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 | 0 |
period_start | period_end | new | cancelled |
---|---|---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 | 3 | 0 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 | 3 | 1 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 | 3 | 1 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 | 3 | 2 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 | 3 | 2 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 1 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 0 |
period_start | period_end | new | cancelled | rejoined |
---|---|---|---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 | 3 | 0 | 0 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 | 3 | 1 | 0 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 | 3 | 1 | 1 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 | 3 | 2 | 1 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 | 3 | 2 | 2 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 1 | 2 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 0 | 1 |
period_start | period_end | new | cancelled | rejoined |
---|---|---|---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 | 3 | 0 | 0 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 | 3 | 1 | 0 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 | 3 | 1 | 1 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 | 3 | 2 | 1 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 | 3 | 2 | 2 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 1 | 2 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 0 | 1 |
period_start | period_end | new | cancelled | rejoined |
---|---|---|---|---|
2020-01-01 00:00:00 | 2020-01-01 23:59:59 | 3 | 0 | 0 |
2020-01-01 00:00:00 | 2020-06-30 23:59:59 | 3 | 1 | 0 |
2020-01-01 00:00:00 | 2020-07-01 23:59:59 | 3 | 1 | 1 |
2020-01-01 00:00:00 | 2020-12-31 23:59:59 | 3 | 2 | 1 |
2020-01-01 00:00:00 | 2021-01-01 23:59:59 | 3 | 2 | 2 |
2020-07-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 1 | 2 |
2021-01-01 00:00:00 | 2021-01-01 23:59:59 | 0 | 0 | 1 |