SELECT od.ITEM_CODE AS CODE
	, i.ITEM_NAME AS NAME
	, sum(od.ORDER_QTY) AS SUM_QTY
FROM ORDERS_DTL AS od
INNER JOIN ORDERS AS o
	ON od.ORDER_NO = o.ORDER_NO
inner join WAREHOUSE as w
 on o.wh_code = w.wh_code
LEFT JOIN ITEM AS i
	ON od.ITEM_CODE = i.ITEM_CODE
WHERE w.WH_name = '浦和倉庫'
GROUP BY od.item_code
	, i.item_name
HAVING SUM_QTY >= 50
ORDER BY sum_qty DESC
	, od.item_code DESC