Return
day: the date of the sales dataregion: the region nameregional_revenue_change_pct: percent change in revenue for that region compared to its previous daynational_revenue_change_pct: percent change in total company revenue compared to the previous dayday and then region. If there is no prior day to compare for a region or for the national total, display NULL for the change percentage.Expected output
| day | region | regional_revenue_change_pct | national_revenue_change_pct |
|---|---|---|---|
| 2023-01-01 | DE | NULL | NULL |
| 2023-01-01 | GB | NULL | NULL |
| 2023-01-01 | IN | NULL | NULL |
First 3 of 208 rows your query should return. Your column aliases don't need to match.
daily_sales
| day | region | revenue | orders |
|---|---|---|---|
| 2023-01-01 | US | 550 | 11 |
| 2023-01-02 | US | 1010 | 20 |
| 2023-01-03 | US | 1020 | 20 |
| 2023-01-04 | US | 1030 | 21 |
| 2023-01-05 | US | 1040 | 21 |
signups
| day | signup_count |
|---|---|
| 2023-01-01 | 33 |
| 2023-01-02 | 61 |
| 2023-01-03 | 61 |
| 2023-01-04 | 62 |
| 2023-01-05 | 63 |
0 of 4 hints revealed
Submit an attempt first.