with SUM as ( 
    select ITEM_CODE , sum(ORDER_QTY) as QTY from ORDERS_DTL group by ITEM_CODE having QTY > 50 
)

select distinct D.ITEM_CODE as CODE , (select ITEM.ITEM_NAME from ITEM where D.ITEM_CODE = ITEM.ITEM_CODE ) as NAME , S.QTY as SUM_QTY
from ORDERS_DTL as D 
inner join SUM as S on D.ITEM_CODE = S.ITEM_CODE 
    where D.ORDER_NO in ( select ORDER_NO from ORDERS where ORDERS.WH_CODE in ( select WH_CODE from WAREHOUSE where WH_NAME = '浦和倉庫') )
--   and D.item_code in ( select ITEM_CODE from SUB  ) 
order by 3 desc , 1 desc