Hi, I have a structure a bit like this

model Thanks {
    target: string
    reason: string
}

with target being a user's name. I'm wondering how I can find the top 10 users that have the most thanks? Thank you.

You can use

await prisma.thanks.groupBy({
     orderBy: {
        _count: {
              target:  'desc'
         }
     },
     _count: {
       target: true
     },
     by: ['target'],
     take: 10
})

The result may be what you want. Each element of that have count of thanks and userId as target.