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



        delete from
            item
        where
        STOCK_MANAGEMENT_TYPE = 1
        and(
                ITEM_CODE not in(
                    select
                        ITEM_CODE
                    from
                        STOCK
                )
            );