tags per year perl / raku

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select t1.year, perlposts, rakuposts from (
Select 
    Year(Posts.CreationDate) as year, 
    Count(*) As perlPosts
From 
    Posts 
Where 
    PostTypeId = 1 And 
    (Tags Like '%<perl>%' 
    Or Tags like '%<perl>%>' )And 
    Posts.CreationDate >= '2014-01-01'
Group By
    Year(Posts.CreationDate)
) t1 inner join (
Select 
    Year(Posts.CreationDate) as year, 
    Count(*) As rakuPosts
From 
    Posts 
Where 
    PostTypeId = 1 And 
    (Tags Like '%<raku>%' or Tags like '%<rakudo%'
    Or Tags like '%<perl6>%>' )And 
    Posts.CreationDate >= '2014-01-01'
Group By
    Year(Posts.CreationDate)
) t2 on t1.year=t2.year
order by t1.year

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results