SELECT DATEPART(year, MEAS_DT)  as YY
,      DATEPART(month, MEAS_DT) as MM
,      DATEPART(day, MEAS_DT)   as DD
,      DATEPART(hour, MEAS_DT)  as HH
,      LST1.PROD_N                        
,      LST1.KZ                            
,      convert(numeric(15,3), AVG(L1.CP1)) as CP1
,      convert(numeric(15,3), AVG(L1.CP2)) as CP2
,      convert(numeric(15,3), AVG(L1.CP3)) as CP3
,      convert(numeric(15,3), AVG(L1.CP4)) as CP4
FROM       last1 AS L1  
INNER JOIN last1 AS LST1 ON LST1.MEAS_DT = '2021-05-20 16:01'
		AND LST1.PROD_N = L1.PROD_N
WHERE L1.MEAS_DT > DATEADD(HOUR, -1, '2021-05-20 16:01')
	AND L1.MEAS_DT <= '2021-05-20 16:01'
GROUP BY LST1.PROD_N
,        LST1.KZ
ORDER BY LST1.PROD_N