select
    ODD.ITEM_CODE as CODE,
    IT.ITEM_NAME as NAME,
    SUM(ODD.ORDER_QTY) as SUM_QTY
from
    ORDERS as OD
    inner join ORDERS_DTL as ODD on OD.ORDER_NO = ODD.ORDER_NO
    inner join WAREHOUSE as WH on OD.WH_CODE = WH.WH_CODE
    left outer join ITEM as IT on ODD.ITEM_CODE = IT.ITEM_CODE
where
    WH.WH_NAME = '浦和倉庫'
group by
    CODE,
    NAME
having 
    SUM_QTY >= 50
order by
    SUM_QTY desc,
    CODE desc