MySQL统计时间段数据，没有该天数据则为0

Question

SELECT
COUNT(1) dealOrder,
o.create_date createDate
FROM orders o
WHERE o.shop_id = 27
AND DATE_FORMAT(o.create_date, '%Y-%m-%d') IN ('2018-04-19', '2018-04-18', '2018-04-17', '2018-04-16', '2018-04-15', '2018-04-14', '2018-04-13')
AND o.order_status IN ('1', '2', '3', '5')
GROUP BY DATE_FORMAT(o.create_date, '%Y-%m-%d');

缺少14号和13号的数据

Answer 1

参考：https://blog.csdn.net/ajian759447583/article/details/61421399