-- 26. 检索出职务为销售代表的所有订单中，每笔订单总额低于2000的订单明细，以及相关供应商名称--------------------------------------------------------------------注意！！！！ SELECT d2.`订单ID`,d2.`产品ID`,d2.`单价`,d2.`折扣`,d2.`数量`,g.`公司名称`,sum(d2.`单价`*d2.`数量`*(1-d2.`折扣`)) as '订单总额' FROM `客户` as k join `订单` as d on k.`客户ID`=d.`客户ID` join `订单明细` as d2 on d.`订单ID`=d2.`订单ID` join `产品` as c on c.`产品ID`=d2.`产品ID` join `供应商` as g on g.`供应商ID`=c.`供应商ID` where k.`联系人职务`='销售代表' GROUP BY d2.`订单ID`,d2.`产品ID`,d2.`单价`,d2.`折扣`,d2.`数量`,g.`公司名称` HAVING sum(d2.`单价`*d2.`数量`*(1-d2.`折扣`)) < 2000 ;
|
1min目标场景问卷
立即参与
|
0
|
|
|||
