Skip to main content
All Problems
medium0% acceptance

Average Rating Per Product

The product team wants to find well-reviewed products. Calculate the average rating for each product that has at least 3 reviews. Return the product_id, average rating (rounded to 1 decimal), and review count, sorted by average rating descending.

Schema

🔑idINT
🔗product_idINT
🔗customer_idINT
ratingINT
commentTEXTNULL
review_dateTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute