(SELECT *,count(1),SUM(if(ARRIVE.ARRIVE_TIME != '无',1,0)) as s FROM lt_cleanroute_point_arrive AS ARRIVE
WHERE DATE_FORMAT(data_dt,'%Y-%m') = '2022-12' and TIME(data_dt) BETWEEN '00:00:00' AND '12:00:00' GROUP BY NAME )
关键代：
TIME(data_dt) BETWEEN '00:00:00' AND '12:00:00'标签：00,12,TIME,获取,mysql,某月,ARRIVE,data,dt From： https://www.cnblogs.com/wangweiip/p/16993641.html