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