SQL
AخA
SELECT actor_name,
COUNT(*) AS '#/edits',
CAST(MIN(ar_timestamp) AS DATETIME) AS 'first edit',
CAST(MAX(ar_timestamp) AS DATETIME) AS 'last edit'
FROM archive
LEFT JOIN actor_archive ON actor_id = ar_actor
WHERE ar_namespace = 0 AND ar_title = 'List_of_anthropogenic_disasters_by_death_toll'
GROUP BY actor_name
ORDER BY MIN(ar_timestamp) ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.