Resolved: MongoDB – Aggregate a sales table from orders

{
  id: "62aac8cfb5722d4c628a4a24";
  products: [
    {
      productId: "62aac8cfb5722d4c628a4a24",
      quantity: 1,
      total: 50,
    },
  ],
}

{
  id: "62aac8cfb5722d4c628a4a24";
  products: [
    {
      productId: "62aac8cfb5722d4c628a4a24",
      quantity: 2,
      total: 100,
    },
    {
      productId: "65fasd454daer57f2ads4c",
      quantity: 2,
      total: 100,
    },
  ],
}

{
  id: "62aac8cfb5722d4c628a4a24";
  products: [
    {
      productId: "62aac8cfb5722d4c628a4a24",
      quantity: 5,
      total: 200,
    },
  ],
}

[{
    productId:"62aac8cfb5722d4c628a4a24"
    quantity:8,
    total:350
},
{
    productId:"65fasd454daer57f2ads4c"
    quantity:2,
    total:200
}]

db.collection.aggregate([
  {
    $unwind: "$products"
  },
  {
    $group: {
      _id: "$products.productId",
      quantity: {
        $sum: "$products.quantity"
      },
      total: {
        $sum: "$products.total"
      }
    }
  },
  {
    "$project": {
      _id: 0,
      productId: "$_id",
      quantity: 1,
      total: 1
    }
  }
])