db={reviews:[{"_id":"0M63HJQ9MKXR538084U92Zt2","restaurant_id":"EA50k3O5vxEi543z949L6u8M","user_id":"s0j45hXpv4tgCAl5vD8a2b87","rating":4.8,"review":"Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti.\n\nNullam porttitor lacus at turpis. Donec posuere metus vitae ipsum. Aliquam non mauris.","date":"2019-06-03T06:36:19.000Z"},{"_id":"9K13616ouSn5H2o17l5Xp0x6","restaurant_id":"LOs7NI67ijwH1g26e38067G0","user_id":"RvYx1J1mU532iD3833286I7h","rating":2.3,"review":"Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi.","date":"2019-09-10T06:31:43.000Z"},{"_id":"754233Q64d553XguY2Vi28a2","restaurant_id":"EA50k3O5vxEi543z949L6u8M","user_id":"s0j45hXpv4tgCAl5vD8a2b87","rating":4.7,"review":"Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi.\n\nCras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque.","date":"2019-06-04T02:17:01.000Z"},{"_id":"366sy7s0YSLq854q8KXiVPJ3","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"742LJ2r0qR114C433e75l943","rating":3.2,"review":"Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem.\n\nDuis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit.","date":"2019-09-23T19:35:50.000Z"},{"_id":"KkGUC17C8Mf67I2aVl85148U","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"742LJ2r0qR114C433e75l943","rating":1.9,"review":"Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat.\n\nPraesent blandit. Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.","date":"2019-09-16T07:13:09.000Z"},{"_id":"56WO69n9J7Hj909ak1K1Ms54","restaurant_id":"LOs7NI67ijwH1g26e38067G0","user_id":"s0j45hXpv4tgCAl5vD8a2b87","rating":2.3,"review":"Morbi porttitor lorem id ligula. Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.","date":"2019-08-25T20:01:23.000Z"},{"_id":"XD7kq7NW3GUco65E08v0A2Ii","restaurant_id":"EA50k3O5vxEi543z949L6u8M","user_id":"s0j45hXpv4tgCAl5vD8a2b87","rating":4.9,"review":"Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo. Morbi ut odio.","date":"2019-07-05T20:51:14.000Z"},{"_id":"uZ37226988n8b14gN1Ztccp8","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"RvYx1J1mU532iD3833286I7h","rating":4.1,"review":"Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus.\n\nPhasellus in felis. Donec semper sapien a libero. Nam dui.","date":"2019-08-26T13:06:08.000Z"},{"_id":"gZ586p1D39O1L9p019s98KYS","restaurant_id":"EA50k3O5vxEi543z949L6u8M","user_id":"RvYx1J1mU532iD3833286I7h","rating":1.6,"review":"Cras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque.","date":"2019-12-18T22:49:58.000Z"},{"_id":"xOrd6j381Xo2oY99qzz06jpI","restaurant_id":"LOs7NI67ijwH1g26e38067G0","user_id":"742LJ2r0qR114C433e75l943","rating":1.3,"review":"Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem.\n\nDuis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit.","date":"2019-04-01T23:41:38.000Z"},{"_id":"997VSYwf6Krvpk290kojs37e","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"RvYx1J1mU532iD3833286I7h","rating":4.6,"review":"Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi.\n\nCras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque.","date":"2019-04-23T15:35:07.000Z"},{"_id":"Ijc363luT8zH1siEvcq5wk7O","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"742LJ2r0qR114C433e75l943","rating":2,"review":"Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo. Morbi ut odio.","date":"2019-09-14T00:02:27.000Z"},{"_id":"tm2350p78617P7BRb8GbM1Ji","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"742LJ2r0qR114C433e75l943","rating":1.3,"review":"Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl.\n\nAenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum.","date":"2019-10-28T20:52:12.000Z"},{"_id":"6wmXf008ABm51w47z9tL9C1i","restaurant_id":"Bujxd5U6k924D0M04NF2kOT6","user_id":"742LJ2r0qR114C433e75l943","rating":4.8,"review":"Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit.\n\nDonec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque.","date":"2019-09-28T01:26:18.000Z"},{"_id":"56G03D5Tq6M2o3W61911wQ2O","restaurant_id":"LOs7NI67ijwH1g26e38067G0","user_id":"s0j45hXpv4tgCAl5vD8a2b87","rating":3.4,"review":"Vestibulum quam sapien, varius ut, blandit non, interdum in, ante. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Duis faucibus accumsan odio. Curabitur convallis.\n\nDuis consequat dui nec nisi volutpat eleifend. Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus.","date":"2019-10-21T04:01:11.000Z"}],"restaurants":[{"_id":"Bujxd5U6k924D0M04NF2kOT6","address":"Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem.","name":"Stringtough"},{"_id":"EA50k3O5vxEi543z949L6u8M","address":"Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.","name":"Zontrax"},{"_id":"LOs7NI67ijwH1g26e38067G0","address":"Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem.","name":"Holdlamis"}]}

db.restaurants.aggregate([{$lookup:{from:"reviews","let":{restaurant_id:"$_id"},pipeline:[{$match:{$expr:{$eq:["$restaurant_id","$$restaurant_id"]}}},{$group:{_id:null,"number_of_ratings":{$sum:1},"average_rating":{$avg:"$rating"}}}],as:"review_stats"}},{$unwind:{path:"$review_stats"}},{$unset:"review_stats._id"}])