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