delete FROM ITEM 
WHERE 
	not exists (
		select * from STOCK 
		where 
			ITEM.ITEM_CODE = STOCK.ITEM_CODE
		and ITEM.STOCK_MANAGEMENT_TYPE = 1
	)
;
delete FROM ITEM
WHERE exists (
select * from STOCK
where ITEM.ITEM_CODE = STOCK.ITEM_CODE
and STOCK.LAST_DELIVERY_DATE < '2022-11-30'
and ITEM.STOCK_MANAGEMENT_TYPE = 1
)
;