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 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;