CREATE TABLE Order_june (LIKE Orders INCLUDING ALL);


INSERT INTO Order_june
SELECT * FROM Orders
WHERE EXTRACT(MONTH FROM date) = 6
  AND EXTRACT(YEAR  FROM date) = 2026;


DELETE FROM OrderItems
WHERE order_id IN (
    SELECT order_id FROM Orders
    WHERE EXTRACT(MONTH FROM date) = 6
      AND EXTRACT(YEAR  FROM date) = 2026
);


DELETE FROM Orders
WHERE EXTRACT(MONTH FROM date) = 6
  AND EXTRACT(YEAR  FROM date) = 2026;


SELECT * FROM Order_june;
SELECT * FROM Orders;