DELETE 
FROM ITEM 
WHERE STOCK_MANAGEMENT_TYPE = 1 
  AND 
  ( 
    NOT EXISTS 
    ( 
        SELECT STOCK.ITEM_CODE 
        FROM STOCK 
        WHERE STOCK.ITEM_CODE = ITEM.ITEM_CODE
    ) 
    OR EXISTS 
    ( 
        SELECT ITEM_CODE 
        FROM STOCK 
        WHERE STOCK.ITEM_CODE = ITEM.ITEM_CODE
        GROUP BY STOCK.ITEM_CODE 
        HAVING
                (
                    DATE ('2023-06-01', '-6 months') >= MAX(STOCK.LAST_DELIVERY_DATE) IS NOT NULL
                )     
                AND SUM(STOCK.ACTUAL_AMT) = 0
        )
    );