WITH ITEM_LAST_DELIVERY_DATE AS (
    SELECT ITEM_CODE AS CODE,
          MAX(LAST_DELIVERY_DATE) AS LDD
    FROM STOCK
    GROUP BY ITEM_CODE
)

DELETE FROM ITEM
WHERE ITEM_CODE NOT IN (SELECT DISTINCT ITEM_CODE FROM STOCK)
   OR ITEM_CODE     IN (SELECT          ITEM_CODE FROM STOCK 
                                                  WHERE ITEM_CODE IN (
                                                                      SELECT ITEM_CODE 
                                                                      FROM STOCK
                                                                      JOIN ITEM_LAST_DELIVERY_DATE
                                                                      ON STOCK.ITEM_CODE = ITEM_LAST_DELIVERY_DATE.CODE
                                                                      WHERE LDD <= '2022-12-01'
                                                                      AND STOCK_MANAGEMENT_TYPE = 1
                                                                      )
                                                    AND ACTUAL_AMT = 0
                        )