medium
Generate SQL Sales Report Query
Write a SQL query for a specific sales data request.
📝 Prompt Content
Write a SQL query for a table named 'sales_data' that retrieves the total revenue, average order value, and count of orders for each product category in the year 2023. Order the results by total revenue in descending order.