-- 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 ;
