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