The merchandising team wants to identify product categories that earn more revenue than the average category.
The order_items table records how many units were sold (qty) and the price per unit (unit_price), while products identifies each product's category. Revenue for an order line is its quantity multiplied by its unit price.
Prepare a category-level report and include only categories whose total revenue is strictly above the average total revenue per category. The benchmark is an average of category totals, not an average of order lines or individual products.
Ordering: Sort by category in ascending order.