DELETE FROM ITEM
WHERE NOT ITEM_CODE IN(SELECT ITEM_CODE FROM STOCK) OR 
ITEM_CODE IN(SELECT ITEM_CODE FROM STOCK GROUP BY ITEM_CODE HAVING MAX(DATE(LAST_DELIVERY_DATE)) <= DATE('2022-12-01') AND SUM(ACTUAL_AMT) = 0)
AND STOCK_MANAGEMENT_TYPE = 1;