-- top categories by revenue this year
select cat.category_name,
       sum(oi.quantity * oi.unit_price) as revenue
from order_items oi
join products p  on p.product_id = oi.product_id
join categories cat on cat.category_id = p.category_id
group by 1 order by revenue desc;