select
coalesce(sum(case when tb.TPA_ior is null then RF.Status else 0 end),0) as status,
CON.OID as oid
from
database3 AS CON
left join database4 AS RR ON RR.Asset = CON.OID
left join database1 AS RF ON RF.Reader = RR.Oid
and RF.Date between dateadd(hour, 7, cast(cast(getdate() as date) as datetime)) and dateadd(hour, 19, cast(cast(getdate() as date) as datetime))
left join database2 as tb on tb.TPA_ior = CON.OID and tb.View_problem = 'простой' and RF.Date between tb.Start_date and isnull(tb.End_date, null)
where
CON.IP = '1.2.3.4'
group by CON.OID;

select coalesce(sum(case when tb.TPA_ior is null then RF.Status else 0 end),0) as status
from database1 AS RF 
left join  database4 AS RR ON RF.Reader = RR.Oid 
    AND RF.Date BETWEEN dateadd(hour, 7, cast(cast(getdate() as date) as datetime)) 
    AND dateadd(hour, 19, cast(cast(getdate() as date) as datetime))
left join database2 as tb on tb.TPA_ior = RR.Asset and tb.View_problem = 'простой' and RF.Date between tb.Start_date and isnull(tb.End_date, null)
where RR.Asset = 'E3E5F3C0-A20A'

select sum(RF.Status) as status
from database1 AS RF
left join database4 AS RR on RF.Reader = RR.Oid
where RR.Asset = 'E3E5F3C0-A20A'
AND RF.Date BETWEEN dateadd(hour, 7, cast(cast(getdate() as date) as datetime)) 
   AND dateadd(hour, 19, cast(cast(getdate() as date) as datetime))

select coalesce(sum(case when tb.TPA_ior is null then RF.Status else 0 end),0) as status

--заменить на 
select sum(RF.Status) as status