DELETE
FROM ITEM
WHERE ITEM.ITEM_CODE IN(
    SELECT ITEM.ITEM_CODE
    FROM ITEM
    LEFT JOIN STOCK ON ITEM.ITEM_CODE = STOCK.ITEM_CODE
    WHERE STOCK.ITEM_CODE IS NULL
    OR ITEM.ITEM_CODE IN (SELECT 
        ITEM.ITEM_CODE
        FROM ITEM
        LEFT JOIN STOCK ON ITEM.ITEM_CODE = STOCK.ITEM_CODE
        WHERE ITEM.STOCK_MANAGEMENT_TYPE = 1
        GROUP BY ITEM.ITEM_CODE
        HAVING MAX(STOCK.LAST_DELIVERY_DATE) <= DATE('2023-06-01', '-6 months')
        AND SUM(STOCK.ACTUAL_AMT) = 0
    )
)