Reward Customers Who Reviewed
EasyDescription
To thank customers for their feedback, every customer who has written at least one
review gets 100 more loyalty points: once, however many reviews they wrote. Use the reviews
table to find them.
Then show customer_id, full_name and loyalty_points of every customer.
End your query with ORDER BY customer_id.
Tables
| customers |
|---|
| customer_id (PK) |
| full_name |
| loyalty_points |
| reviews |
|---|
| review_id (PK) |
| product_id (FK) |
| customer_id (FK) |
| rating |
| comment |
| created_at |