select
    od.item_code as CODE
    , i.item_name as NAME
    , sum(od.order_qty) as SUM_QTY
from
    orders as o
left join
    orders_dtl as od
on 
    o.order_no = od.order_no
left join 
    item as i
on
    od.item_code = i.item_code
left join
    warehouse as w
on
    o.wh_code = w.wh_code
where
    w.wh_name = '浦和倉庫'
group by
    CODE
having
    SUM_QTY >= 50
order by
    SUM_QTY desc
    , CODE desc
;