title: Query to calculate and return average rating from another collection?
body: <p>I have two collections, computers which is shown below</p>
  <pre><code>{&quot;_id&quot;:{&quot;$oid&quot;:&quot;6185bee4aca3214e77e748a9&quot;},&quot;name&quot;:&quot;Gaming PC&quot;,&quot;manufacturer&quot;:&quot;Dell&quot;,&quot;category&quot;:[&quot;Gaming&quot;],&quot;colour&quot;:&quot;black&quot;,&quot;price&quot;:1200.0,&quot;quantity&quot;:47.0,&quot;weight&quot;:10.0,&quot;parts&quot;:[{&quot;type&quot;:&quot;motherboard&quot;,&quot;manufacturer&quot;:&quot;AMD&quot;,&quot;cost&quot;:150.0,&quot;description&quot;:&quot;Motherboard suitable for gaming PCs&quot;},{&quot;type&quot;:&quot;ram&quot;,&quot;manufacturer&quot;:&quot;Corsair&quot;,&quot;cost&quot;:50.0,&quot;description&quot;:&quot;16gb 2400mhz RAM&quot;},{&quot;type&quot;:&quot;cpu&quot;,&quot;manufacturer&quot;:&quot;Intel&quot;,&quot;cost&quot;:250.0,&quot;description&quot;:&quot;AMD 5600X Processor&quot;},{&quot;type&quot;:&quot;gpu&quot;,&quot;manufacturer&quot;:&quot;NVIDIA&quot;,&quot;cost&quot;:600.0,&quot;description&quot;:&quot;NVIDIA GTX3080&quot;},{&quot;type&quot;:&quot;storage&quot;,&quot;manufacturer&quot;:&quot;Seagate&quot;,&quot;cost&quot;:80.0,&quot;description&quot;:&quot;1TB SSD&quot;}],&quot;reviews&quot;:[&quot;review01&quot;,&quot;review02&quot;,&quot;review10&quot;]},
  
  {&quot;_id&quot;:{&quot;$oid&quot;:&quot;6185c06eaca3214e77e748aa&quot;},&quot;name&quot;:&quot;Office PC&quot;,&quot;manufacturer&quot;:&quot;HP&quot;,&quot;category&quot;:[&quot;Work&quot;,&quot;Office&quot;],&quot;colour&quot;:&quot;black&quot;,&quot;price&quot;:400.0,&quot;quantity&quot;:102.0,&quot;weight&quot;:12.0,&quot;parts&quot;:[{&quot;type&quot;:&quot;motherboard&quot;,&quot;manufacturer&quot;:&quot;XYZ&quot;,&quot;cost&quot;:70.0,&quot;description&quot;:&quot;Reliable motherboard&quot;},{&quot;type&quot;:&quot;ram&quot;,&quot;manufacturer&quot;:&quot;HP&quot;,&quot;cost&quot;:10.0,&quot;description&quot;:&quot;4gb 2400mhz RAM&quot;},{&quot;type&quot;:&quot;cpu&quot;,&quot;manufacturer&quot;:&quot;Intel&quot;,&quot;cost&quot;:100.0,&quot;description&quot;:&quot;Built In Processor&quot;},{&quot;type&quot;:&quot;gpu&quot;,&quot;manufacturer&quot;:&quot;HP&quot;,&quot;cost&quot;:75.0,&quot;description&quot;:&quot;On board graphics&quot;},{&quot;type&quot;:&quot;storage&quot;,&quot;manufacturer&quot;:&quot;Seagate&quot;,&quot;cost&quot;:20.0,&quot;description&quot;:&quot;1TB HDD&quot;}],&quot;reviews&quot;:[&quot;review03&quot;]},
  
  {&quot;_id&quot;:{&quot;$oid&quot;:&quot;6185c244aca3214e77e748ab&quot;},&quot;name&quot;:&quot;Chromebook&quot;,&quot;manufacturer&quot;:&quot;Acer&quot;,&quot;category&quot;:[&quot;Portable&quot;,&quot;Lightweight&quot;,&quot;Work&quot;,&quot;Student&quot;],&quot;colour&quot;:&quot;red&quot;,&quot;price&quot;:350.0,&quot;quantity&quot;:61.0,&quot;weight&quot;:4.0,&quot;parts&quot;:[{&quot;type&quot;:&quot;motherboard&quot;,&quot;manufacturer&quot;:&quot;XYZ&quot;,&quot;cost&quot;:40.0,&quot;description&quot;:&quot;Reliable motherboard for Laptops&quot;},{&quot;type&quot;:&quot;ram&quot;,&quot;manufacturer&quot;:&quot;Acer&quot;,&quot;cost&quot;:10.0,&quot;description&quot;:&quot;Built in 4gb RAM&quot;},{&quot;type&quot;:&quot;cpu&quot;,&quot;manufacturer&quot;:&quot;AMD&quot;,&quot;cost&quot;:100.0,&quot;description&quot;:&quot;Built In Processor&quot;},{&quot;type&quot;:&quot;gpu&quot;,&quot;manufacturer&quot;:&quot;Acer&quot;,&quot;cost&quot;:45.0,&quot;description&quot;:&quot;On board graphics&quot;},{&quot;type&quot;:&quot;storage&quot;,&quot;manufacturer&quot;:&quot;Acer&quot;,&quot;cost&quot;:25.0,&quot;description&quot;:&quot;64GB HDD&quot;}],&quot;reviews&quot;:[&quot;review04&quot;,&quot;review05&quot;]}
  </code></pre>
  <p>And the reviews collection;</p>
  <pre><code>{&quot;_id&quot;:&quot;review01&quot;,&quot;reviewer&quot;:&quot;Jack Weir&quot;,&quot;rating&quot;:5.0,&quot;text&quot;:&quot;Very good product!&quot;,&quot;created&quot;:&quot;2021, 08, 03&quot;},
  {&quot;_id&quot;:&quot;review02&quot;,&quot;reviewer&quot;:&quot;Adam Smith&quot;,&quot;rating&quot;:3.0,&quot;text&quot;:&quot;Good value for money&quot;,&quot;created&quot;:&quot;2021, 09, 04&quot;},
  {&quot;_id&quot;:&quot;review03&quot;,&quot;reviewer&quot;:&quot;Luke Bridges&quot;,&quot;rating&quot;:1.0,&quot;text&quot;:&quot;Not good!&quot;,&quot;created&quot;:&quot;2021, 10, 21&quot;},
  {&quot;_id&quot;:&quot;review04&quot;,&quot;reviewer&quot;:&quot;Richard Lamb&quot;,&quot;rating&quot;:4.0,&quot;text&quot;:&quot;Runs very smoothly&quot;,&quot;created&quot;:&quot;2021, 11, 03&quot;},
  {&quot;_id&quot;:&quot;review05&quot;,&quot;reviewer&quot;:&quot;Pamela Halpert&quot;,&quot;rating&quot;:4.0,&quot;text&quot;:&quot;Easy to setup&quot;,&quot;created&quot;:&quot;2021, 11, 04&quot;},
  {&quot;_id&quot;:&quot;review06&quot;,&quot;reviewer&quot;:&quot;Michael Scott&quot;,&quot;rating&quot;:5.0,&quot;text&quot;:&quot;Would highly recommend&quot;,&quot;created&quot;:&quot;2021, 11, 05&quot;},
  {&quot;_id&quot;:&quot;review07&quot;,&quot;reviewer&quot;:&quot;Angela Lewis&quot;,&quot;rating&quot;:2.0,&quot;text&quot;:&quot;A bit too pricey&quot;,&quot;created&quot;:&quot;2021, 11, 06&quot;},
  {&quot;_id&quot;:&quot;review08&quot;,&quot;reviewer&quot;:&quot;Dexter Morgan&quot;,&quot;rating&quot;:3.0,&quot;text&quot;:&quot;Does the job&quot;,&quot;created&quot;:&quot;2021, 11, 06&quot;},
  {&quot;_id&quot;:&quot;review09&quot;,&quot;reviewer&quot;:&quot;Lisa Simpson&quot;,&quot;rating&quot;:2.0,&quot;text&quot;:&quot;Okay but not great&quot;,&quot;created&quot;:&quot;2021, 11, 06&quot;},
  {&quot;_id&quot;:&quot;review10&quot;,&quot;reviewer&quot;:&quot;Marge Simpson&quot;,&quot;rating&quot;:5.0,&quot;text&quot;:&quot;Wonderful Computer exactly what I was after!&quot;,&quot;created&quot;:&quot;2021, 11, 07&quot;}
  </code></pre>
  <p>How do I write a query that can return the name of each product and the average rating it has received from any ratings in the review property?</p>
  <p>For example I would like the result of the query to show 'name: &quot;Gaming PC&quot;, Average rating: 4.3'</p>