The same sort of rewrite can be used when an outer reference aggregate function appears in clauses other than SELECT or HAVING.

• 如果外部引用集合函数出现在非SELECT或HAVING的子句中,则可以采用同一方法进行改写。