delete
            from
                STOCK
            where
            ITEM_CODE =(
            select
                ITEM_CODE
            from
                STOCK
            group by
                STOCK.ITEM_CODE
            having
                max(date(coalesce(LAST_DELIVERY_DATE, '2023-06-01'))) <= date('2023-06-01', '-6 month')
                and sum(ACTUAL_AMT) = 0
            )and exists(select ITEM_CODE from item where STOCK.ITEM_CODE = item.ITEM_CODE and STOCK_MANAGEMENT_TYPE = 1);
            
delete from
    item
where
    (
        ITEM_CODE not in(
            select
                ITEM_CODE
            from
                STOCK
        )
        and STOCK_MANAGEMENT_TYPE = 1
    )
    or (
        ITEM_CODE = (
            select
                ITEM_CODE
            from
                STOCK
            group by
                STOCK.ITEM_CODE
            having
                max(date(coalesce(LAST_DELIVERY_DATE, '2023-06-01'))) <= date('2023-06-01', '-6 month')
                and sum(ACTUAL_AMT) = 0
        )
        and STOCK_MANAGEMENT_TYPE = 1
    );