select 
ORDERS_DTL.ITEM_CODE CODE
, ITEM.ITEM_NAME NAME
, SUM(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 
LEFT JOIN ITEM
	ON ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where WAREHOUSE.WH_NAME='浦和倉庫'
GROUP BY
ORDERS_DTL.ITEM_CODE
, ITEM.ITEM_NAME
having SUM(ORDERS_DTL.ORDER_QTY) >= 50
Order by ORDERS_DTL.ORDER_QTY desc , ORDERS_DTL.ITEM_CODE desc