0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jan 18

created jan 18 anonymous