Return
day: the date of activitysignup_count: total number of new signups on that daytotal_revenue: combined revenue from all regions for that daytotal_orders: combined number of orders from all regions for that dayavg_revenue_per_order: average revenue per order for that dayday in ascending order.Expected output
| day | signup_count | total_revenue | total_orders | avg_revenue_per_order |
|---|---|---|---|---|
| 1 row — values hidden, that's the puzzle | ||||
Your query should return 1 row with these columns. 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.