SELECT Cus.cust_name, sum(item_price*quantity) as total_price
FROM OrderItems O1
RIGHT JOIN Orders Os on O1.order_num = Os.order_num
LEFT JOIN Customers Cus on Os.cust_id = Cus.cust_id
GROUP BY Cus.cust_name
HAVING total_price >1000
Order BY total_price