SELECT
     SUB.ITEM_CODE  AS CODE
    ,ITEM.ITEM_NAME AS NAME
    ,SUB.SUM_QTY    AS SUM_QTY
FROM (
    SELECT
         ODRDTL.ITEM_CODE      AS ITEM_CODE
        ,SUM(ODRDTL.ORDER_QTY) AS SUM_QTY
    FROM ORDERS AS ODR
    INNER JOIN ORDERS_DTL AS ODRDTL
        ON  ODRDTL.ORDER_NO  = ODR.ORDER_NO
    INNER JOIN WAREHOUSE AS WH
        ON  WH.WH_CODE  = ODR.WH_CODE
        AND WH.WH_NAME  = '浦和倉庫'
    GROUP BY
         ODRDTL.ITEM_CODE
) SUB
LEFT JOIN ITEM
    ON  ITEM.ITEM_CODE  = SUB.ITEM_CODE
WHERE   SUB.SUM_QTY    >= 50
ORDER BY
     SUB.SUM_QTY DESC
    ,SUB.ITEM_CODE DESC
;