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