Q&A for people who like playing board games, designing board games or modifying the rules of existing board games
with migrations as (
select postID ,
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'
, year(creationdate) yr, month(creationDate) m
where posthistoryTypeid in (17, 35)
where target is not null
order by yr, target, count(postID)