SELECT OD.ITEM_CODE AS CODE,
(SELECT I.ITEM_NAME FROM ITEM I
WHERE I.ITEM_CODE = OD.ITEM_CODE)
 AS NAME,
(SELECT SUM(ORDER_QTY) FROM ORDERS_DTL
GROUP BY ITEM_CODE) AS SUM_QTY
FROM ORDERS_DTL AS OD, ORDERS AS O
WHERE O.ORDER_NO IN
(SELECT * FROM ORDERS
WHERE WH_CODE IN(
SELECT WH_CODE, WH_NAME FROM WAREHOUSE
WHERE WH_NAME IN('浦和倉庫')))
HAVING (SELECT SUM(ORDER_QTY) FROM ORDERS_DTL
GROUP BY ITEM_CODE) > 50
ORDER BY SUM_QTY DESC, OD.ITEM_CODE;