Frequency of anonymous suggested edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the cumulative number of suggested edits that were submitted by anonymous users over the past NumberOfEdits suggested edits. If the anonymous suggestion rate was constant at x%, then the graph would show a straight line at slope 100x (e.g. if all edit suggestions were anonymous, a straight line with slope 1).

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 500
  ROW_NUMBER() OVER (ORDER BY Id DESC),
  CASE WHEN OwnerUserId IS NULL THEN 1 ELSE 0 END,
  SUM(CASE WHEN OwnerUserId IS NULL THEN 1 ELSE 0 END) 
  OVER(ORDER BY Id DESC 
     ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) 
          AS RunningTotal
FROM SuggestedEdits SE1
ORDER BY Id DESC


--INNER JOIN SuggestedEdits SE1 on 
--ORDER BY Id DESC

--select t1.id, t1.SomeNumt, SUM(t2.SomeNumt) as sum
--from @t t1
--inner join @t t2 on t1.id >= t2.id
--group by t1.id, t1.SomeNumt
--order by t1.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results