Cacher is the code snippet organizer for pro developers

SELECT 
	                CASE WHEN AppartmentsCount IS NULL THEN 0 ELSE AppartmentsCount END AS AppartmentsCount
                        FROM
                        (SELECT 
                            SUM(AppartmentsCount) AS AppartmentsCount 
                        FROM
                        (SELECT
	                        HouseId, AppartmentsCount,
	                        ROW_NUMBER() OVER(PARTITION BY HouseId ORDER BY LastUpdateUtcDateTime DESC) AS rn
                        FROM 
	                        HouseGeneralParameters 
                        WHERE 
	                        HouseId IN 
                        (SELECT 
	                        HouseId
                        FROM 
	                        Houses AS H 
                        INNER JOIN 
	                        HouseAdditionalInfo AS AI ON AI.HouseId = h.Id
                        WHERE 
	                        H.CompanyId = '22ab29ed-fbc6-4a21-9391-316a2fe8490c' AND 
                            H.DeleteUtcDateTime IS NULL AND 
	                        AI.IsContractTerminated = 0 AND
	                        AI.period = 2017) and Period = 2017) AS HavingMaxLastUpdateUtcDateTime
                        WHERE rn = 1) AS AppartmentsCountSum