0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

select t1.month, perlposts, juliaPosts from (
Select 
    month(Posts.CreationDate) month, 
    Count(*) As perlPosts
From 
    Posts 
Where
    PostTypeId = 1 And 
    (Tags Like '%<perl>%' 
    Or Tags like '%<perl>%>' )And 
    Posts.CreationDate >= '2021-01-01'
Group By
   month(Posts.CreationDate)
) t1 inner join (
Select 
  month(Posts.CreationDate) as month, 
    Count(*) As juliaPosts
From 
    Posts 
Where 
    PostTypeId = 1 And 
    (Tags Like '%<julia>%' or Tags like '%<julialang>%'
    Or Tags like '%<julia>%') And
    Posts.CreationDate >= '2021-01-01'
Group By
    month(Posts.CreationDate)
) t2 on t1.month=t2.month
order by t1.month

fork query

edited aug 8

created mar 15 21 anonymous