select cust_name,sum(item_price * quantity) total_price
from OrderItems inner join Orders on OrderItems.order_num = Orders.order_num inner join Customers on Orders.cust_id = Customers.cust_id
group by cust_name
having total_price >= 1000
order by total_price
from OrderItems inner join Orders on OrderItems.order_num = Orders.order_num inner join Customers on Orders.cust_id = Customers.cust_id
group by cust_name
having total_price >= 1000
order by total_price
京公网安备 11010502036488号