WITH t1 AS(
            SELECT
	            OD.ITEM_CODE AS CODE
	            , CASE 
	                WHEN I.ITEM_NAME is 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 
            ORDER BY
	            SUM_QTY DESC
	            , OD.ITEM_CODE DESC
	        )
SELECT * FROM t1 WHERE 49 < SUM_QTY