BEGIN;
INSERT INTO orders (id, customer_id, staff_id, created_at) VALUES (23, 10, 3, '2025-11-12 09:00');
INSERT INTO order_items VALUES (23, 4, 1, 220);
COMMIT;
SELECT o.id, oi.product_id FROM orders o JOIN order_items oi ON oi.order_id = o.id WHERE o.id = 23;

BEGIN;
DELETE FROM reviews;
ROLLBACK;
SELECT count(*) AS reviews_still_here FROM reviews;

BEGIN;
UPDATE products SET price = 155 WHERE id = 1;
SAVEPOINT before_delete;
DELETE FROM products WHERE id = 16;
ROLLBACK TO before_delete;
COMMIT;
SELECT name, price FROM products WHERE id IN (1, 16);