Test - Quarry

SQL

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(first_revision_bytes) AS TotalBytes
FROM (
  SELECT
    actor_name,
    rev_id AS first_revision_id,
    page.page_len AS first_revision_bytes
  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_id
) AS first_revisions
GROUP BY actor_name;
SQL

Checking query status...
