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