Top Users by Country

0

Please login or register to vote for this query.

(click on this box to dismiss)

Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Top Users by Country
-- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)

/*SELECT
  TagName as [Tag],
  count as [Frequency]
  from Tags
  Order by Frequency DESC
  
 Select 
 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'
 */
 select
 year(CreationDate) as [Year],
 count(Id) as [Freq]
 from Posts
 where PostTypeId=1
 Group By Year(CreationDate)
 Order By Year(CreationDate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results