(10) 找出目前业绩未超过5000元的员工，并按销售业绩的降序排序输出。 命令：
SELECT employeeNo ,employeeName ,sum(orderSum ) 销售额
FROM OrderMaster a RIGHT OUTER JOIN Employee b ON salerNo =employeeNo WHERE salerNo IN( SELECT salerNo FROM OrderMaster GROUP BY salerNo HAVING sum(orderSum )<5000) GROUP BY employeeNo ,employeeName ORDER BY 销售额 DESC 结果：
(11) 在Employee表中查询薪水超过员工平均薪水的员工信息。 命令：
SELECT employeeNo ,employeeName ,salary FROM Employee WHERE salary >( SELECT avg(salary ) FROM Employee )
GROUP BY employeeNo ,employeeName ,salary
结果：
(12) 计算每一种商品的销售数量、平均销售单价和总销售金额。 命令：