[Subtask]: Sort Aggregate

Open

#20,651 opened on Dec 9, 2024 1 comment 0 reactions 2 assignees Claimed by @aunjgr View on GitHub

kind/subtask

Description

### Parent Issue

#20650

### Detail of Subtask

select avg(X) from T group by A, B, C

We can use a sort based aggregate. Scan T -> Order by A, B, C -> SortAgg

### Describe implementation you've considered

_No response_

### Additional information

_No response_

This issue has not been assessed yet.