By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
16 rows affected
| event_date | country | total_sales_per_day | share_per_day_per_country |
|---|---|---|---|
| 2020-02-08 | DE | 2900 | 0.37931034482758620690 |
| 2020-02-08 | FR | 2900 | 0.58620689655172413793 |
| 2020-02-08 | NL | 2900 | 0.03448275862068965517 |
| 2020-03-20 | DE | 0 | 0.33000000000000000000 |
| 2020-03-20 | FR | 0 | 0.33000000000000000000 |
| 2020-03-20 | NL | 0 | 0.33000000000000000000 |
| 2020-04-15 | DE | 2600 | 0.26923076923076923077 |
| 2020-04-15 | FR | 2600 | 0.19230769230769230769 |
| 2020-04-15 | NL | 2600 | 0.53846153846153846154 |