WITH subtbl(flight_id, charges, duration) AS (SELECT flight_id, charges, duration FROM FlightExp) SELECT * FROM TABLE ( TD_SYSFNLIB.TD_SEQUENCED_AVG(NEW VARIANT_TYPE(subtbl.flight_id), NEW VARIANT_TYPE(subtbl.charges), subtbl.duration) RETURNS (flight_id INT, charges FLOAT, duration PERIOD(TIMESTAMP(6) WITH TIME ZONE)) HASH BY flight_id /* input data is redistributed on column, flight_id */ LOCAL ORDER BY flight_id, duration) /* input data is sorted on these columns */ AS DT(flight_id, charges, duration) ORDER BY 1,3;