Mysql查询本周上午下午晚上的数据统计

 SELECT count(1),
  DATE(timne),
         CASE WHEN TIME(timne) BETWEEN '01:00:00' AND '14:00:00' THEN 1
              WHEN TIME(timne) BETWEEN '14:00:00' AND '20:00:00' THEN 2
              WHEN TIME(timne) BETWEEN '20:00:00' AND '24:00:00' THEN 3
         END as period
 from sss where YEARWEEK(date_format(timne,'%Y-%m-%d'),1) = YEARWEEK(now(),1) GROUP BY DATE(timne),
         CASE WHEN TIME(timne) BETWEEN '01:00:00' AND '14:00:00' THEN 1
              WHEN TIME(timne) BETWEEN '14:00:00' AND '20:00:00' THEN 2
              WHEN TIME(timne) BETWEEN '20:00:00' AND '24:00:00' THEN 3
         END