41.Shopper - 列出评价最高的产品

有很多选择的时候找到合适的产品,有时变得势不可挡。一个无偏见的观点,为什么不使用产品评级?

Don也想知道高评级产品的前5位。

你看到的只是一小部分与顾客相关的查询,但是您可以使用N1QL为更高级的查询场景在您的应用程序。在接下来的几张幻灯片,我们将查询从商人的角度。

SELECT product.name, ROUND(AVG(reviews.rating),1) AS avg_rating 
FROM reviews JOIN product ON KEYS reviews.productId 
GROUP BY product 
ORDER BY AVG(reviews.rating) DESC LIMIT 5

结果：

{
  "results": [
    {
      "avg_rating": 4.5,
      "name": "Waring Pro IC70 Professional Stainless Steel Large-Capacity Ice Crusher"
    },
    {
      "avg_rating": 4.2,
      "name": "Racor PHL-1R Pro HeavyLift 4-by-4-Foot Cable-Lifted Storage Rack"
    },
    {
      "avg_rating": 4.2,
      "name": "Marineland Rite-Size Cartridge E, 4-Pack"
    },
    {
      "avg_rating": 4.1,
      "name": "Midwest 1524 iCrate Single-Door Pet Crate 24-By-18 -By-19-Inch"
    },
    {
      "avg_rating": 4.1,
      "name": "Dorcy 41-1643 30 Lumen 3 Volt LED Replacement Bulb"
    }
  ]
}