By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| sales_date | country | SUM(sales_volume) | imputed_fix_costs |
|---|---|---|---|
| 2020-01-03 | DE | 500 | 208.72865271 |
| 2020-01-03 | FR | 350 | 146.11005694 |
| 2020-01-03 | NL | 320 | 0.00000000 |
| 2020-02-15 | DE | 0 | 189.65515000 |
| 2020-02-15 | FR | 0 | 189.65515000 |
| 2020-02-15 | NL | 0 | 0.00000000 |
| 2020-03-27 | DE | 180 | 55.53997191 |
| 2020-03-27 | FR | 970 | 299.29873774 |
| 2020-03-27 | NL | 670 | 0.00000000 |