How to make a fetch in mongodb?

Question

MongoDB

Hello! I have a collection in mongodb. All documents there are built according to the model (mongoose).
Code:

{
  _id: ObjectId,
  name: String,
  shop: ObjectId
}

shop:

{
  _id: ObjectId,
  name: String
}

I need to select multiple records from a collection of shops, sorted by the number of codes that refer to that shop (via the codes->shop field).

Answer 1

It's nosql. you cannot join in it.
In this case, a counter is created in the Shop, which is increased or decreased at the time of adding or deleting Code.