先来看一下需求:
sql语句:select date_format(creatTime,"%Y-%m-%d") as days,count(id) as num,sum(money) as money
from `order` group by days;
结果如下:![](https://code84.com/wp-content/uploads/2020/04/20200203125421431.png)
select date_format(creatTime,"%Y-%m-%d") as days,count(id) as num,
(CASE WHEN SUM(money) IS NOT NULL THEN SUM(money) ELSE 0 END) AS money
from `order` group by days;
最终效果:![](https://code84.com/wp-content/uploads/2020/04/20200203125737304.png)