题解 | #确定最佳顾客的另一种方式（二）#

select
    cust_name,
    total_price
from
    Customers inner join (
        select
            cust_id,
            sum(item_price * quantity) as total_price
        from
            Orders inner join OrderItems
            on Orders.order_num = OrderItems.order_num
        group by
            cust_id
    ) as tp
    on Customers.cust_id = tp.cust_id
where
    total_price >= 1000
order by
    total_price