--DELETE FROM ITEM
select * from item
WHERE STOCK_MANAGEMENT_TYPE = 1 and
(
    ITEM_CODE NOT IN (
        SELECT ITEM_CODE
        FROM STOCK
    )
    or 
     (  
        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')
    )
    )
)
;