Untitled query #70990

SQL

WITH editor AS (SELECT actor_id, actor_name, rev_timestamp, row_number() over(PARTITION BY actor_id order by rev_timestamp asc) as row_number 
				FROM revision
				JOIN actor on rev_actor = actor_id
                WHERE rev_page = 72806243)
                
SELECT actor_name, editor.rev_timestamp, COUNT(*) AS editcount
FROM editor
JOIN revision on rev_actor = actor_id
WHERE row_number = 1
GROUP BY actor_name
ORDER BY editcount

AخA
 
WITH editor AS (SELECT actor_id, actor_name, rev_timestamp, row_number() over(PARTITION BY actor_id order by rev_timestamp asc) as row_number                 FROM revision                JOIN actor on rev_actor = actor_id                WHERE rev_page = 72806243)                SELECT actor_name, editor.rev_timestamp, COUNT(*) AS editcountFROM editorJOIN revision on rev_actor = actor_idWHERE row_number = 1GROUP BY actor_nameORDER BY editcount

SQL

Checking query status...