By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| customerID | MONTH(sales_date) | SUM(annual_unqiue_count) | SUM(sales_volume) | sales_volume |
|---|---|---|---|---|
| Customer_01 | 3 | 1 | 915 | 600 |
| Customer_02 | 3 | 1 | 208 | 348 |
| Customer_02 | 7 | 0 | 140 | 0 |
| Customer_03 | 10 | 1 | 400 | 900 |
| Customer_03 | 12 | 0 | 1855 | 0 |