Count of Questions in Period with Tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

select 
--dateadd(month, datediff(month, 0, q.CreationDate), 0) m, 
t.TagName, count(DISTINCT q.Id) AS Question
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where PostTypeId=1 AND t.TagName like '%daml%'
-- post type 2 means that post is an answer
AND 
q.CreationDate > '2019-03-31 00:00:00'
-- end date commented out
-- AND
-- q.CreationDate < '2019-07-25 00:00:00'
--dateadd(month, datediff(month, 0, getdate()), 0) 
group by t.TagName
--,dateadd(month, datediff(month, 0, q.CreationDate), 0)
order by Question DESC
--, dateadd(month, datediff(month, 0, q.CreationDate), 0)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results