select 
ORDERS_DTL.ITEM_CODE CODE
, ITEM.ITEM_NAME NAME
, ORDERS_DTL.ORDER_QTY 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 
INNER JOIN ITEM
	ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where WAREHOUSE.WH_NAME='浦和倉庫'
Order by ORDERS_DTL.ORDER_QTY desc , ORDERS_DTL.ITEM_CODE desc