select
		DT.ITEM_CODE	as CODE,
		S.ITEM_NAME		as NAME,
		DT.ORDER_QTY	as SUM_QTY
from
		(
			select
				M.ITEM_CODE		as ITEM_CODE,
				sum(M.ORDER_QTY) as ORDER_QTY
			from
				ORDERS G
				inner join  WAREHOUSE Z  on (Z.WH_CODE = G.WH_CODE)
				inner join  ORDERS_DTL M  on (M.ORDER_NO = G.ORDER_NO)
			where
				Z.WH_NAME = '浦和倉庫'
			group by
				M.ITEM_CODE
		) as DT
		left  join   ITEM  S  on (S.ITEM_CODE  = DT.ITEM_CODE ) 
where
		DT.ORDER_QTY >= 50
order by
		DT.ORDER_QTY desc,
		DT.ITEM_CODE desc