select o.pid,sum(o.saleamount) from tbl_order o inner join tbl_user u on u.userid = o.userid and u.province = "上海" group by o.pid ,sum(o.saleamount) order by o.pid ,sum(o.saleamount) desc
点赞 评论

相关推荐

牛客网
牛客企业服务