Test - Quarry

SQL

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(first_revisions.original_bytes) AS TotalBytes,
  SUM(first_revisions.original_words) AS TotalWords
FROM (
  SELECT
    revision.rev_page,
    MIN(revision.rev_id) AS first_revision_id,
    SUM(page.page_len) AS original_bytes,
    SUM(LENGTH(page.page_title)) AS original_words
  FROM revision
  JOIN page ON page.page_id = revision.rev_page
  WHERE revision.rev_parent_id = 0
    AND DATE(revision.rev_timestamp) BETWEEN '2023-01-01' AND '2023-05-01'
    AND page_namespace = 0
    AND page_is_redirect = 0
  GROUP BY revision.rev_page
) AS first_revisions
JOIN actor ON actor.actor_id = (SELECT rev_actor FROM revision WHERE rev_id = first_revisions.first_revision_id)
GROUP BY actor_name;
SQL

Checking query status...
