SELECT 
    [OD].[ITEM_CODE] AS [CODE],
    [I].[ITEM_NAME] AS [NAME],
    SUM([OD].[ORDER_QTY]) AS [SUM_QTY]
FROM 
    [ORDERS] AS [O]
    LEFT OUTER JOIN [ORDERS_DTL] AS [OD] ON [O].[ORDER_NO] = [OD].[ORDER_NO]
    LEFT OUTER JOIN [WAREHOUSE] AS [W] ON [O].[WH_CODE] = [W].[WH_CODE]
    LEFT OUTER JOIN [ITEM] AS [I] ON [OD].[ITEM_CODE] = [I].[ITEM_CODE]
WHERE 
    [O].[WH_CODE] IN (
        SELECT [WH_CODE]
        FROM [WAREHOUSE]
        WHERE [WH_NAME] = '浦和倉庫'
    )
GROUP BY 
    [OD].[ITEM_CODE],
    [I].[ITEM_NAME]
HAVING 
    SUM([OD].[ORDER_QTY]) >= 50
ORDER BY 
    [SUM_QTY] DESC,
    [CODE] DESC;