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;
Retrieve the top five highest-rated products based on customer reviews from the product_reviews table.
Share:
You May Also Like
Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
- Interview
- November 30, 2023
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
- Interview
- November 30, 2023
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...
- Interview
- November 30, 2023
