By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| customerID | SUM(sales_volume) | SUM(returned_volume) | return_rate |
|---|---|---|---|
| Customer_01 | 2300 | 965 | 0.4196 |
| Customer_02 | 1875 | 945 | 0.5040 |
| Customer_03 | 700 | 280 | 0.4000 |
| customerID | SUM(sales_volume) | SUM(returned_volume) | return_rate |
|---|---|---|---|
| Customer_01 | 2300 | 965 | 0.4196 |
| Customer_02 | 1875 | 945 | 0.5040 |
| Customer_03 | 700 | 280 | 0.4000 |