DELETE FROM ITEM AS A
WHERE (
    NOT EXISTS (
        SELECT X.ITEM_CODE
        FROM STOCK X
        WHERE X.ITEM_CODE = A.ITEM_CODE
    )
    OR
    EXISTS (
        SELECT
            X1.ITEM_CODE AS ITEM_CODE,
            X2.MAX_LAST_DELIVERY_DATE AS MAX_LAST_DELIVERY_DATE,
            X1.ACTUAL_AMT AS ACTUAL_AMT
        FROM STOCK X1
        INNER JOIN (
            SELECT
                Y.ITEM_CODE AS ITEM_CODE,
                MAX(Y.LAST_DELIVERY_DATE) AS MAX_LAST_DELIVERY_DATE
            FROM STOCK Y
            GROUP BY Y.ITEM_CODE
        ) X2
        ON X1.ITEM_CODE = X2.ITEM_CODE
        WHERE X2.MAX_LAST_DELIVERY_DATE <= DATE('2022-12-01')
        AND X1.ACTUAL_AMT = 0
        AND X1.ITEM_CODE = A.ITEM_CODE
    )
)
AND A.STOCK_MANAGEMENT_TYPE = 1