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