Orders With Maximum Quantity Above Average

Compute the maximum order quantity per entity (e.g., per customer or product) using grouping, then return those entities whose maximum quantity is greater than the average of all those maximums. The challenge is to perform aggregation (MAX and AVG) and filter groups based on a comparison of aggregated values.