select
    dtl.ITEM_CODE as CODE,
    item.ITEM_NAME as NAME,
    sum(ORDER_QTY) as SUM_QTY
from
    ORDERS_DTL as dtl
    left outer join ITEM as item on dtl.ITEM_CODE = item.ITEM_CODE
    left outer join (
        select
            *
        from
            WAREHOUSE as wh
            inner join ORDERS as ord on wh.WH_CODE = ord.WH_CODE
        where
            wh.WH_NAME = '浦和倉庫'
    ) as s1 on dtl.ORDER_NO = S1.ORDER_NO
group by
    dtl.ITEM_CODE
having
    sum(ORDER_QTY) >= 50
order by
    SUM_QTY desc,
    CODE desc