Hey there.. need some prisma help

model Video {
    id String @id @default(uuid())
    reactions Reactions[]
}

model Reactions {
  id       String       @id @default(uuid())
  type     ReactionType
  user     User?   @relation(fields: [user_id], references: [id])
  user_id String?

  video    Video?       @relation(fields: [video_id], references: [id])
  video_id String
}

enum ReactionType {
  NICE
  YIKES
  KEKW
  POGGERS
}

I want to query for a unique video and get count of reactions typewise

{
     id: "some video uuid",
     title:"My nice video",
     reactions : {
        nice : 44,
        yikes : 2,
        kekw : 41,
        poggers : 3
     }
}

any way to query this