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