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