select
  dtl.ITEM_CODE as CODE
 ,min(itm.ITEM_NAME) as NAME
 ,sum(dtl.ORDER_QTY) as SUM_QTY
from
    WAREHOUSE as ware
inner join
    ORDERS as main using(WH_CODE)
inner join
    ORDERS_DTL as dtl using(ORDER_NO)
left join
    ITEM as itm on dtl.ITEM_CODE = itm.ITEM_CODE
where
    ware.WH_NAME = '浦和倉庫'
group by
     dtl.ITEM_CODE
having
    sum(dtl.ORDER_QTY) >= 50
order by
     SUM_QTY desc
    ,CODE desc