SELECT *
FROM (
SELECT ORDERS_DTL.ITEM_CODE as 'CODE', 
       CASE WHEN ITEM.ITEM_NAME IS NULL THEN  'NULL'
                                      ELSE ITEM.ITEM_NAME END as 'NAME',
       sum(ORDERS_DTL.ORDER_QTY) as 'SUM_QTY'
FROM   ORDERS
INNER JOIN ORDERS_DTL
ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
LEFT JOIN ITEM
on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
WHERE ORDERS.WH_CODE in (
SELECT WH_CODE
FROM   WAREHOUSE
WHERE  WH_NAME = '浦和倉庫'
)
GROUP BY ORDERS_DTL.ITEM_CODE,ITEM.ITEM_NAME
HAVING sum(ORDERS_DTL.ORDER_QTY) >= 50
) DATA
ORDER BY SUM_QTY DESC, CODE DESC