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