0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those involved in the field of teaching Computer Science

select t.TagName, count(distinct p.id) as popularity
from Posts p, Tags t
where p.Tags like '%<'+t.TagName+'>%'
and p.Score > 100
and p.PostTypeId=1
and t.Count > 100000
and p.CreationDate >'2018-01-01 00:00:00'
group by t.TagName
order by popularity desc

fork query

edited jan 20 20

created jan 20 20 anonymous