SELECT QTY_LIST.ITEM_CODE AS CODE,
       IT.ITEM_NAME AS NAME,
       QTY_LIST.SUM_QTY AS SUM_QTY
 FROM (SELECT ITEM_CODE,SUM(ORDER_QTY) AS SUM_QTY
         FROM ORDERS ORD INNER JOIN ORDERS_DTL ORDD
                            ON ORD.ORDER_NO = ORDD.ORDER_NO
        WHERE ORD.WH_CODE IN (SELECT WH_CODE
                                FROM WAREHOUSE
                               WHERE WH_NAME = '浦和倉庫'
                             )  
        GROUP BY ITEM_CODE
        HAVING SUM(ORDER_QTY) >= 50
       ) QTY_LIST LEFT JOIN ITEM IT
                    ON QTY_LIST.ITEM_CODE = IT.ITEM_CODE
 ORDER BY SUM_QTY DESC,CODE DESC