SELECT
	B.ITEM_CODE AS CODE
,	D.ITEM_NAME AS NAME
,	SUM(B.ORDER_QTY) AS SUM_QTY
FROM
	ORDERS A
,	ORDERS_DTL B
        LEFT OUTER JOIN ITEM D
        ON B.ITEM_CODE = D.ITEM_CODE
,	WAREHOUSE C
WHERE
	A.ORDER_NO = B.ORDER_NO
AND	A.WH_CODE = C.WH_CODE
AND	C.WH_NAME = '浦和倉庫'
GROUP BY
	B.ITEM_CODE
,	D.ITEM_NAME
HAVING
	SUM(B.ORDER_QTY) > 49
ORDER BY
	SUM(B.ORDER_QTY) DESC
,	D.ITEM_CODE DESC