《交互式SQL强化练习》

请查询累计消费总金额在40000元及以上的客户编号、联系人、电话、国籍。

* 查询用到多视图B1、B2，使用两次聚合函数sum()来实现查询。

查询语句：

use 销售数据库
go
select C.CustomerID,ContactName,Phone,Country
from Customers C inner join(
select CustomerID
from Orders O inner join
(select OrderID, sum(Quantity*UnitPrice*(1-discount)) as OrderSum
from [Order Details]
group by OrderID )as B1
on O.OrderID=B1.OrderID
group by CustomerID
having sum(B1.OrderSum+Freight)>40000) as B2
on C.CustomerID=B2.CustomerID