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