Groupby-mysqlGroupby date. Data is displayed at each time point. if no data exists, the value 0 is displayed.

A table. The main structure of the data: idnumcreate_time I am writing a problem, only display the date of the data. SELECTDATE_FORMAT (create_time, & #39; % Y-% m-% d & #39;) ASday, (CASEWHENCOUNT (num) & #39; 0 & #39; THEN0ELSECOUNT (num) END) AScountsFROMinfosWHEREDATE_FORMAT (create_time, & #39; % Y-% m-% d & #39;) BETW mysqlgroupby

A table.
Data structure:
Id
Num
Create_time

I have a problem with the current writing. only the date with data can be displayed.

SELECT DATE_FORMAT (create_time, '% Y-% m-% d') AS day,
(Case when count (num) = '0' THEN 0 else count (num) END) AS counts
FROM infos
WHERE DATE_FORMAT (create_time, '% Y-% m-% d') BETWEEN '2017-05-01' AND '2017-05-30 'group by day

Requirements:
Data is displayed at each time point. if no data exists, the value 0 is displayed.