There are so many choices when it comes to finding the right products, and sometimes it gets overwhelming. To get an un-biased view, why not use product ratings?
Don wants to know the top 5 highly rated products.
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
What you saw was just a handful of queries that were relevant to a shopper, but you can use N1QL for more advanced query scenarios in your applications. In the next few slides, we will go over queries from the merchant point of view.