WITH t1 AS(
            SELECT
	            OD.ITEM_CODE AS CODE
	            , CASE 
	                WHEN I.ITEM_NAME = null THEN 'NULL'
	               ELSE I.ITEM_NAME 
	             END AS NAME
	            , COUNT(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 
	        )
SELECT 
    * 
FROM 
    t1 
WHERE 
    49 < SUM_QTY 
ORDER BY
	SUM_QTY DESC
	, CODE DESC
;