DELETE FROM
    ITEM
WHERE
    STOCK_MANAGEMENT_TYPE=1
    AND ITEM_CODE NOT IN (SELECT ITEM_CODE FROM STOCK GROUP BY ITEM_CODE)
;

DELETE FROM
    ITEM
WHERE
    STOCK_MANAGEMENT_TYPE=1
    AND ITEM_CODE IN (
        SELECT
            ITEM_CODE
        FROM
            STOCK
        WHERE
            ACTUAL_AMT=0
        GROUP BY
            ITEM_CODE
        HAVING
            MAX(LAST_DELIVERY_DATE) <= DATE('2023-06-01', '-6 months')
        )
;