Test - Quarry

SQL

USE ckbwiki_p;

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(initial_edit_bytes) AS TotalBytes
FROM (
  SELECT
    actor_name,
    rev_page,
    MIN(rev_id) AS first_revision_id,
    (SELECT page_len FROM page WHERE page_id = rev_page) AS initial_edit_bytes
  FROM (
    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
  JOIN actor ON actor.actor_id = (SELECT rev_actor FROM revision WHERE rev_id = first_revision_id)
) AS initial_edits
GROUP BY actor_name;
SQL

Checking query status...
