বছর অনুসারে বাংলা উইকিপিডিয়ায় নিবন্ধ তৈরি

SQL

SELECT
  year,
  COUNT(DISTINCT rev_actor)
FROM
  (
    SELECT
      YEAR(rev_timestamp) AS year,
      rev_actor
    FROM
      revision_userindex AS revision
      INNER JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
      INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
      INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
    WHERE
      TRUE
      AND change_tag_def.ctd_name = 'mobile edit'
      AND actor_user IS NOT NULL
      AND rev_timestamp >= '20200101000000'
  ) AS q
GROUP BY
  year
ORDER BY
  year DESC

SQL

Checking query status...