Total number of article revisions per day, annual average, and annual average of distincts articles edited per day

SQL

-- Total number of article revisions per day
/*SELECT
  revision_date,
  revision_count
FROM (
  SELECT
    DATE(rev.rev_timestamp) AS revision_date,
    COUNT(*) AS revision_count
  FROM revision AS rev
  INNER JOIN page AS p ON rev.rev_page = p.page_id
  WHERE rev.rev_timestamp BETWEEN ('20220101000000' AND '20221231235959')
  AND p.page_namespace = 0
  GROUP BY revision_date
) AS subquery
GROUP BY revision_date;*/

-- Annual average
/*SELECT AVG(revision_count) AS overall_average_revisions
FROM (
  SELECT
    COUNT(*) AS revision_count
  FROM revision AS rev
  INNER JOIN page AS p ON rev.rev_page = p.page_id
  WHERE rev.rev_timestamp BETWEEN ('20220101000000' AND '20221231235959')
  AND p.page_namespace = 0
  GROUP BY DATE(rev.rev_timestamp)
) AS subquery;*/

-- Overall average revision count with distinct page_id
SELECT AVG(distinct_articles_count) AS overall_average_distinct_articles_count
FROM (
  SELECT
    COUNT(DISTINCT rev.rev_page) AS distinct_articles_count
  FROM revision AS rev
  INNER JOIN page AS p ON rev.rev_page = p.page_id
  WHERE rev.rev_timestamp BETWEEN ('20220101000000' AND '20221231235959')
  AND p.page_namespace = 0
  GROUP BY DATE(rev.rev_timestamp)
) AS subquery;

SQL

Checking query status...