-- Suggested testing environment: 
-- https://www.db-fiddle.com/ with MySQL version set to 8

-- Example case create statement:
CREATE TABLE item (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50) NOT NULL,
  quantity INT NOT NULL
);

CREATE TABLE item_archive (
  archive_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50) NOT NULL
);
  
INSERT INTO item (name, quantity) VALUES
  ("Coconut", 10),
  ("Lobster", 12),
  ("Kitten", 3);

-- Fill in the blanks in the following statement:
DELIMITER $$
CREATE ________ item_delete ___________ ON item 
FOR EACH ROW
BEGIN
  INSERT INTO item_archive(name) VALUES (__________);
END;
$$
DELIMITER ;

-- Example case delete and select:
DELETE FROM item WHERE name = "Coconut";

SELECT * FROM item_archive;

-- Expected output (in any order):
-- archive_id   name
-- ----------------------------
-- 1            Coconut