mysql根据一个时间查询出所在时间段

今天的数据：

select name,count(1)from (
select (case when today='08' then '08:00'
when today='08' then '08:00'
when today='09' then '09:00'
when today='10' then '10:00'
when today='11' then '11:00'
when today='12' then '12:00'
when today='13' then '13:00'
when today='14' then '14:00'
when today='15' then '15:00'
when today='16' then '16:00'
when today='17' then '17:00'
when today='18' then '18:00'
end) name from 
(select  DATE_FORMAT(get_queue_time,'%H') today from  v_app_queue_sq  where DATE_FORMAT(get_queue_time,'%Y-%m-%d')=DATE_FORMAT(now(),'%Y-%m-%d')) m)n group by name

昨天的数据：

select name,count(1)from (
select (case when today='08' then '08:00'
when today='08' then '08:00'
when today='09' then '09:00'
when today='10' then '10:00'
when today='11' then '11:00'
when today='12' then '12:00'
when today='13' then '13:00'
when today='14' then '14:00'
when today='15' then '15:00'
when today='16' then '16:00'
when today='17' then '17:00'
when today='18' then '18:00'
end) name from 
(select  DATE_FORMAT(get_queue_time,'%H') today from  v_app_queue_sq  where TO_DAYS( NOW( ) ) - TO_DAYS(get_queue_time) = 1 ) m)n group by name