select
    t2.ITEM_CODE AS CODE
    , t3.ITEM_NAME AS NAME
    , sum(t2.ORDER_QTY) AS SUM_QTY
from ORDERS t1
inner join ORDERS_DTL t2
    on t1.ORDER_NO = t2.ORDER_NO
LEFT OUTER join item t3
    on t2.ITEM_CODE = t3.ITEM_CODE
inner join WAREHOUSE t4
    on t1.WH_CODE = t4.WH_CODE
    and t4.WH_NAME = '浦和倉庫'
group by t2.ITEM_CODE having sum(t2.ORDER_QTY) >= 50
order by sum(t2.ORDER_QTY) desc,t2.ITEM_CODE desc