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

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 结果：

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