mysql耗时分段统计

SELECT

sum(CASE when duration>=100  and duration<=200 then 1 else 0 end)   AS '[100,200]',

sum(CASE when  duration>200 and  duration<=400 then 1 else 0 end)  AS '(200,400]',

sum(CASE when  duration>400 and  duration<=600 then 1 else 0 end)  AS '(400,600]',

sum(CASE when  duration>600 and  duration<=800 then 1 else 0 end)  AS '(600,800]',

sum(CASE when  duration>800  then 1 else 0 end)   AS '[800,+oo]'

FROM tableName;