SELECT OD.ITEM_CODE AS CODE
    ,I.ITEM_NAME AS NAME
    ,SUM(OD.ORDER_QTY) AS SUM_QTY
FROM WAREHOUSE AS W
INNER JOIN ORDERS AS O
ON W.WH_CODE = O.WH_CODE

INNER JOIN ORDERS_DTL AS OD
ON O.ORDER_NO = OD.ORDER_NO

LEFT JOIN ITEM AS I
ON OD.ITEM_CODE = I.ITEM_CODE
WHERE W.WH_NAME = '浦和倉庫'
GROUP BY OD.ITEM_CODE
    ,I.ITEM_NAME
HAVING SUM_QTY >= 50
ORDER BY SUM_QTY DESC
    ,OD.ITEM_CODE DESC