问对分区求和以计算运行总数

EN

SELECT  DATEPART(MONTH, r.received_date) AS [MonthID] ,
    DATENAME(MONTH, r.received_date) AS [Month] ,
    o.name AS [CountyName] ,
    rsc.description AS [Filing] ,
    COUNT(r.id) AS [Request_Total] ,
    CAST (AVG(CAST (DATEDIFF(HOUR, received_date, completion_date) AS DECIMAL(8,2))) / 24 AS DECIMAL(8,2)) AS [Total_Time_Days] 
    --SUM(r.id) OVER (PARTITION BY o.name) AS [TotalFilings]
FROM    dbo.requests AS [r]
    INNER JOIN dbo.organizations AS [o] ON o.id = r.submitted_to_organiztion_id
    INNER JOIN dbo.request_status_codes AS [rsc] ON rsc.code = r.request_status_code
WHERE   r.submitted_to_organiztion_id < 68
    AND r.request_type_code = 1
    AND CAST(r.received_date AS DATE) >= '01/01/2016'
    AND CAST(r.received_date AS DATE) <= '06/30/2016'
    AND o.name = 'Alachua'
GROUP BY DATENAME(MONTH, r.received_date) ,
    DATEPART(MONTH, r.received_date) ,
    o.name ,
    rsc.description
ORDER BY DATEPART(MONTH, r.received_date) ,
    CountyName ,
    Filing;