SELECT
	DTLS.ITEM_CODE AS CODE
	,ITEM.ITEM_NAME AS NAME
	,DTLS.SUM_QTY AS SUM_QTY

FROM
	ORDERS
	
LEFT OUTER JOIN WAREHOUSE
ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE

INNER JOIN
(
	SELECT
		ORDER_NO
		,ITEM_CODE
		,SUM(ORDER_QTY) AS SUM_QTY
	FROM
		ORDERS_DTL
	GROUP BY
		ORDER_NO,ITEM_CODE
	HAVING
		SUM(ORDER_QTY) >= 50
) AS DTLS
ON DTLS.ORDER_NO = ORDERS.ORDER_NO

LEFT OUTER JOIN ITEM
ON ITEM.ITEM_CODE = DTLS.ITEM_CODE

	
WHERE
	WAREHOUSE.WH_NAME = '浦和倉庫'