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