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