select
    D.item_code CODE,
    ifnull(I.item_name, null) NAME,
    sum(D.order_qty) SUM_QTY
from
    orders O
    left join warehouse W on O.wh_code = W.wh_code
    left join orders_dtl D on O.order_no = D.order_no
    left join item I on D.item_code = I.item_code
where
    W.wh_name = '浦和倉庫'
group by
    D.order_no
    ,D.item_code
having
    sum(D.order_qty) >= 50
order by
    SUM_QTY desc,
    CODE desc