WITH ok_ware AS(
    SELECT
        ORDER_NO
    FROM ORDERS
    LEFT OUTER JOIN WAREHOUSE
    USING(WH_CODE)
    WHERE WH_NAME = '浦和倉庫'
)
SELECT
    od.ITEM_CODE AS CODE,
    ITEM_NAME AS NAME,
    SUM(ORDER_QTY) AS SUM_QTY
FROM ORDERS_DTL AS od
INNER JOIN ok_ware
USING(ORDER_NO)
LEFT OUTER JOIN ITEM
USING(ITEM_CODE)
GROUP BY ITEM_CODE
HAVING SUM(ORDER_QTY) >= 50
ORDER BY SUM_QTY DESC, CODE DESC