FROM OrderMaster GROUP BY CustomerNo ) a,OrderMaster b,Customer c
WHERE a.CustomerNo =b.CustomerNo and b.CustomerNo =c.CustomerNo GROUP BY CustomerName ORDER BY 总货款 desc 结果：
(21) 查找至少销售了3种商品的客户编号、客户名称、商品编号、商品名称、数量和金额。 命令：
SELECT a.CustomerNo ,a.CustomerName , c.productNo ,productName ,quantity ,quantity *price 金额,orderDate
FROM Customer a,OrderMaster b,OrderDetail c,Product d
WHERE b.orderNo =c.orderNO and c.productNo =d.productNo and a.CustomerNo IN( SELECT CustomerNo FROM OrderMaster WHERE orderNo IN ( SELECT orderNO FROM OrderDetail GROUP BY orderNo HAVING count(*)>=3))
ORDER BY a.CustomerNo , c.productNo 结果：
(22) 找出目前业绩超过232000元的员工编号和姓名。 命令：
SELECT employeeNo ,employeeName FROM OrderMaster ,Employee WHERE salerNo =employeeNo
GROUP BY employeeNo ,employeeName HAVING sum(orderSum )>232000 结果：