Number of questions posted each month about Vi across Stack Exchange. All questions from Vi Stack Exchange are included, as well as questions tagged [vi], [macvim] or [vim] on other sites.
Q&A for professional and enthusiast programmers
select convert(datetime, so.month + '-01 13:37:00', 120) as [month], vi.count as [Vi], so.count as [SO], su.count as [SU], unix.count as [Unix&Linux], ubuntu.count as [Ubuntu], apple.count as [Apple], tex.count as [TeX] from ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackOverflow].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as so full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [SuperUser].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as su on su.month = so.month full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackExchange.Unix].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as unix on unix.month = so.month full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackExchange.Ubuntu].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as ubuntu on ubuntu.month = so.month full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackExchange.Apple].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as apple on apple.month = so.month full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackExchange.TeX].dbo.Posts p where p.PostTypeId = 1 and p.Tags like '%<vi>%' or p.Tags like '%<vim>%' or p.Tags like '%<macvim>%' group by convert(char(7), CreationDate, 20) ) as tex on tex.month = so.month full outer join ( select convert(char(7), CreationDate, 20) as [month], count(*) as [count] from [StackExchange.Vi].dbo.Posts p where p.PostTypeId = 1 group by convert(char(7), CreationDate, 20) ) as vi on vi.month = so.month order by so.month asc