Notice that TIMEID is not one of the grouping columns of the outer select.

注意，TIMEID 不是外层选择的分组列之一。

youdao

While the ordering of the grouping columns does not matter for a single grouping set or multiple grouping sets, the order of the columns does matter for ROLLUP.

对于单一分组集或多个分组集，分组列的次序是无所谓的；但是对于ROLLUP，列的次序不能随意安排。

youdao

If a rule must contain one aggregation, then you can compute additional aggregations on different columns in the same rule without impacting performance, as long as the grouping keys are the same.

如果规则必须包含一个聚合，那么可以在同一规则中，对不同列计算附加聚合，只要分组关键字相同，就不会影响性能。

youdao