Number of articles by editor by year since 2020

SQL

SELECT actor_name as "Creator",
    COUNT(*) as "Articles",
    SUBSTRING(rev_timestamp, 1, 4) AS Year
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 >= '2020'
  AND (rev_len >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.
       OR rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smaller
GROUP BY Creator, Year

AخA
 
SELECT actor_name as "Creator",    COUNT(*) as "Articles",    SUBSTRING(rev_timestamp, 1, 4) AS YearFROM 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 >= '2020'  AND (rev_len >= 150 #94% of redirects are smaller than this; 95% of articles are created longer.       OR rev_len < 16) #very few redirects are smaller than 16 bytes, but a not-insignificant amount of articles start out smallerGROUP BY Creator, Year

SQL

Checking query status...