Undo Only the Delhi Bonus
EasyDescription
In one transaction:
- give every customer in Pune 200 more loyalty points
- set a savepoint
- give every customer in Delhi 500 more loyalty points
- the Delhi bonus was a mistake: undo only that step, keeping the Pune bonus
- commit
Then show customer_id, city and loyalty_points of the customers in Pune and Delhi.
End your query with ORDER BY customer_id.
Tables
| customers |
|---|
| customer_id (PK) |
| full_name |
| city |
| loyalty_points |