Untitled query #89021

This query is marked as a draft This query has been published by Hassan ARBAB.

SQL

WITH
base as(
SELECT
rev_id,
rev_actor,
rev_timestamp,
page_title,
actor_name
FROM
revison rev
JOIN
page pg
ON rev.rev_pag=pg.page_id
JOIN
actor act
On rev.rev_actor = act.actor_id
WHERE
year(rev_timestamp) = 2024
),
edits_by_user AS (
SELECT
actor_name,
COUNT(DISTINCT rev_id) AS edit_count
FROM
base
GROUP BY
actor_name
)
SELECT
*
FROM
edits_by_user
ORDER BY 
edit_count DESC
LIMIT 20

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...