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

select
    c.cust_name,
    sum(oi.item_price * oi.quantity) as total_price
from
    Customers c
    inner join Orders o on c.cust_id = o.cust_id
    inner join OrderItems oi on o.order_num = oi.order_num
group by
    cust_name
having
    total_price >= 1000
order by
    total_price;

记录第一次正确使用HAVING，离自己的目标又进一步