MySQL如何按每2小时统计一天的数据？

Question

SELECT HOUR(APPLY_TIME) as Hour,count(*) as Count 
    FROM sesc_social_security 
   WHERE
    APPLY_TIME like '2018-01-23%'
    GROUP BY HOUR(APPLY_TIME) ORDER BY Hour(APPLY_TIME);

上面是按每小时统计的，请问如何按每2小时统计呢？

Answer 1

SELECT HOUR(APPLY_TIME) as Hour,count(*) as Count 
    FROM sesc_social_security 
   WHERE
    APPLY_TIME like '2018-01-23%' AND Hour % 2 = 0
    GROUP BY HOUR(APPLY_TIME) ORDER BY Hour(APPLY_TIME);