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