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