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