select
 d.ITEM_CODE CODE
,i.ITEM_NAME NAME
,sum(d.ORDER_QTY) SUM_QTY
from ORDERS o
left join ORDERS_DTL d
 on o.ORDER_NO=d.ORDER_NO
left join ITEM i
 on d.ITEM_CODE=i.ITEM_CODE
left join WAREHOUSE w
 on o.WH_CODE=w.WH_CODE
 and w.WH_NAME='浦和倉庫'
group by
 d.ITEM_CODE
,i.ITEM_NAME
having
 sum(d.ORDER_QTY)>=50
order by
 sum(d.ORDER_QTY) desc
,d.ITEM_CODE desc