Question

Retrieve the top five highest-rated products based on customer reviews from the product_reviews table.

Answer 1

SELECT product_id, product_name, AVG(review_rating) AS average_rating

FROM product_reviews

GROUP BY product_id, product_name

ORDER BY average_rating DESC

FETCH FIRST 5 ROWS ONLY;