SELECT
o.ITEM_CODE as CODE
, o2.SUM_QTY
, (SELECT ITEM_NAME FROM ITEM WHERE o.ITEM_CODE = ITEM.ITEM_CODE) as NAME
FROM ORDERS_DTL o
JOIN
(SELECT oo.ORDER_NO
,oo.WH_CODE
,oo1.WH_NAME
FROM ORDERS oo
JOIN WAREHOUSE oo1
ON oo.WH_CODE = oo1.WH_CODE
WHERE oo1.WH_NAME = "浦和倉庫") o1
ON o.ORDER_NO = o1.ORDER_NO
JOIN
(SELECT ITEM_CODE, SUM(ORDER_QTY) as SUM_QTY FROM ORDERS_DTL GROUP BY ITEM_CODE) o2
ON o.ITEM_CODE = o2.ITEM_CODE
WHERE o2.SUM_QTY >= 50
ORDER BY o2.SUM_QTY DESC, o.ITEM_CODE DESC