rank of wikis per voter base

SQL

WITH base_data AS (
    SELECT
        wiki_db,
        event_user_id,
        MAX(event_user_revision_count) AS rev_count,
        COUNT(1) AS revs_last_6_months
    FROM wmf.mediawiki_history
    WHERE
        snapshot = '2021-02' AND
        event_entity = 'revision' AND
        event_type = 'create' AND
        event_timestamp >= '2020-09-01' AND
        NOT ARRAY_CONTAINS(event_user_is_bot_by, 'group') AND
        event_user_id IS NOT NULL
    GROUP BY
        wiki_db,
        event_user_id
    HAVING
        revs_last_6_months >= 30 AND
        rev_count >= 300
)
SELECT
    wiki_db,
    COUNT(1) AS voters
FROM base_data
GROUP BY wiki_db
ORDER BY voters DESC
LIMIT 100
;
SQL

Checking query status...
