DELETE 
FROM
  ITEM 
WHERE
  ITEM_CODE IN ( 
    SELECT
      I.ITEM_CODE 
    FROM
      STOCK AS S 
      INNER JOIN ITEM AS I 
        ON S.ITEM_CODE = I.ITEM_CODE 
    GROUP BY
      I.ITEM_CODE 
    HAVING
      MAX(DATE (LAST_DELIVERY_DATE)) <= DATE ('2023-06-01', '-6 month') 
      AND SUM(S.ACTUAL_AMT) = 0
  ) 
  AND STOCK_MANAGEMENT_TYPE = 1;