and then divide by the number of data points. Avg function use for that we have used with groups and window functions This paper have other three measurements of central tendency starting with median.

(ksql 0.23.1) Having a GROUP BY clause in a SELECT query forces you to have at least one aggregate function in the query, even if all the expressions have been aggregated. Even though the expressions ...