Untitled query #27644

SQL

SELECT AVG(sizes.size) AS average_size,
    STD(sizes.size) AS variance,
    COUNT(CASE WHEN sizes.size < 20 THEN 1 END) AS small_edits,
    COUNT(CASE WHEN sizes.size > 1000 THEN 1 END) AS large_edits
FROM (
    SELECT (CAST(revs.rev_len AS SIGNED) - IFNULL(parentrevs.rev_len, 0)) AS size
    FROM revision_userindex AS revs
    LEFT JOIN revision_userindex AS parentrevs ON (revs.rev_parent_id = parentrevs.rev_id)
    WHERE revs.rev_user_text = 'Evolution and evolvability'
    ORDER BY revs.rev_timestamp DESC
    LIMIT 5000
) sizes
SQL

Checking query status...
