SELECT
    OD.ITEM_CODE AS CODE
  , CASE
        WHEN I.ITEM_NAME IS NULL THEN "NULL"
        ELSE I.ITEM_NAME
    END AS NAME
  , SUM(ORDER_QTY) AS SUM_QTY
FROM
    ORDERS_DTL OD
    LEFT JOIN ORDERS O ON O.ORDER_NO = OD.ORDER_NO
    LEFT JOIN WAREHOUSE W ON O.WH_CODE = W.WH_CODE
    LEFT JOIN ITEM I ON I.ITEM_CODE = OD.ITEM_CODE
WHERE
    W.WH_NAME = "浦和倉庫"
GROUP BY
    I.ITEM_CODE
  , I.ITEM_NAME
HAVING
    SUM(ORDER_QTY) >= 50
ORDER BY
    SUM(ORDER_QTY) DESC
  , I.ITEM_CODE DESC;