DELETE
FROM ITEM
WHERE ITEM_CODE NOT IN (
    SELECT ITEM_CODE
    FROM STOCK
    WHERE LAST_DELIVERY_DATE > date('2023-06-01', 'localtime', '-6 months')
       OR ACTUAL_AMT > 0
)
 AND STOCK_MANAGEMENT_TYPE = 1
;