请编写SQL查询每天早晨8:00到次日早晨8:00的数据量

  select DT_START,count(1)  from (
 select DT, CASE  WHEN 
 DATE_FORMAT(DT, '%H:%i') < '08:00' THEN DATE_FORMAT( (DT - INTERVAL 1 day), '%Y-%m-%d') 
      ELSE DATE_FORMAT(DT, '%Y-%m-%d') 
    END AS DT_START from G0810 ) a  where DT_START + INTERVAL '8' HOUR <= DT
  AND DT < DT_START + INTERVAL '1' DAY + INTERVAL '8' HOUR
 group by DT_START