SELECT
o.ITEM_CODE as CODE
, (SELECT ITEM_NAME FROM ITEM WHERE o.ITEM_CODE = ITEM.ITEM_CODE) as NAME
, o2.SUM_QTY
FROM ORDERS_DTL o
JOIN
(SELECT
ORDER_NO
, (SELECT WH_NAME FROM WAREHOUSE WHERE ORDERS.WH_CODE = WAREHOUSE.WH_CODE and WH_NAME = '浦和倉庫') as WH_NAME
FROM ORDERS) 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