Aggregation definitions require an order key based on one of the following sources (determined according to the sequence below):

• the defied order key for the view
• the key resulting from ORDER BY clause
• grouping attributes (in sequence of definition)
• identifying key of data type