Problem

Right now groupBy doesn't support ordering by an aggregate.

model User {
  id     Int   @id @default(autoincrement())
  town   String
}

List of towns, ordered by number of users in each town.

select town, count(town) 
from user
group by town
order by count(town) asc

Suggested solution

client.user.groupBy({
  orderBy: {
    _count: {
      town: 'desc'
    }
  }
})

Additional context

• First mentioned in: Preview feature feedback: groupBy #4893 (comment)
• There's a similar, but distinct feature request for ordering by relation: Order by relation aggregate (like count) #5439