Number of close voters per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

---the cte is taken from here:
---https://data.stackexchange.com/mathoverflow/query/825824/close-voters-on-question
;with closevoters_cte AS (
select postid as pid
     , CreationDate as CDate
     , crt.name
     , cv.userid as uid
from posthistory ph
inner join closereasontypes crt on crt.id = comment
cross apply OPENJSON(JSON_QUERY(ph.text, '$.Voters'))
       with (userid int '$.Id') cv
where posthistorytypeid = 10
)

SELECT 
  eomonth(CDate),
  COUNT(DISTINCT uid) AS [Count]
FROM closevoters_cte
GROUP BY eomonth(CDate)
ORDER BY eomonth(CDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results