MySQL查询中包含聚合函数，需要排序， SQL语句应该怎么写？

select A.name,A.sum,B.zong from (select name, sum(xiaoshou) as sum from shujv group by name) A

inner join (select name,zong from shujv order by month desc Limit 1) B

on A.name=B.name

运行下列sql更新查询即可实现提问中的需求:

update order,(select order_id,

sum(goods_num*goods_price) as m

from order_goods group by order_id) b

set order.goods_total=b.m

where order.order_id=b.order_id

---