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.
id client_id date_start item
1 1 2017-01-12 18:44:42 1-01-12
2 1 2017-01-13 18:44:42 2-01-13
3 1 2017-01-14 18:44:42 3-01-14
4 1 2017-02-12 18:44:42 4-02-12
5 1 2017-03-12 18:44:42 5-03-12
6 1 2017-07-12 18:44:42 6-07-12
7 2 2017-02-12 18:44:42 7-02-12
8 2 2017-03-12 18:44:42 8-03-12
9 2 2017-04-12 18:44:42 9-04-12
10 3 2017-01-12 18:44:42 10-01-12
11 3 2017-01-14 18:44:42 11-01-14
12 3 2017-01-20 18:44:42 12-01-20
13 3 2017-03-12 18:44:42 13-03-12
14 3 2017-05-12 18:44:42 14-05-12
15 3 2017-06-12 18:44:42 15-06-12
16 4 2017-07-12 18:44:42 16-07-12
17 4 2017-07-20 18:44:42 17-07-20
18 5 2017-09-12 18:44:42 18-09-12
19 5 2017-10-12 18:44:42 19-10-12
20 5 2017-03-12 18:44:42 20-03-12
client jan feb mar apr may jun jul aug sep oct nov dec
Apple 3 0 1 0 1 1 0 0 0 0 0 0
LG 0 0 0 0 0 0 2 0 0 0 0 0
Sony 3 1 1 0 0 0 1 0 0 0 0 0
Toshiba 0 1 1 1 0 0 0 0 0 0 0 0
Uco 0 0 1 0 0 0 0 0 1 1 0 0
null 6 2 4 1 1 1 3 0 1 1 0 0
client jan feb mar apr may jun jul aug sep oct nov dec
Apple 10-01-12,11-01-14,12-01-20 null 13-03-12 null 14-05-12 15-06-12 null null null null null null
LG null null null null null null 16-07-12,17-07-20 null null null null null
Sony 1-01-12,2-01-13,3-01-14 4-02-12 5-03-12 null null null 6-07-12 null null null null null
Toshiba null 7-02-12 8-03-12 9-04-12 null null null null null null null null
Uco null null 20-03-12 null null null null null 18-09-12 19-10-12 null null
null 1-01-12,10-01-12,11-01-14,12-01-20,2-01-13,3-01-14 4-02-12,7-02-12 13-03-12,20-03-12,5-03-12,8-03-12 9-04-12 14-05-12 15-06-12 16-07-12,17-07-20,6-07-12 null 18-09-12 19-10-12 null null
client jan feb mar apr may jun jul aug sep oct nov dec
Apple 10-01-12,11-01-14,12-01-20 null 13-03-12 null 14-05-12 15-06-12 null null null null null null
LG null null null null null null 16-07-12,17-07-20 null null null null null
Sony 1-01-12,2-01-13,3-01-14 4-02-12 5-03-12 null null null 6-07-12 null null null null null
Toshiba null 7-02-12 8-03-12 9-04-12 null null null null null null null null
Uco null null 20-03-12 null null null null null 18-09-12 19-10-12 null null
null 6 2 4 1 1 1 3 0 1 1 0 0
client jan feb mar apr may jun jul aug sep oct nov dec
Apple 10-01-12,11-01-14,12-01-20 null 13-03-12 null 14-05-12 15-06-12 null null null null null null
LG null null null null null null 16-07-12,17-07-20 null null null null null
Sony 2-01-13,3-01-14,1-01-12 4-02-12 5-03-12 null null null 6-07-12 null null null null null
Toshiba null 7-02-12 8-03-12 9-04-12 null null null null null null null null
Uco null null 20-03-12 null null null null null 18-09-12 19-10-12 null null
null 6 2 4 1 1 1 3 0 1 1 0 0
client jan feb mar apr may jun jul aug sep oct nov dec
Apple 10-01-12,11-01-14,12-01-20 null 13-03-12 null 14-05-12 15-06-12 null null null null null null
LG null null null null null null 16-07-12,17-07-20 null null null null null
Sony 2-01-13,3-01-14,1-01-12 4-02-12 5-03-12 null null null 6-07-12 null null null null null
Toshiba null 7-02-12 8-03-12 9-04-12 null null null null null null null null
Uco null null 20-03-12 null null null null null 18-09-12 19-10-12 null null
null 6 2 4 1 1 1 3 0 1 1 0 0