[Feature Request]: Support WITHIN GROUP ORDER BY clause for aggregate function

### Is there an existing issue for the same feature request?

- [x] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown
This is a SQL standard feature. Usually used with list_agg, array_agg, percentile, etc. For example, see

https://docs.snowflake.com/en/sql-reference/functions/array_agg
```

### Describe the feature you'd like

Implement this syntax. For now, let's make sure group_concat support both syntax,
group_concat(colx order by coly) and group_concat(colx) within group order by coly

Later adding other missing functions. Esp, percentile is not implemented yet. We will need to support this once percentile is implmented.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

```Markdown

```

### Additional information

_No response_