SELECT
    T10.CODE,
    T10.NAME,
    T10.SUM_QTY
FROM
(
SELECT
    T2.ITEM_CODE AS CODE,
    T4.ITEM_NAME AS NAME,
    SUM(T2.ORDER_QTY) AS SUM_QTY
FROM
    ORDERS T1
INNER JOIN
    ORDERS_DTL T2
ON
    T2.ORDER_NO = T1.ORDER_NO
INNER JOIN
    WAREHOUSE T3
ON
    T3.WH_CODE = T1.WH_CODE
AND T3.WH_NAME = '浦和倉庫'
LEFT OUTER JOIN
    ITEM T4
ON
    T4.ITEM_CODE = T2.ITEM_CODE
GROUP BY
    T2.ORDER_QTY
ORDER BY
    SUM(T2.ORDER_QTY) DESC,
    T4.ITEM_CODE DESC
) T10
WHERE
    T10.SUM_QTY >= 50