SELECT
    CODE,
    NAME,
    SUM_QTY
FROM (
    SELECT
	    DTL.ITEM_CODE AS CODE,
        IT.ITEM_NAME AS NAME,
        SUM(DTL.ORDER_QTY) AS SUM_QTY
    FROM
	    ORDERS ORD
	    LEFT JOIN WAREHOUSE WARE ON ORD.WH_CODE = WARE.WH_CODE
	    LEFT JOIN ORDERS_DTL DTL ON ORD.ORDER_NO = DTL.ORDER_NO
	    LEFT JOIN ITEM IT ON IT.ITEM_CODE = DTL.ITEM_CODE
    WHERE
        ORD.WH_CODE IS NOT NULL
        AND WARE.WH_NAME = '浦和倉庫'
    GROUP BY
        DTL.ITEM_CODE,
        IT.ITEM_NAME
)
WHERE
    SUM_QTY >= 50
ORDER BY
	SUM_QTY DESC,
	CODE DESC