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