Группировка значений каждые 2 часа

SELECT datetimefromparts(datepart(YEAR, [Datetime]),datepart(MONTH, [Datetime]), datepart(DAY, [Datetime]),datepart(HOUR, dateadd(HOUR, datediff(HOUR, 0,datetime)/2*2,0)), 0, 0, 0) AS [DATA], avg(PressOilIn_P2) AS PressOilIn_P2, avg(PressOilOut_P2) AS PressOilOut_P2, avg(PressGas_P2) AS PressGas_P2, avg(TempOilIn_P2) AS TempOilIn_P2, 
    avg(TempOilOut_P2) AS TempOilOut_P2, avg(TempGas_P2) AS TempGas_P2, avg(TempWater_P2) AS TempWater_P2, avg(ConsumVOil_P2) AS ConsumVOil_P2, avg(ConsumMOil_P2) AS ConsumMOil_P2, avg(ConsumGas_PP2_2hPrev) AS ConsumGas_PP2_2hPrev
    FROM #temp2  
    GROUP BY datetimefromparts(datepart(YEAR, [Datetime]), datepart(MONTH, [Datetime]), datepart(DAY, [Datetime]),datepart(HOUR, dateadd(HOUR, (datediff(HOUR, 0,datetime)/2*2),0)), 0, 0, 0) 
    ORDER BY [DATA] ASC

datepart(HOUR,[Datetime])/2*2+2

(datepart(HOUR,[Datetime])/2*2+2) % 24

SELECT datetimefromparts(datepart(YEAR, Datetime),datepart(MONTH, Datetime), datepart(DAY, Datetime),datepart(HOUR, dateadd(HOUR, datediff(HOUR, 0,Datetime)/2*2+2,0)), 0, 0, 0) AS [DATA], avg(PressOilIn_P1) AS PressOilIn_P1, avg(PressOilOut_P1) AS PressOilOut_P1, avg(PressGas_P1) AS PressGas_P1, avg(TempOilIn_P1) AS TempOilIn_P1, 
    avg(TempOilOut_P1) AS TempOilOut_P1, avg(TempGas_P1) AS TempGas_P1, avg(TempWater_P1) AS TempWater_P1, avg(ConsumVOil_P1) AS ConsumVOil_P1, avg(ConsumMOil_P1) AS ConsumMOil_P1, avg(ConsumGas_PP1_2hPrev) AS ConsumGas_PP1_2hPrev
    FROM #temp1  
    GROUP BY datetimefromparts(datepart(YEAR, [Datetime]), datepart(MONTH, [Datetime]), datepart(DAY, [Datetime]),datepart(HOUR, dateadd(HOUR, (datediff(HOUR, 0,datetime)/2*2+2)%24,0)), 0, 0, 0)
    ORDER BY [DATA] ASC