Skip to main content
All Problems
hard0% acceptance

Deduplicate Reviews with ROW_NUMBER

Some customers may have left multiple reviews for the same product. For each customer-product pair, keep only the most recent review. Return the review id, product_id, customer_id, rating, and review_date.

Schema

🔑idINT
🔗product_idINT
🔗customer_idINT
ratingINT
commentTEXTNULL
review_dateTEXT
postgresql

Run your query to see results

Press Ctrl + Enter to execute