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

有些时候不写inner join，有点忘记