Untitled query #77921

SQL

SELECT rev_actor, YEAR(rev_timestamp) AS Year,
	COUNT(DISTINCT rev_id) AS editcount_by_revid,
 	SUM(CASE WHEN editcount_by_revid <= 100 THEN 1 ELSE 0 END) AS editcount_by_revid_100,
 	SUM(CASE WHEN editcount_by_revid BETWEEN 101 AND 300 THEN 1 ELSE 0 END) AS editcount_by_revid_300,
 	SUM(CASE WHEN editcount_by_revid BETWEEN 301 AND 500 THEN 1 ELSE 0 END) AS editcount_by_revid_500,
 	SUM(CASE WHEN editcount_by_revid >=501 THEN 1 ELSE 0 END) AS editcount_by_revid_501
FROM revision
GROUP BY rev_actor, Year
SQL

Checking query status...
