🧪 Scalability: The ability to aggregate "row_number" and "rank" by "count'.

[oalexdoda]

Is your proposal related to a problem?

Described what I'm trying to achieve here:
#8923

Describe the solution you'd like

An easy way to run an aggregate that returns the row_number(), and rank(), over a value such as count, sum, etc. Absolutely essential when designing systems like leaderboards at scale.

Describe alternatives you've considered

Tried getting the raw SQL query from "Analyze" and tinkering around with it, but couldn't get to a successful result. A built-in solution would save hours of work and help unlock an essential way to use Hasura aggregations at scale.