_1435.sql

-- # Write your MySQL query statement below
with groupedBy as (
select"[0-5>"as bin, 0as minDuration, 60*5as maxDuration
union all
select"[5-10>"as bin, 60*5as minDuration, 60*10as maxDuration
union all
select"[10-15>"as bin, 60*10as minDuration, 60*15as maxDuration
union all
select"15 or more"as bin, 60*15as minDuration, 2147483647as maxDuration
)

select bin, count(session_id) as total from groupedBy
left join Sessions on duration >= minDuration and duration < maxDuration
group by bin;