mysql 按照时间间隔1小时（或者其他分钟数、小时数）分组来进行数据统计

SELECT
    FLOOR(TIMESTAMPDIFF(SECOND,create_time,NOW())/3600)  timeDiff,
    sum(listen_time)  listenTime
FROM
    user_learn_time
WHERE
create_time >= DATE_SUB(NOW(),INTERVAL 2 DAY)
GROUP BY timeDiff;