1435 制作会话柱状图 （没有完全写出）：连用select ‘[0-5＞‘ as bin 利用union all 取得4个标签，这样不会漏掉

Create table If Not Exists Sessions (session_id int, duration int)
Truncate table Sessions
insert into Sessions (session_id, duration) values ('1', '30')
insert into Sessions (session_id, duration) values ('2', '199')
insert into Sessions (session_id, duration) values ('3', '299')
insert into Sessions (session_id, duration) values ('4', '580')
insert into Sessions (session_id, duration) values ('5', '1000')

select b.bin,ifnull(c.total,0) as 'total'
from
#利用union all 取得4个标签，这样不会漏掉
    (select  '[0-5>' as bin 
    union all select '[5-10>' as bin 
    union all select '[10-15>' as bin 
    union all select  '15 or more' as bin )b
    
left join 

    (select a.bin ,count(a.bin) as 'total'
    from
    (select   session_id, duration ,
    #空的会自动省略
    case when duration >=0 and duration < 300 then '[0-5>'
        when duration >=300 and duration <600 then '[5-10>'
        when duration >=600 and duration <900 then '[10-15>'
        else '15 or more'
    end as 'bin'
    from  Sessions ) a 
    group by a.bin ) c on b.bin = c.bin