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 |