SELECT
ORDERS_DTL.ITEM_CODE AS CODE
,ITEM.ITEM_NAME AS NAME
,SUM(ORDERS_DTL.ORDER_QTY) AS SUM_QTY
FROM
ORDERS
INNER JOIN ORDERS_DTL
 ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO

LEFT OUTER JOIN ITEM
 ON  ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE

INNER JOIN WAREHOUSE
 ON WAREHOUSE.WH_CODE = ORDERS.WH_CODE
AND WAREHOUSE.WH_NAME = '浦和倉庫'

GROUP BY
ORDERS_DTL.ITEM_CODE
HAVING
SUM_QTY >= 50
ORDER BY
SUM_QTY,ORDERS_DTL.ITEM_CODE DESC