CREATE TABLE Production_june (LIKE Production INCLUDING ALL);


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


DELETE FROM ProductionItems
WHERE production_id IN (
    SELECT production_id FROM Production
    WHERE EXTRACT(MONTH FROM date) = 6
      AND EXTRACT(YEAR  FROM date) = 2026
);


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


SELECT * FROM Production_june;
SELECT * FROM Production;