query = ("SELECT Mn.PartitionKey, Mn.RoomKey, Mn.Value, Mp.CloseDateTime, Mn.MeasureDateTime, "
        "SUM(ZM.Count) AS SumCount, MAX(ZM.Count)/10 AS MaxValue, COUNT(ZM.Count) AS MeasuresCount, "
        "(SUM(ZM.Count)/10)/COUNT(ZM.COUNT) AS MeanWithZeros, "
        "CASE WHEN SUM(ZM.Count)=0 THEN 0 ELSE (SUM(ZM.Count)/10)/COUNT(CASE WHEN ZM.Count>1 THEN 1 ELSE NULL END) end AS MeanWithoutZeros, "
        "R.Name, R.Type, R.FlooringType, R.Surface "
        "FROM dbo.Measure Mn OUTER APPLY "
         "(SELECT TOP 1 CloseDateTime FROM Measure Mi WHERE Mi.RoomId = Mn.RoomId AND Mi.CloseDateTime < Mn.MeasureDateTime ORDER BY CloseDateTime DESC) Mp "
         "JOIN Room R ON Mn.RoomId = R.Id "
         "JOIN ZoneMeasure ZM ON R.ZoneId = ZM.ZoneId AND ZM.MeasureDateTime BETWEEN Mp.CloseDateTime AND Mn.MeasureDateTime "
         "WHERE (Mn.RoomKey LIKE '%103' OR Mn.RoomKey LIKE '%104' OR Mn.RoomKey LIKE '%106' OR Mn.RoomKey LIKE '%107' OR Mn.RoomKey LIKE '%211' OR Mn.RoomKey LIKE '%213' OR Mn.RoomKey LIKE '%214' OR Mn.RoomKey LIKE '%217' OR Mn.RoomKey LIKE '%218' OR Mn.RoomKey LIKE '%221' OR Mn.RoomKey LIKE '%226' OR Mn.RoomKey LIKE '%229' OR Mn.RoomKey LIKE '%309' OR Mn.RoomKey LIKE '%313' OR Mn.RoomKey LIKE '%314' OR Mn.RoomKey LIKE '%317' OR Mn.RoomKey LIKE '%318' OR Mn.RoomKey LIKE '%321' OR Mn.RoomKey LIKE '%326' OR Mn.RoomKey LIKE '%329' OR Mn.RoomKey LIKE '%222' OR Mn.RoomKey LIKE '%404' OR Mn.RoomKey LIKE '%406' OR Mn.RoomKey LIKE '%408' OR Mn.RoomKey LIKE '%409' OR Mn.RoomKey LIKE '%411' OR Mn.RoomKey LIKE '%413' OR Mn.RoomKey LIKE '%417' OR Mn.RoomKey LIKE '%421' OR Mn.RoomKey LIKE '%425' OR Mn.RoomKey LIKE '%430' OR Mn.RoomKey LIKE '%432' OR Mn.RoomKey LIKE '%435' OR Mn.RoomKey LIKE '%437' OR Mn.RoomKey LIKE '%503' OR Mn.RoomKey LIKE '%504' OR Mn.RoomKey LIKE '%508' OR Mn.RoomKey LIKE '%512' OR Mn.RoomKey LIKE '%516' OR Mn.RoomKey LIKE '%521' OR Mn.RoomKey LIKE '%525' OR Mn.RoomKey LIKE '%529' OR Mn.RoomKey LIKE '%531' OR Mn.RoomKey LIKE '%535' OR Mn.RoomKey LIKE '%551' OR Mn.RoomKey LIKE '%556' OR Mn.RoomKey LIKE '%561' OR Mn.RoomKey LIKE '%563' OR Mn.RoomKey LIKE '%566' OR Mn.RoomKey LIKE '%569' OR Mn.RoomKey LIKE '%602' OR Mn.RoomKey LIKE '%606' OR Mn.RoomKey LIKE '%610' OR Mn.RoomKey LIKE '%612' OR Mn.RoomKey LIKE '%616' OR Mn.RoomKey LIKE '%621' OR Mn.RoomKey LIKE '%625' OR Mn.RoomKey LIKE '%629' OR Mn.RoomKey LIKE '%631' OR Mn.RoomKey LIKE '%635' OR Mn.RoomKey LIKE '%651' OR Mn.RoomKey LIKE '%|662' OR Mn.RoomKey LIKE '%666' OR Mn.RoomKey LIKE '%703' OR Mn.RoomKey LIKE '%707' OR Mn.RoomKey LIKE '%713' OR Mn.RoomKey LIKE '%717' OR Mn.RoomKey LIKE '%720' OR Mn.RoomKey LIKE '%725' OR Mn.RoomKey LIKE '%732' OR Mn.RoomKey LIKE '%735' OR Mn.RoomKey LIKE '%751' OR Mn.RoomKey LIKE '%759' OR Mn.RoomKey LIKE '%763' OR Mn.RoomKey LIKE '%766' OR Mn.RoomKey LIKE '%767' OR Mn.RoomKey LIKE '%771' OR Mn.RoomKey LIKE '%773' OR Mn.RoomKey LIKE '%803' OR Mn.RoomKey LIKE '%806' OR Mn.RoomKey LIKE '%812' OR Mn.RoomKey LIKE '%836' OR Mn.RoomKey LIKE '%832' OR Mn.RoomKey LIKE '%826' OR Mn.RoomKey LIKE '%852' OR Mn.RoomKey LIKE '%858' OR Mn.RoomKey LIKE '%865') "
         "AND Mn.MeasureDateTime BETWEEN '2017-03-08 00:00:00.000' AND '2017-03-23 00:00:00.000' "
         "GROUP BY Mn.PartitionKey, Mn.RoomKey, Mn.Value, Mp.CloseDateTime, Mn.MeasureDateTime, R.Name, R.Type, R.FlooringType, R.Surface ")