select D.ITEM_CODE as CODE , (select ITEM.ITEM_NAME from ITEM where D.ITEM_CODE = ITEM.ITEM_CODE ) as NAME , sum(D.ORDER_QTY) as SUM_QTY
from ORDERS_DTL as D 
inner join ORDERS as O on D.ORDER_NO = O.ORDER_NO
    where O.WH_CODE in ( select WH_CODE from WAREHOUSE where WH_NAME = '浦和倉庫') 
group by ITEM_CODE   
having sum(D.ORDER_QTY) > 50 
order by 3 desc , 1 desc