795 (E)- 'partition' not defined for aggregation function
In order to call aggregation functions without preceding aggregation collection in a SELECT function, a property partition has to be defined in the calling object data type or in the SELECT statement. When defining the partition collection explicitly, it has to be defined before referring to the first aggregation function.