SQL 각 국가별 주문 수와 총 주문 금액

[jho5245]

select distinct c2.country 국가, 
(select count(o.order_id)
        from customers c
join orders o on o.customer_id = c.customer_id
        where c2.country = c.country) '주문수',
        (select sum(p.price * od.quantity)
        from customers c
join orders o on o.customer_id = c.customer_id
join order_details od on od.order_id = o.order_id
join products p on p.product_id = od.product_id
        where c2.country = c.country) '총 주문 금액'
from customers c2;