DELETE FROM ITEM
--select * from item
WHERE
ITEM_CODE NOT IN (
    SELECT ITEM_CODE
    FROM STOCK
)
or 
 (  STOCK_MANAGEMENT_TYPE = 1 and
    ITEM_CODE IN (
        SELECT ITEM_CODE
        FROM STOCK
        WHERE ACTUAL_AMT=0
        and julianday(LAST_DELIVERY_DATE) <= date('2023-06-01', '-6 months', 'start of month')
)
)
;