Nueva Query agregar AMI

nuevo_agregar_ami.sql

select id_sapu, xrut, dv, min(xfecha) from
(select s.id_sapu, cast(rtrim(ltrim(s.rut_paciente)) as decimal) as xrut,
'dv', date_format(s.lblfechahoraingreso, '%Y-%m-%d') as xfecha
from historia_sapu as s
where
(hour(s.lblfechahoraingreso) >= 8 and hour(s.lblfechahoraingreso) <= 17)
and weekday(s.lblfechahoraingreso) not in (1,7) 
and (s.lblfechahoraingreso between '2015-10-01' and '2016-03-31')
and s.rut_paciente not like '%-%'
and s.rut_paciente < 43000000 and s.rut_paciente <> 0
and convert(s.rut_paciente, signed integer) is not null) as x
group by xrut
order by xrut asc