select
    ITEM.*
from
    ITEM
    inner join
        (
            select
                ITEM_CODE,
                MAX(LAST_DELIVERY_DATE) as MAX_DD,
                SUM(ACTUAL_AMT) as TOTAL_AMT
            from
                STOCK
            group by
                ITEM_CODE
            having
                not MAX_DD isnull
                and (
                    MAX_DD > datetime('2023-06-01', '-6months')
                    or TOTAL_AMT != 0
                )
        ) as EX_STOCK
        using(ITEM_CODE)
where
    STOCK_MANAGEMENT_TYPE = 1 ;