WITH A1 AS(
SELECT I.ITEM_CODE AS CODE, SUM(S.ACTUAL_AMT) AS ACTUAL_AMT
FROM ITEM AS I
LEFT JOIN STOCK AS S ON I.ITEM_CODE = S.ITEM_CODE
WHERE (S.ITEM_CODE IS NULL OR (DATE(S.LAST_DELIVERY_DATE) < DATE('2023-06-01', '-6 MONTH') AND S.LAST_DELIVERY_DATE IS NOT NULL))
GROUP BY I.ITEM_CODE)

DELETE FROM ITEM AS I
WHERE I.ITEM_CODE IN (SELECT CODE FROM A1 WHERE ACTUAL_AMT = 0)
AND I.STOCK_MANAGEMENT_TYPE = 1;