By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
16 rows affected
| event_date | country | sales | total_sales_per_country | total_sales_per_day | share_per_day_per_country |
|---|---|---|---|---|---|
| 2020-02-08 | DE | 200 | 1100 | 2900 | 0.37931034482758620690 |
| 2020-02-08 | DE | 400 | 1100 | 2900 | 0.37931034482758620690 |
| 2020-02-08 | DE | 500 | 1100 | 2900 | 0.37931034482758620690 |
| 2020-02-08 | FR | 800 | 1700 | 2900 | 0.58620689655172413793 |
| 2020-02-08 | FR | 900 | 1700 | 2900 | 0.58620689655172413793 |
| 2020-02-08 | NL | 100 | 100 | 2900 | 0.03448275862068965517 |
| 2020-03-20 | DE | 0 | 0 | 0 | 0.33000000000000000000 |
| 2020-03-20 | FR | 0 | 0 | 0 | 0.33000000000000000000 |
| 2020-03-20 | NL | 0 | 0 | 0 | 0.33000000000000000000 |
| 2020-04-15 | DE | 700 | 700 | 2600 | 0.26923076923076923077 |
| 2020-04-15 | FR | 500 | 500 | 2600 | 0.19230769230769230769 |
| 2020-04-15 | NL | 250 | 1400 | 2600 | 0.53846153846153846154 |
| 2020-04-15 | NL | 300 | 1400 | 2600 | 0.53846153846153846154 |
| 2020-04-15 | NL | 850 | 1400 | 2600 | 0.53846153846153846154 |