SELECT
b.ITEM_CODE as CODE
, (SELECT ITEM_NAME FROM ITEM WHERE b.ITEM_CODE = ITEM.ITEM_CODE) as NAME
, SUM(ORDER_QTY) as SUM_QTY
FROM ORDERS_DTL b
JOIN
(SELECT
a.ORDER_NO
, a.WH_CODE
, a1.WH_NAME
FROM ORDERS a
JOIN 
(SELECT WH_CODE, WH_NAME FROM WAREHOUSE) a1
ON a.WH_CODE = a1.WH_CODE
WHERE a1.WH_NAME = '浦和倉庫') b1
ON b.ORDER_NO = b1.ORDER_NO
GROUP BY b.ITEM_CODE
HAVING SUM(ORDER_QTY) >= 50
ORDER BY SUM_QTY DESC, CODE DESC