Test - Quarry

SQL

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(InitialEditSize) AS TotalBytes
FROM (
  SELECT
    actor_name,
    rev_page,
    SUM(InitialEditSize) AS InitialEditSize
  FROM (
    SELECT
      actor_name,
      revision.rev_page,
      SUM(page.page_len) AS InitialEditSize
    FROM (
      SELECT
        actor_name,
        rev_page,
        MIN(revision.rev_id) AS FirstRevisionID
      FROM revision
      JOIN actor ON actor.actor_id = revision.rev_actor
      JOIN page ON page.page_id = revision.rev_page
      WHERE page_namespace = 0
        AND page_is_redirect = 0
        AND rev_parent_id = 0
        AND DATE(rev_timestamp) BETWEEN '2023-01-01' AND '2023-05-01'
      GROUP BY actor_name, rev_page
    ) AS FirstRevisions
    JOIN revision ON FirstRevisions.FirstRevisionID = revision.rev_id
    GROUP BY actor_name, revision.rev_page
  ) AS InitialEdits
  GROUP BY actor_name, rev_page
) AS FinalData
GROUP BY actor_name;
SQL

Checking query status...
