Skip to main content
All Problems
hard0% acceptance

Customers Who Reviewed Their Purchases

The data quality team wants to verify that reviews come from actual buyers. Find all reviews where the reviewer actually purchased the product. Return the customer's full name, product name, rating, and order_date. A customer purchased a product if they have an order containing that product in order_items.

Schema

🔑idINT
first_nameTEXT
last_nameTEXT
emailTEXT
phoneTEXTNULL
cityTEXT
stateTEXT
countryTEXT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute