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