Test - Quarry

SQL

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

Checking query status...
