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