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