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