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