Merchandising wants per-category totals. The grain of order_items is "one row per (order, product)" — each row's revenue is qty * unit_price. Group these into the product's category.
Return each category and its total revenue across all order items. Columns: category, revenue. Sort by category ascending.