select
    --*
    SOD.ITEM_CODE as CODE,
    SI.ITEM_NAME as NAME,
    --(SUM_QTY)
    SUM(ORDER_QTY) as SUM_QTY
from
    ORDERS_DTL as SOD
left join 
    ITEM as SI
on
    SOD.ITEM_CODE = SI.ITEM_CODE

join
    ORDERS as SO
on
    SOD.ORDER_NO = SO.ORDER_NO

join
    WAREHOUSE as SW
on
    SO.WH_CODE = SW.WH_CODE


where
    SW.WH_NAME is '浦和倉庫'

group by
    SOD.ITEM_CODE

having
    SUM_QTY >= 50

order by
    SUM_QTY DESC,
    SOD.ITEM_CODE DESC
;