SELECT
    ODD.ITEM_CODE AS CODE
    , IT.ITEM_NAME AS NAME
    , SUM(ODD.ORDER_QTY) AS SUM_QTY 
FROM
    WAREHOUSE AS WH 
        INNER JOIN ORDERS AS OD 
        ON OD.WH_CODE = WH.WH_CODE 

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

     LEFT OUTER JOIN ITEM AS IT 
        ON IT.ITEM_CODE = ODD.ITEM_CODE 
WHERE
      WH.WH_NAME = '浦和倉庫' 
GROUP BY
    ODD.ITEM_CODE
    , IT.ITEM_NAME 
HAVING
     SUM_QTY >= 50 
ORDER BY
    SUM_QTY DESC
    , CODE DESC;