select  v.ITEM_CODE CODE
        ,i.ITEM_NAME 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