(8) 显示OrderDetail表中每种商品的订购金额总和，并且依据销售金额由大到小排序输出。 命令：
SELECT productNo ,sum(quantity *price ) 订购金额 FROM OrderDetail GROUP BY productNo
ORDER BY 订购金额 DESC 结果：
(9) 查找销售总额少于1000元的销售员编号、姓名和销售额。 命令：
SELECT employeeNo ,employeeName ,sum(orderSum ) 销售额
FROM OrderMaster a RIGHT OUTER JOIN Employee b ON salerNo =employeeNo WHERE employeeNo NOT IN ( SELECT salerNo FROM OrderMaster WHERE salerNo NOT IN( SELECT salerNo FROM OrderMaster GROUP BY salerNo HAVING sum(orderSum )<1000)) GROUP BY employeeNo ,employeeName 结果：