select CustomerName ,telephone ,b.orderNo ,sum(quantity *price ) as ordersum from Customer a,OrderMaster b,OrderDetail c
where address ='上海市' and a.CustomerNo =b.CustomerNo and b.orderNo =c.orderNo group by CustomerName ,telephone ,b.orderNo 结果：
实验二题目
首先使用命令：
UPDATE OrderMaster SET orderSum =total FROM OrderMaster a, (SELECT orderNo ,sum(quantity *price ) as total FROM OrderDetail GROUP BY orderNo ) b WHERE a.orderNo =b.orderNo
更新表OrderMaster 中 orderSum 的值。
（1）查找有销售记录的客户编号、名称和订单总额。 命令：
SELECT a.CustomerNo ,CustomerName ,sum(orderSum ) Sum FROM Customer a,OrderMaster b
WHERE a.CustomerNo =b.CustomerNo and orderSum !=0 GROUP BY a.CustomerNo ,CustomerName 结果：
(2) 在订单明细表中查询订单金额最高的订单。 命令： SELECT *
FROM OrderMaster
WHERE orderSum =(SELECT max(orderSum ) FROM OrderMaster ) 结果：
(3) 查询没有订购商品的客户编号和客户名称。