Write a SQL query to identify the top 5 categories by average order value.
Use the provided order, order item, product, and category data. Each order should contribute at most once to each category, even when it contains multiple products from that category.
category_name and average_order_valueaverage_order_value descending, then category_name ascending to break ties| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| order_total | DECIMAL(10,2) | Total value of the order |
| order_date | DATE | Date the order was placed |
| Column | Type | Description |
|---|---|---|
| order_item_idPK | INT | Unique order item identifier |
| order_id | INT | Associated order |
| product_id | INT | Associated product |
| quantity | INT | Quantity purchased |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product name |
| category_id | INT | Associated product category |
| Column | Type | Description |
|---|---|---|
| category_idPK | INT | Unique category identifier |
| category_name | VARCHAR(60) | Category name |