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 ##NumberOfEdits?5000##
  ROW_NUMBER() OVER (ORDER BY Id DESC) AS 'Edit number',
  SUM(
    CASE WHEN OwnerUserId IS NULL THEN 1 ELSE 0 END
  )OVER(
    ORDER BY Id DESC 
    ROWS BETWEEN UNBOUNDED PRECEDING 
             AND CURRENT ROW
  ) AS 'Edits by anonymous users'
FROM SuggestedEdits SE1
ORDER BY Id DESC

Enter Parameters

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