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