0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

SELECT Tags,
DatePart(quarter, p.LastActivityDate) AS q, Year(p.LastActivityDate) AS y, 
COUNT(p.Id) As NumPosts
FROM Posts p
where Tags is not null
GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), Tags
having COUNT(p.Id)>25
ORDER BY y, q, NumPosts DESC

fork query

edited sep 30 20

created sep 30 20 anonymous