⭐ Feedback is the Fuel for Quality.
The quality team at Trustpilot flags orders that were delivered but never reviewed — each one is a missed opportunity to collect social proof.
Find all orders with status = 'delivered' that have no matching entry in the reviews table. Return order_id, customer_id, and order_date. Order by order_date ascending.
orders Table:
| Column | Type |
|---|---|
| order_id | integer |
| customer_id | integer |
| status | text |
| order_date | text |
reviews Table:
| Column | Type |
|---|---|
| review_id | integer |
| order_id | integer |
| rating | integer |
| reviewed_at | text |
Expected Outcome (Illustrative Sample):
| order_id | customer_id | order_date |
|---|---|---|
| 4 | 104 | 2024-01-15 |