with vItemQty as
(select
	 od.ITEM_CODE
	,sum(ORDER_QTY) SUM_ORDER_QTY
	from ORDERS_DTL od
	inner join ORDERS o
		on o.ORDER_NO = od.ORDER_NO
	inner join WAREHOUSE wh
		on o.WH_CODE = wh.WH_CODE 
	where wh.WH_NAME = '浦和倉庫'
	group by
	 od.ITEM_CODE
	having sum(ORDER_QTY) >= 50)
select 
 iq.ITEM_CODE CODE
,i.ITEM_NAME NAME
,iq.SUM_ORDER_QTY SUM_QTY
from vItemQty iq
	left join ITEM i
	on iq.ITEM_CODE = i.ITEM_CODE
order by 
 iq.SUM_ORDER_QTY desc
,iq.ITEM_CODE desc