select substr(IM3_RELEASETIME,1,10) as date_t,
sum(case when substr(IM3_RELEASETIME,12,2) >=0
and substr(IM3_RELEASETIME,12,2) < 8
and substr(IM3_RELEASETIME,12,2)<12 then 1 else 0 end)/
decode(sum(case when substr(IM3_RELEASETIME,12,2) >=0
and substr(IM3_RELEASETIME,12,2) < 8 then 1 else 0 end),0, 1,
sum(case when substr(IM3_RELEASETIME,12,2) >=0 and substr(IM3_RELEASETIME,12,2) < 8 then 1 else 0 end)) as X_8
from "TMS_MR_USER"."IM_DELIVER_PLAN"
left join "TMS_MR_USER"."TMS_PLANTIME"
on "TMS_MR_USER"."IM_DELIVER_PLAN".IM3_TMSAREA="TMS_MR_USER"."TMS_PLANTIME".AREA
where 1=1
${if(len(a)==0,"","and substr(IM3_RELEASETIME,1,10)='"+a+"'")}
group by substr(IM3_RELEASETIME,1,10)