9. 计算销量前10位的订单明细,结果集返回订单ID,订单日期,公司名称,发货日期,销售额,并排序
SELECT FT1.订单ID,FT1.订购日期,DM1.公司名称,FT1.发货日期,sum(FT2.数量) as 销量,sum(FT2.数量*FT2.单价) as 销售额
from 订单 FT1 join 订单明细 FT2 on FT1.订单ID=FT2.订单ID
join 客户 DM1 on FT1.客户ID = DM1.客户ID
group by FT1.订单ID,FT1.订购日期,DM1.公司名称,FT1.发货日期
order by 5 desc LIMIT 10
|