0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and power users of the Android operating system

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 '%flutter%' OR t.TagName like '%react-native%' OR t.TagName like '%xamarin%' or t.TagName like '%cordova%' or t.TagName like '%phonegap%')
-- post type 2 means that post is an answer
AND 
q.CreationDate > '2019-03-20 00:00:00'
AND
q.CreationDate < '2019-06-20 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)

fork query

edited jun 21 19

created jun 21 19 anonymous