````  SELECT count(1),convert(a.addtime,date) as sss,a.addtime from fa_parkline_records as a LEFT JOIN fa_parklinesms_info as b on a.devid = b.devid and b.fitness_id = 1 where CONVERT(a.addtime,date) > '2018-01-10' and CONVERT(a.addtime,date) < '2019-02-01' GROUP BY convert(a.addtime,date) ````