gistfile1.txt

[
    {
      $match: {
        rated: "TV-PG",
      },
    },
    {
      $match:
        /**
         * query: The query in MQL.
         */
        {
          year: {
            $gt: 1965,
          },
        },
    },
    {
      $project: {
        title: 1,
        "tomatoes.viewer.rating": 1,
      },
    },
    {
      $group: {
        _id: "avgRating",
        averageViewerRatingOfTVPG: {
          $avg: "$tomatoes.viewer.rating",
        },
      },
    },
  ]