SELECT O.ITEM_CODE AS CODE,I.ITEM_NAME AS NAME,O.SUM_QTY
FROM
(
	SELECT O.WH_CODE,O.ITEM_CODE,SUM(O.ORDER_QTY) AS SUM_QTY
	FROM
	(
		SELECT O.WH_CODE AS WH_CODE,OD.ITEM_CODE,OD.ORDER_QTY
		FROM ORDERS AS O
		INNER JOIN ORDERS_DTL AS OD ON OD.ORDER_NO=O.ORDER_NO
	) AS O
	GROUP BY O.WH_CODE,O.ITEM_CODE
) AS O
LEFT OUTER JOIN ITEM AS I ON I.ITEM_CODE=O.ITEM_CODE
INNER JOIN WAREHOUSE AS WH ON WH.WH_CODE=O.WH_CODE
WHERE WH.WH_NAME='浦和倉庫'
AND O.SUM_QTY >= 50
ORDER BY SUM_QTY DESC,CODE DESC