按照业务类型-每10分钟统计下订单总数最大多少

SELECT
ORDER_TYPE,
timekey,
MAX(c)
FROM
(
SELECT
ORDER_TYPE,
DATE_FORMAT(
concat(
date(create_time),
' ',
HOUR (create_time),
':',
floor(MINUTE(create_time) / 10) * 10
),
'%Y-%m-%d %H:%i'
) AS timekey,
count(*) AS c,
create_time
FROM
tb_order
WHERE
create_time >= '2019-10-17'
AND create_time < '2019-10-18'
GROUP BY
ORDER_TYPE,
timekey
ORDER BY
ORDER_TYPE,
c DESC
) AS tb
GROUP BY
tb.ORDER_TYPE
ORDER BY
c DESC;