CORR with Other Functions
CORR can be combined with ordered analytical functions in a SELECT list, QUALIFY clause, or ORDER BY clause. For information on ordered analytical functions, see Ordered Analytical Functions.
CORR cannot be combined with aggregate functions within the same SELECT list, QUALIFY clause, or ORDER BY clause.