select ITEM_CODE as CODE, ITEM_NAME as NAME, sum(ORDER_QTY) as SUM_QTY
from ORDERS
left outer join ORDERS_DTL using (ORDER_NO)
left outer join WAREHOUSE using (WH_CODE)
left outer join ITEM using (ITEM_CODE)
where WH_NAME = "浦和倉庫"
group by ITEM_CODE
having sum(ORDER_QTY) >= 50
order by SUM_QTY desc, ITEM_CODE desc