Top Users by Country


Please login or register to vote for this query.

(click on this box to dismiss)

Created by samliew (

Stack Overflow

Q&A for professional and enthusiast programmers

-- Top Users by Country
-- Created by samliew (

  TagName as [Tag],
  count as [Frequency]
  from Tags
  Order by Frequency DESC
 count (Id)  
 From Posts 
 where PostTypeId=1
 and CreationDate >= '02/09/2018 12:00:00 AM'
 and CreationDate <= '02/16/2018 12:00:00 AM'
 year(CreationDate) as [Year],
 count(Id) as [Freq]
 from Posts
 where PostTypeId=1
 Group By Year(CreationDate)
 Order By Year(CreationDate)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results