By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
8.0.27 |
customer | total_count | month |
---|---|---|
ABC | 10 | January |
ABC | 12 | February |
ABC | 11 | March |
DEF | 16 | January |
DEF | 11 | February |
DEF | 19 | August |
XYZ | 99 | December |
customer | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Decem |
---|---|---|---|---|---|---|---|---|---|---|---|---|
ABC | 10 | 12 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
DEF | 16 | 11 | 0 | 0 | 0 | 0 | 0 | 19 | 0 | 0 | 0 | 0 |
XYZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 99 |