0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

/*select top 50
  Id as [User Link],
  Reputation,
  AnswerCount
from
  Users
where
  Reputation < 3000
order by AnswerCount*/

select distinct
  year(CreationDate) as [Year],
  month(CreationDate) as [Month],
  OwnerUserId as [User Link],
  DATEDIFF(month, CreationDate, GetDate()) as [MonthsSince]
from Posts
where
  PostTypeId = 2
  and DATEDIFF(month, CreationDate, GetDate()) < 4
order by year, month

view current version

edited jan 27 12

created jan 27 12 jon.doe7137