SELECT ITEM.ITEM_CODE AS CODE, ITEM.ITEM_NAME AS NAME, TARGET.SUM_QTY
FROM ITEM
JOIN (
    SELECT OD.ITEM_CODE, SUM(OD.ORDER_QTY) AS SUM_QTY
    FROM ORDERS AS O
    JOIN ORDERS_DTL AS OD ON O.ORDER_NO = OD.ORDER_NO
    WHERE O.WH_CODE = (
        SELECT WH_CODE
        FROM WAREHOUSE
        WHERE
            WH_NAME = '浦和倉庫'
    )
    GROUP BY OD.ITEM_CODE
    HAVING SUM_QTY >= 50
) AS TARGET ON ITEM.ITEM_CODE = TARGET.ITEM_CODE
ORDER BY SUM_QTY DESC, CODE DESC