SELECT
	O2.ITEM_CODE CODE
,	ITEM.ITEM_NAME NAME
,	SUM(O2.ORDER_QTY) SUM_QTY
FROM
	ORDERS_DTL AS O2
		LEFT OUTER JOIN ITEM
			ON ITEM.ITEM_CODE = O2.ITEM_CODE
WHERE
	O2.ORDER_NO IN (
		SELECT
			O1.ORDER_NO
		FROM
			ORDERS AS O1
				INNER JOIN WAREHOUSE AS W1
					ON W1.WH_CODE = O1.WH_CODE
		WHERE
			W1.WH_NAME = '浦和倉庫'
	)
GROUP BY
	O2.ITEM_CODE
,	ITEM.ITEM_NAME
HAVING SUM(O2.ORDER_QTY) >= 50
ORDER BY
	3 DESC
,	1 DESC