delete from STOCK
                    where ITEM_CODE in(
                    select
                        ITEM_CODE
                    from
                        STOCK
                    group by
                        ITEM_CODE
                    having
                        max(coalesce(date(LAST_DELIVERY_DATE), 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
                )
            );
        select * 
        from item;