Calculate each category's share of total revenue as a percentage. For each category, show the category name, category revenue (from order_items: quantity * unit_price), and the percentage of overall revenue that category represents. Round percentages to 1 decimal place. Sort by percentage descending.