Rishabh570

[
  {
    "_id": { "year": "2016" },
    "avgRating": 5.9
  },
  {
    "_id": { "year": "1896" },
    "avgRating": 6
  },
  {

Rishabh570

{
  "$group": {
    "_id": {
      "year": "$release_year",
    },
    "ratings": {
      "$push": "$rating"
    }
  }
}

Rishabh570

[
  {
    "_id": { "year": "1896" },
    "ratings": [ 6 ]
  },
  {
    "_id": { "year": "2016" },
    "ratings": [ 5.9 ]
  },
  {

Rishabh570

{
  "$group": {
    "_id": {
      "rating": "$rating"
    },
    "releasedIn": {
      "$addToSet": "$release_year"
    }
  }
}

Rishabh570

[
  {
    "_id": { "rating": 8.5 },
    "releasedIn": [ "2005" ]
  },
  {
    "_id": { "rating": 7.1 },
    "releasedIn": [ "2005" ]
  },
  {

Rishabh570

{
  "$group": {
    "_id": {
      "year": "$release_year"
    },
    "minRating": { "$min": "$rating" }
  }
},
{
  "$match": {

Rishabh570

[
  {
    "_id": {
      "year": "2021"
    },
    "minRating": 9
  },
  {
    "_id": {
      "year": "2005"

Rishabh570

{
  "$sort": {
    "release_year": 1,
    "rating": -1
  }
},
{
  "$group": {
    "_id": "$release_year",
    "highestRating": {

Rishabh570

[
  {
    "rating": 6,
    "release_year": "1896"
  },
  {
    "rating": 8.5,
    "release_year": "2005"
  },
  {

Rishabh570

{
  "rating": 8.5,
  "release_year": "2005"
},
{
  "rating": 7.1,
  "release_year": "2005"
}