Identify the top 5 editors (by number of edits on any wiki (te, hi etc.), across a rolling 3-month period. Rolling periods are based on the first day of each month. For example, for March, the rolling period includes January, February, and March.

SQL

WITH Edits_of_Rolling_Period AS (
    SELECT
        u.user_id,
        u.user_name,
        r.rev_timestamp,
        SUM(user_editcount) AS Total_Edits
    FROM
        user u 
    JOIN 
        revision r ON u.user_id=r.rev_id
    WHERE
        r.rev_timestamp BETWEEN DATE_SUB(DATE_FORMAT(NOW(), '%Y-%m-01'), INTERVAL 2 MONTH)
                      AND LAST_DAY(DATE_SUB(DATE_FORMAT(NOW(), '%Y-%m-01'), INTERVAL 0 MONTH))
    GROUP BY
        user_id
),
Ranked edits AS (
    SELECT
        user_id,
        user_name,
        Total_Edits,
        ROW_NUMBER() OVER (PARTITION BY wiki_language ORDER BY Total_Edits DESC) AS rank
    FROM
        RollingEdits
)
SELECT
    user_id,
    user_name,
    Total_Edits
FROM
    RankedEdits
WHERE
    rank <= 5
ORDER BY
    Total_Edits DESC;

SQL

Checking query status...