mysql对数据查询并且分组问题

问题：截图有说明
查询出来的数据含有相同编码Shop_code，请问如何进一步优化根据Shop_code分组求相同编码的部分数据求和：

select Shop_code, sum(yingshou), sum(moneys) from result where ....   group by Shop_code

select sum(xxx),xxx,xxx from xxx group by Shop_code

select Shop_code, sum(yingshou), sum(moneys) 。。。。。from result where dept="电商三部”and platform="天猫" and partner="徐亮" and date between "2021-08-30" and "2021-09-01" group by Shop_code