Sessions Per Program Area

select C.OutletCode,C.OutletName,C.City,D.RegionName,C.SessionUid,C.SurveyDateTime,B.ProgramItemId,ProgramItemName,A.ProgramArea,A.MetricsDescription,A.MaxTarget,A.ActualValue,A.ScoreValue,A.MaxPoints 
from vwProgramItemMetricsActualList A
inner join vwProgramItemList B with (nolock) on B.ProgramItemId = A.ProgramItemId
inner join vwSurveyList C with (nolock) on C.SessionUid = A.SessionUID
inner join vwLocationList D with (nolock) on D.Code = C.OutletCode
where A.ClientId = 173
and A.ProgramArea = 'Métricas Locales'
and A.CreatedOn >= '2024-01-01'
and A.CreatedOn <= '2024-12-31'
and C.SurveyStatusId = 1
--and C.SurveyDateTime >= '2024-01-01'
--and C.SurveyDateTime <= '2024-12-31'
order by SurveyDate asc

--------------------------------------------------