Undo a Wrong Delete

Medium

Description

Customer 25 asked to remove their review of product 25. Write the moderator's session, in this order:

In a transaction, delete every review written by customer 25. That was a mistake: undo the whole transaction.
In a new transaction, delete only customer 25's review of product 25, set product 25's rating to NULL, and commit.

Then show product_id, rating and reviews (the number of reviews the product still has) for products 24 and 25.

End your query with ORDER BY product_id.

Medium

Customer 25 asked to remove their review of product 25. Write the moderator's session, in this order:

In a transaction, delete every review written by customer 25. That was a mistake: undo the whole transaction.
In a new transaction, delete only customer 25's review of product 25, set product 25's rating to NULL, and commit.

Then show product_id, rating and reviews (the number of reviews the product still has) for products 24 and 25.

End your query with ORDER BY product_id.

Medium

Customer 25 asked to remove their review of product 25. Write the moderator's session, in this order:

In a transaction, delete every review written by customer 25. That was a mistake: undo the whole transaction.
In a new transaction, delete only customer 25's review of product 25, set product 25's rating to NULL, and commit.

Then show product_id, rating and reviews (the number of reviews the product still has) for products 24 and 25.

End your query with ORDER BY product_id.

Medium

Customer 25 asked to remove their review of product 25. Write the moderator's session, in this order:

In a transaction, delete every review written by customer 25. That was a mistake: undo the whole transaction.
In a new transaction, delete only customer 25's review of product 25, set product 25's rating to NULL, and commit.

Then show product_id, rating and reviews (the number of reviews the product still has) for products 24 and 25.

End your query with ORDER BY product_id.