Article creators by volume past five years

Most prolific article creators from September 2017

Limitations:
Redirects converted into articles don't count as article creations for the converting editor
Articles created as redirects and converted to articles by a different editor count as article creations
Disambiguation pages are counted as article creations
List articles are counted as article creations

SQL

SELECT COUNT(*) AS "# Articles", SUM(page_len) / COUNT(*) AS "Average Size", SUM(rev_len) / COUNT(*) AS "Average Creation Size", actor_name as "Creator"
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND page_namespace = 0
  AND page_is_redirect = 0
  AND rev_timestamp >= '20170901'
GROUP BY actor_name
ORDER BY COUNT(*) DESC;

AخA
 
SELECT COUNT(*) AS "# Articles", SUM(page_len) / COUNT(*) AS "Average Size", SUM(rev_len) / COUNT(*) AS "Average Creation Size", actor_name as "Creator"FROM revisionJOIN actor_revision ON actor_id = rev_actorJOIN page ON page_id = rev_pageWHERE rev_parent_id = 0  AND page_namespace = 0  AND page_is_redirect = 0  AND rev_timestamp >= '20170901'GROUP BY actor_nameORDER BY COUNT(*) DESC;

SQL

Checking query status...