Test - Quarry

SQL

USE ckbwiki_p;
WITH FirstRevisions AS (
  SELECT
    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
)

SELECT
  actor_name AS Username,
  SUM(page.page_len) AS TotalBytes,
  SUM(CASE WHEN revision.rev_id = FirstRevisions.first_revision_id THEN page.page_len ELSE 0 END) AS OriginalSize
FROM revision
JOIN FirstRevisions
ON revision.rev_id = FirstRevisions.first_revision_id
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
GROUP BY actor_name;
SQL

Checking query status...
