Average size of an edit by edit count bucket - Quarry

This query is marked as a draft This query has been published by Sk.ziyaur rahaman.

This query finds the average amount of content changed in edits (in bytes) . It compares each revision to its previous version, calculates how much the size changed (ignoring whether it was added or removed), and averages that value. You can change the range in the WHERE clause to target different groups of users

SQL

SELECT
  AVG(ABS(CAST(r.rev_len AS SIGNED) - CAST(p.rev_len AS SIGNED))) AS avg_edit_size
FROM (revision r
JOIN revision p ON r.rev_parent_id = p.rev_id
JOIN (
  SELECT rev_actor, COUNT(*) AS edit_count
  FROM revision
  GROUP BY rev_actor
) AS user_edits ON r.rev_actor = user_edits.rev_actor)
where user_edits.edit_count between 11 and 50    # we can change range of edits 

;

​x
 
SELECT  AVG(ABS(CAST(r.rev_len AS SIGNED) - CAST(p.rev_len AS SIGNED))) AS avg_edit_sizeFROM (revision rJOIN revision p ON r.rev_parent_id = p.rev_idJOIN (  SELECT rev_actor, COUNT(*) AS edit_count  FROM revision  GROUP BY rev_actor) AS user_edits ON r.rev_actor = user_edits.rev_actor)where user_edits.edit_count between 11 and 50    # we can change range of edits ​;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...