Session export according to Survey Review UI

SELECT 
	A.sessionuid,
	A.SessionReviewStatus,
	A.SurveyRejectedReason,
	B.RejectComment,
	A.ProgramItemIds,
	A.Client,
	A.SalesOrganizationName,
    CONVERT(CHAR, CONVERT(DATETIME, A.SessionStartTime AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) AS SurveyStartTime,
	CONVERT(CHAR, CONVERT(DATETIME, A.SurveyDateTime AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) AS SurveyEndTime,
	--Last Corrected On
	--Last Corrected By
	A.OutletCode,
	A.OutletName,
	A.Country,
	A.City,
	C.Segment,
	A.SalesTerritoryName,
	A.TradeChannel,
	A.SubTradeChannel,
	A.PrimaryEmail, -- Survey User ???
	/*A.ExpectedSceneCount,  --	Expected Scenes
	A.SceneCount, -- Scenes Received
	A.TotalProcessedSceneCount, --Processed Scenes
	--Images Received
	A.ImagesExpectedCount, 
	A.ImageCount, 
	A.TotalQuestionsAnswered,
	A.TotalEvidenceImageCount, --Expected Evidence Images ???
	A.ReceivedEvidenceImages,*/
	A.SurveyStatus,
	A.SurveyCancelCallReason,
	A.CancelCallNotes,
	A.IsScoreAvailable,
	A.Calculation,
	/*A.ImagePostedAnswer, --Total Evidence Image ???
	A.TotalEvidenceImageCount,*/
	CONVERT(CHAR, CONVERT(DATETIME, A.ModifiedOn AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) AS ModifiedOn,
    CONVERT(CHAR, CONVERT(DATETIME, A.SurveyFinishReceivedOn AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) AS SurveyFinishReceivedOn
FROM 
    vwSurveyList A
JOIN SURVEY B ON A.SurveyId = B.surveyid
JOIN VWLOCATIONLIST C ON B.LocationId = C.LocationId
WHERE 
    A.ClientId = 173 
    --AND Country = 'Guatemala' 
    --AND A.sessionuid = 'c64e0398-479a-4990-af5a-7b18f46ad2ca'
    AND CONVERT(CHAR, CONVERT(DATETIME, A.SessionStartTime AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) >= '2024-05-01 00:00:01'
    AND CONVERT(CHAR, CONVERT(DATETIME, A.SessionStartTime AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'), 120) < '2024-05-29 00:00:01' 
ORDER BY 
    A.SessionStartTime ASC;

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