select dtl.item_code CODE
     ,ITEM_NAME NAME
     , sum(dtl.ORDER_QTY) SUM_QTY
from ORDERS_DTL dtl
     inner join ORDERS O
                on dtl.ORDER_NO = O.ORDER_NO
     inner join WAREHOUSE W
                on O.WH_CODE = W.WH_CODE

     left join ITEM I on I.ITEM_CODE = dtl.ITEM_CODE
where WH_NAME = '浦和倉庫'
group by I.item_code
having sum(dtl.ORDER_QTY) >= 50
order by 3 desc, 1 desc
;