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 WH.WH_CODE = OD.WH_CODE
    INNER JOIN ORDERS_DTL AS ODD
        ON OD.ORDER_NO = ODD.ORDER_NO
    --外部結合
    LEFT OUTER JOIN ITEM AS IT
       ON ODD.ITEM_CODE = IT.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;