Monthly Power Editor Share

A collaborative knowledge base records every edit made to its articles. The community team wants to monitor how much of each month's active editor population consists of unusually frequent contributors.

Table: article_edits

+--------------------+---------+
| Column Name        | Type    |
+--------------------+---------+
| edit_id            | integer |
| editor_id          | integer |
| article_id         | integer |
| edited_on          | date    |
| characters_changed | integer |
+--------------------+---------+
+--------------------+---------+
| Column Name        | Type    |
+--------------------+---------+
| edit_id            | integer |
| editor_id          | integer |
| article_id         | integer |
| edited_on          | date    |
| characters_changed | integer |
+--------------------+---------+

edit_id is the primary key. Each row represents one completed article edit.

For each calendar month, count the edits made by every editor. An active editor is any editor with at least one edit in that month. A power editor is an editor with more than 30 edits in the same month. An editor with exactly 30 edits is active but is not a power editor.

For every month present in the table, return:

• month in YYYY-MM format
• active_editors, the number of distinct editors with at least one edit
• power_editors, the number of those editors with more than 30 edits
• pct_power_editors, calculated as power_editors / active_editors * 100 and rounded to 2 decimal places

Order the results by month ascending.

Example

Input:

The table below is abbreviated; each range represents individual edit rows.

article_edits table:
+---------+-----------+------------+------------+--------------------+
| edit_id | editor_id | article_id | edited_on  | characters_changed |
+---------+-----------+------------+------------+--------------------+
| 1-35    | 1         | 101        | 2026-01-05 | 20                 |
| 36-55   | 2         | 102        | 2026-01-10 | 20                 |
| 56-65   | 3         | 103        | 2026-01-20 | 20                 |
| 66-105  | 4         | 104        | 2026-02-05 | 20                 |
| 106-110 | 5         | 105        | 2026-02-15 | 20                 |
+---------+-----------+------------+------------+--------------------+
article_edits table:
+---------+-----------+------------+------------+--------------------+
| edit_id | editor_id | article_id | edited_on  | characters_changed |
+---------+-----------+------------+------------+--------------------+
| 1-35    | 1         | 101        | 2026-01-05 | 20                 |
| 36-55   | 2         | 102        | 2026-01-10 | 20                 |
| 56-65   | 3         | 103        | 2026-01-20 | 20                 |
| 66-105  | 4         | 104        | 2026-02-05 | 20                 |
| 106-110 | 5         | 105        | 2026-02-15 | 20                 |
+---------+-----------+------------+------------+--------------------+

Output:

+---------+----------------+---------------+-------------------+
| month   | active_editors | power_editors | pct_power_editors |
+---------+----------------+---------------+-------------------+
| 2026-01 | 3              | 1             | 33.33             |
| 2026-02 | 2              | 1             | 50.00             |
+---------+----------------+---------------+-------------------+
+---------+----------------+---------------+-------------------+
| month   | active_editors | power_editors | pct_power_editors |
+---------+----------------+---------------+-------------------+
| 2026-01 | 3              | 1             | 33.33             |
| 2026-02 | 2              | 1             | 50.00             |
+---------+----------------+---------------+-------------------+

Explanation:

January has three active editors. Only editor 1 exceeds 30 edits, so the percentage is 1 / 3 * 100 = 33.33. February has two active editors, and editor 4 is the only power editor, producing 50.00.