select
_wstart AS window_start,
first (do1.input_date) AS input_date,
(
CAST(first (do1.input_value) as FLOAT) + CAST(first (do2.input_value) as FLOAT) + CAST(first (do3.input_value) as FLOAT) + CAST(first (do4.input_value) as FLOAT)
) / 4 as input_value
from
opcua.opcua_pci_do_1_set do1
Inner JOIN opcua.opcua_pci_do_2_set do2 on do1.input_date = do2.input_date
Inner JOIN opcua.opcua_pci_do_3_set do3 on do1.input_date = do3.input_date
Inner JOIN opcua.opcua_pci_do_4_set do4 on do1.input_date = do4.input_date
where
do1.input_date > “2025-11-13 00:00:00” INTERVAL(1h)
ORDER BY
window_start asc;