with d as
    (
        select o.order_no
        from orders o
        inner join warehouse wh
        on
        o.wh_code = wh.wh_code
        where wh.wh_name = '浦和倉庫'
    ), agg as (
    select
         dtl.item_code CODE
        ,sum(dtl.order_qty) SUM_QTY
    from
        orders_dtl dtl
    left outer join
        item i
    on
        dtl.item_code = i.item_code
    inner join d
    on
        dtl.order_no = d.order_no
    group by i.item_code
    having sum(dtl.order_qty) >= 50
    )
    select
         agg.code CODE
        ,IFNULL(item.item_name, 'NULL') NAME
        ,agg.SUM_QTY SUM_QTY
    from item
    right outer join agg
    on item.item_code = agg.code
    order by 3 desc, 1 desc