select top 100 tagname, count(distinct p.id) tagcount fro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Korean Language

Q&A for linguists, teachers and students of the Korean language

--RANK() OVER(PARTITION BY ORDER BY tagcount DESC)
select top 100 tagname, count(distinct p.id) tagcount
from tags t 
join posts p on t.tagname = p.tags
where year(creationdate) = 2017
group by tagname

Enter Parameters

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