SELECT c.id,
       c.name,
       SUM(o.total) AS revenue,
       COUNT(o.id)  AS orders
FROM customers c
JOIN orders o ON o.customer_id = c.id
WHERE o.status = 'paid'
GROUP BY c.id, c.name
ORDER BY revenue DESC
LIMIT 10;