select
    SOD.ITEM_CODE as CODE,
    SI.ITEM_NAME as NAME,
    SUM(ORDER_QTY) as SUM_QTY
from
    ORDERS_DTL as SOD
left join 
    ITEM as SI
    on SOD.ITEM_CODE = SI.ITEM_CODE
    join
        ORDERS as SO
        on SOD.ORDER_NO = SO.ORDER_NO
    join
        WAREHOUSE as SW
        on SO.WH_CODE = SW.WH_CODE
where
    SW.WH_NAME is '浦和倉庫'
group by
    SOD.ITEM_CODE
having
    SUM_QTY >= 50
order by
    SUM_QTY DESC,
    SOD.ITEM_CODE DESC