Redirects - Creators by volume in 2024 by month

SQL

SELECT 
	actor_name as "Creator",
	COUNT(*) AS "Year total", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 01 THEN 1 ELSE 0 END) AS "Jan", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 02 THEN 1 ELSE 0 END) AS "Feb", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 03 THEN 1 ELSE 0 END) AS "Mar", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 04 THEN 1 ELSE 0 END) AS "Apr", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 05 THEN 1 ELSE 0 END) AS "May", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 06 THEN 1 ELSE 0 END) AS "Jun", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 07 THEN 1 ELSE 0 END) AS "Jul", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 08 THEN 1 ELSE 0 END) AS "Aug",
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 09 THEN 1 ELSE 0 END) AS "Sep", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 10 THEN 1 ELSE 0 END) AS "Oct", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 11 THEN 1 ELSE 0 END) AS "Nov", 
	SUM(CASE WHEN SUBSTRING(rev_timestamp,5,2) = 12 THEN 1 ELSE 0 END) AS "Dec"
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_parent_id = 0
  AND page_namespace = 0
  AND page_is_redirect = 1
  AND SUBSTRING(rev_timestamp, 1, 4) = '2023'
GROUP BY actor_name
HAVING COUNT(*) >= 100
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
