We don‘t mean that the original SQL cannot do this kind of query, but using standard SQL to do such a query will be very complicated and inconsistent with user intuition.

What we have done is to provide an extended syntax of SQL so that users can more intuitively describe the query logic of aggregation base on time series data.