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 |