一、题目
二、代码
select Customers.cust_name,table2.total_price
from
(
select ord.cust_id,table1.total_price
from
(
select OrderItems.order_num, sum(OrderItems.item_price * OrderItems.quantity ) as total_price
from OrderItems
group by order_num
having total_price>=1000
) table1
join Orders ord
on table1.order_num = ord.order_num
) table2
join Customers
on table2.cust_id = Customers.cust_id