By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| sales_date | country | sales_volume | fix_costs | imputed_fix_costs |
|---|---|---|---|---|
| 2020-01-03 | DE | 500 | 2000 | 27.570995312930794 |
| 2020-01-03 | FR | 350 | 2000 | 19.299696719051557 |
| 2020-01-03 | NL | 320 | 2000 | 0 |
| 2020-02-15 | DE | 0 | 5000 | 86.20689655172414 |
| 2020-02-15 | FR | 0 | 5000 | 86.20689655172414 |
| 2020-02-15 | NL | 0 | 5000 | 0 |
| 2020-03-27 | DE | 180 | 4000 | 12.761432116270825 |
| 2020-03-27 | FR | 970 | 4000 | 68.76993973768168 |
| 2020-03-27 | NL | 670 | 4000 | 0 |