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 RollingEdits AS (
    SELECT
        user_id,
        user_name,
        SUM(user_editcount) AS Total_Edits
    FROM
        user
    WHERE
        edit_date 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
),
RankedEdits 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...