BEGIN; INSERT INTO orders (customer_id) VALUES (2) RETURNING order_id; INSERT INTO order_items (order_id, book_id, quantity) VALUES (<new_order_id>, 3, 1); COMMIT;
