Write a SQL query to summarize daily orders by store, including total orders, total revenue, and average order value.
Use the provided stores and orders tables. Include only orders associated with a known store, and preserve the order date as the daily reporting date.
store_name, order_date, total_orders, total_revenue, and average_order_value.order_date ascending, then store_name ascending.| Column | Type | Description |
|---|---|---|
| store_idPK | INT | Unique store identifier |
| store_name | VARCHAR(100) | Display name of the store |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| store_id | INT | Store associated with the order |
| order_date | DATE | Date on which the order was placed |
| order_total | DECIMAL(10,2) | Total monetary value of the order |