SELECT
    od.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    COUNT(o.ORDER_NO) as SUM_QTY
FROM
    ORDERS_DTL as od
     INNER JOIN ORDERS as o
      on o.ORDER_NO = od.ORDER_NO
     CROSS JOIN WAREHOUSE as w
     CROSS JOIN ITEM as i
WHERE
    w.WH_NAME = '浦和倉庫'
ORDER BY
    SUM_QTY desc,
    CODE asc