【sql】按分钟统计数据

select count(*) as n,DATE_FORMAT(a_startTime,'%Y-%m-%d %H:%i:00') from `ARC_`
where a_startTime>="2022-09-09 00:00:00"  and a_startTime <= "2022-09-09 23:59:59"
GROUP BY DATE_FORMAT(a_startTime,'%Y-%m-%d %H:%i');


select count(*) as n,DATE_FORMAT(a_startTime,'%Y-%m-%d %H:%i:00')from `ARC_`
where a_startTime>="2022-09-19 00:00:00"  and a_startTime <= "2022-09-19 23:59:59"
GROUP BY DATE_FORMAT(a_startTime,'%Y-%m-%d %H:%i');