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

SQL

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'
  WHERE p.page_namespace == 0
  GROUP BY revision_date
) AS subquery
GROUP BY revision_date;

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'
  WHERE p.page_namespace == 0
  GROUP BY DATE(rev.rev_timestamp)
) AS subquery;

SQL

Checking query status...