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