select DATEFROMPARTS(YEAR(p.CreationDate),MONTH(p.Creatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select  
DATEFROMPARTS(YEAR(p.CreationDate),MONTH(p.CreationDate),1) as [Date], t.TagName,
count(*)
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId 
where 
DATEFROMPARTS(YEAR(p.CreationDate),MONTH(p.CreationDate),1)<
DATEFROMPARTS(YEAR(getdate()),MONTH(getdate()),1)
AND
(t.TagName like ##Tag1:string?react%##
or t.TagName like ##Tag2:string?python%##)
group by t.TagName,
         DATEFROMPARTS(YEAR(p.CreationDate),MONTH(p.CreationDate),1)
order by [Date] desc

Enter Parameters

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