SQL100 确定最佳顾客的另一种方式（二）（group by在上面，使用having）

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

group by在上面，
使用having