数据库SQL查询语句实验报告(15)

(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) 计算每一种商品的销售数量、平均销售单价和总销售金额。 命令：

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库数据库SQL查询语句实验报告(15)在线全文阅读。