SQL
AخA
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS hour, COUNT(*) AS 'edits per hour', COUNT(*) / 60 AS 'edits per minute'
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor AND actor_name = 'Cewbot'
WHERE rev_timestamp BETWEEN '202312' AND '2024021623' -- omit partial data from the final hour
GROUP BY LEFT(rev_timestamp, 10) DESC;
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.