DELETE FROM
    ITEM
WHERE  
    ITEM_NAME IN (
    SELECT
        I.ITEM_NAME
    FROM
        ITEM AS I
    LEFT OUTER JOIN
        STOCK AS S
      ON
        I.ITEM_CODE = S.ITEM_CODE
    WHERE
        I.STOCK_MANAGEMENT_TYPE = 1
      AND
        S.ITEM_CODE IS NULL
    GROUP BY
        S.ITEM_CODE
    HAVING
        (IFNULL(MAX(S.LAST_DELIVERY_DATE), '2099-12-31') <= DATE('2023-06-01', '-6 month')
         AND SUM(S.ACTUAL_AMT) = 0)
    );