56,941
社区成员




SELECT create_time,COUNT(1) num
FROM(
SELECT
CASE WHEN create_time BETWEEN '2016-07-11 18:00:01' AND '2016-07-11 19:00:00' THEN 'C1819'
WHEN create_time BETWEEN '2016-07-11 19:00:01' AND '2016-07-11 20:00:00' THEN 'C1920'
WHEN create_time BETWEEN '2016-07-11 22:00:01' AND '2016-07-11 24:00:00' THEN 'C2200'
ELSE 'COTHERS' END AS create_time ,id
FROM tablename
)t1 GROUP BY t1.create_time