select
    C.ITEM_CODE as CODE,
    D.ITEM_NAME as NAME,
    sum(C.ORDER_QTY) as SUM_QTY
from
    ORDERS as A
    INNER JOIN WAREHOUSE as B
    ON A.WH_CODE = B.WH_CODE AND B.WH_NAME = '浦和倉庫'
    INNER JOIN ORDERS_DTL as C
    ON A.ORDER_NO = C.ORDER_NO
    LEFT OUTER JOIN ITEM as D
    ON C.ITEM_CODE = D.ITEM_CODE
GROUP BY
    D.ITEM_CODE
HAVING
    SUM_QTY >= 50
ORDER BY
    SUM_QTY DESC,
    C.ITEM_CODE DESC