add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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