Top 10 Products by Total Revenue

SELECT
  p.product_name,
  SUM(oi.quantity)                      AS units_sold,
  SUM(oi.quantity * oi.unit_price)      AS total_revenue
FROM products p
JOIN order_items oi ON p.product_id = oi.product_id
GROUP BY p.product_id, p.product_name
ORDER BY total_revenue DESC
LIMIT 10;