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;
コメント
会議に参加するためにアカウントを登録または作成します。
コメントを積み重ねる...