如何使用MySQL按每5分鐘間隔匯總一天的數據量？

create table time_intervals (   grouped_time time default null );

delimiter // create procedure inserttimeintervals() begin     declare currenttime time default '00:00:00';     declare endtime time default '23:55:00';     truncate table time_intervals;     while currenttime <= endtime do         insert into time_intervals (grouped_time) values (currenttime);         set currenttime = addtime(currenttime, '00:05:00');     end while; end // delimiter ;

select      date_format(create_time, '%y-%m-%d %h:%i') - interval (minute(create_time) mod 5) minute as grouped_time,     count(*) as couns from      interface_Access_frequency  where         date(create_time) = '2024-04-27' group by      grouped_time;

(select      date_format(date_format(create_time, '%y-%m-%d %h:%i') - interval (minute(create_time) mod 5) minute,'%h:%i') as grouped_time,     count(*) as couns from      interface_access_frequency  where         date(create_time) = '2024-04-27' group by      grouped_time order by create_time desc ) union select  date_format(grouped_time, '%h:%i') as grouped_time,0 as counts from time_intervals;

SELECT grouped_time, MAX(counts) AS counts FROM ((SELECT      DATE_FORMAT(DATE_FORMAT(create_time, '%Y-%m-%d %H:%i') - INTERVAL (MINUTE(create_time) MOD 5) MINUTE,'%H:%i') AS grouped_time,     COUNT(*) AS counts FROM      interface_access_frequency  WHERE         DATE(create_time) = '2024-04-27' GROUP BY      grouped_time) UNION SELECT  DATE_FORMAT(grouped_time, '%H:%i') AS grouped_time,0 AS counts FROM time_intervals) a  GROUP BY  grouped_time ORDER BY grouped_time ASC;