medium
Generate SQL Sales Report Query
Write a SQL query for a specific sales data request.
📝 プロンプトの内容
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.