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