SELECT
c.name AS customer,
c.country,
COUNT(DISTINCT o.id) AS orders,
SUM(i.quantity * i.unit_price)::numeric(12, 2) AS revenue
FROM customers AS c
JOIN orders AS o ON o.customer_id = c.id
JOIN order_items AS i ON i.order_id = o.id
WHERE o.status <> 'refunded'
GROUP BY c.id
ORDER BY revenue DESC;
댓글
참여하거나 토론에 가입하기 위해 계정을 만들었습니다.
충전 코멘트