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