Untitled query #80520

SQL

SELECT LEFT(rev_date,6) AS Month, SUM(CASE WHEN rev_namespace = 0 THEN 1 ELSE 0 END) AS Mainspace, SUM(CASE WHEN rev_namespace = 1 THEN 1 ELSE 0 END) AS Talk, SUM(CASE WHEN rev_namespace = 2 THEN 1 ELSE 0 END) AS "User", SUM(CASE WHEN rev_namespace = 3 THEN 1 ELSE 0 END) AS "User talk", SUM(CASE WHEN rev_namespace = 4 THEN 1 ELSE 0 END) AS Wikipedia, SUM(CASE WHEN rev_namespace = 5 THEN 1 ELSE 0 END) AS "Wikipedia Talk" 
FROM revision
WHERE rev_actor = (SELECT actor_id FROM actor WHERE actor_name = "BilledMammal")
GROUP BY Month
ORDER BY Month DESC
SQL

Checking query status...
