select  v.ITEM_CODE
        ,i.ITEM_NAME
        ,v.SUM_QTY
  from  (select  d.ITEM_CODE
        ,SUM(d.ORDER_QTY) SUM_QTY
  from  ORDERS s
        ,WAREHOUSE w
        ,ORDERS_DTL d
 where  s.WH_CODE = w.WH_CODE
   and  w.WH_NAME = '浦和倉庫'
   and  s.ORDER_NO = d.ORDER_NO
 group by d.ITEM_CODE
 having SUM(d.ORDER_QTY) >=50
 )v
 left outer join ITEM i on v.item_code = i.ITEM_CODE
   order by v.SUM_QTY*1 desc,v.ITEM_CODE desc