Загрузка данных


truncate table orders cascade; insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b001', 1, '2025-03-12', '2025-03-25', 100); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b001', 2, '2025-03-15', '2025-03-28', 50); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b002', 1, '2025-04-08', '2025-04-20', 200); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b003', 3, '2025-05-18', '2025-05-31', 75); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b003', 4, '2025-05-20', '2025-06-01', 120); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b004', 2, '2025-06-22', null, 30); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b004', 5, '2025-06-25', null, 45); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b005', 1, '2025-07-05', '2025-07-15', 60); insert into orders (book_code, customer_id, order_date, execute_date, quantity) values ('b005', 3, '2025-07-08', null, 80);