Q&A for amateur radio enthusiasts
with migrations as ( select postID , case when comment like 'to http://serverfault.com%' then 'severfault' when comment like 'to http://meta.stackoverflow.com%' then 'meta.so' when comment like 'to http://superuser.com%' then 'superuser' when comment like 'to http://dba.stackexchange.com%' then 'dba.se' when comment like 'to http://programmers.stackexchange.com%' then 'programmers.se' when comment like 'to http://meta.webapps.stackexchange.com%' then 'meta.webapps' when comment like 'to http://webmasters.stackexchange.com%' then 'webmasters.se' end target , year(creationdate) yr, month(creationDate) m from postHistory where posthistoryTypeid in (17, 35) ) Select count(postID) M_Count, target, yr FROM migrations where target is not null group by yr, target order by yr, target, count(postID)