DELETE 
  FROM ITEM
 WHERE ITEM_CODE IN
(
SELECT ITEM_CODE
  FROM ITEM T1
  LEFT OUTER JOIN 
  (
   SELECT ITEM_CODE CODE
         ,MAX(LAST_DELIVERY_DATE) wk
     FROM STOCK
     WHERE LAST_DELIVERY_DATE IS NOT NULL
     GROUP BY 1
  ) T2
    ON T1.ITEM_CODE = T2.CODE
  LEFT OUTER JOIN 
  (
   SELECT ITEM_CODE CODE2
         ,SUM(ACTUAL_AMT) wk2
     FROM STOCK
     GROUP BY 1
  ) T4
    ON T1.ITEM_CODE = T4.CODE2
  WHERE NOT EXISTS
  (
   SELECT *
     FROM STOCK T3
     WHERE T1.ITEM_CODE = T3.ITEM_CODE
  )
    OR T2.wk <= '2022-12-01'
    AND T4.wk2 = 0
)
;