Order by relation aggregate (like count)

[matthewmueller]

Problem

We support ordering by a relation field, but not order by a relation aggregate.

For example: get all users, order by post count.

prisma.user.findMany({
  orderBy: {
    posts: { 
      count: 'asc'
    }
  }
})

Additional context

• same request but for groupby: Order by aggregate (like count) in groupBy #5464
• order by relation field: Support Order by Relations #5008

[xbjfk]

Is there an equivalent for the other aggregates such as max, min and avg, or should I open a new issue?

[janpio]

Definitely a new issue if this does not exist yet.