🗓️ The Business Never Sleeps — But Does It Earn?
The ops team at Zomato wants to know whether weekend orders (Saturday and Sunday) outperform weekday orders in terms of average order value.
Return two rows — one for 'Weekend' and one for 'Weekday' — showing the label, total_orders, and avg_order_value rounded to 2 decimal places.
Use STRFTIME('%w', order_time) — returns 0 for Sunday, 6 for Saturday.
orders Table:
| Column | Type |
|---|---|
| order_id | integer |
| customer_id | integer |
| amount | integer |
| order_time | text |
Expected Outcome (Illustrative Sample):
| day_type | total_orders | avg_order_value |
|---|---|---|
| Weekend | 4 | 662.50 |