Достать максимальную дату одной колонки, максимальную дату второй колонки, и данные, которые им соответствуют

WITH Info AS(
 
 
 
SELECT 
ID
,Date_CAR
,Level_CAR
,Date_ANK
,Level_ANK
 
,ROW_NUMBER() OVER(PARTITION BY ID ORDER BY Date_CAR DESC) AS RownNum_CAR
,ROW_NUMBER() OVER(PARTITION BY ID ORDER BY Date_ANK DESC) AS RownNum_ANK
FROM (
 
        SELECT 
        ccm.Code AS 'ID'
        ,CONVERT(DATE, ccpm.ELApprovalDate) AS 'Date_ANK'
        ,CONCAT(cecsdpm.RiskLeve, ' = ', cecsdpm.NameRiskLevel) AS 'Level_ANK'
        ,CONVERT(DATE,ccm.ElApprovalDate) AS 'Date_CAR'
        ,CONCAT(cecsdm.RiskLeve, ' = ', cecsdm.NameRiskLevel) AS 'Level_CAR'
        FROM InsightDataLake.Creatio.Contact_ AS ccm 
        LEFT JOIN InsightDataLake.Creatio.ContactProfile_ AS ccpm 
            ON ccm.Id = ccpm.ContactId
            AND ccm.End_Date >= getdate()
            AND ccm.is_deleted = 0
            AND ccpm.End_Date >= getdate()
            AND ccpm.is_deleted = 0
            AND ccpm.ELStatus = 'Approved'
        LEFT JOIN InsightDataLake.Creatio.ELContactStatusData_ AS cecsdm 
            ON ccm.Id = cecsdm.ContactId
            AND cecsdm.End_Date >= getdate()
            AND cecsdm.is_deleted = 0
        LEFT JOIN InsightDataLake.Creatio.ELContactStatusDataProfile_ AS cecsdpm  
            ON ccpm.Id = cecsdpm.CustomerProfileId
            AND cecsdpm.End_Date >= getdate()
            AND cecsdpm.is_deleted = 0
 
 
 
 
) AS AA
 
 
)
 SELECT *
 FROM Info 
 ORDER BY 1