DELETE FROM ITEM AS I 
WHERE STOCK_MANAGEMENT_TYPE=1 AND 
(NOT EXISTS 
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE)
OR EXISTS
    (SELECT
        ITEM_CODE
    FROM
        STOCK AS S
    WHERE
        I.ITEM_CODE = S.ITEM_CODE
    GROUP BY 
        ITEM_CODE
    HAVING
        (LAST_DELIVERY_DATE IS NOT NULL OR LAST_DELIVERY_DATE <= '2022-12-01') AND SUM(ACTUAL_AMT)=0));