DELETE
FROM 
ITEM AS I
WHERE
I.STOCK_MANAGEMENT_TYPE = 1
AND (
  NOT EXISTS (SELECT 1 FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE)
  OR
  EXISTS (SELECT 1 FROM STOCK AS S
  WHERE S.ITEM_CODE = I.ITEM_CODE
 GROUP BY S.ITEM_CODE
 HAVING MAX(S.LAST_DELIVERY_DATE) <= '2022-12-01' AND SUM(S.ACTUAL_AMT) = 0
 )
)