sql query

gistfile1.txt

select  cd.HASTA_ADI, concat(cd .HASTA_ADI, ' ', cd.HASTA_SOYADI) as HASTAADISOYADI,   SUM(md.MAP) as MAPSUM, SUM(md.NIMAP) 
AS NISAPSUM from MonitorData as md inner join  ClientPatientDemograficData cd on cd.HASTA_ID = md.PID inner join 
PatientDemograficData as pdd on pdd.SUBE_ADI = cd.SUBE_ADI where md.DateMonitor  <= DATEADD(hour, -1, getdate()) AND 
md.DateMonitor >= DATEADD(day, -1, GETDATE())  group by cd.HASTA_ADI, cd.HASTA_SOYADI;