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
  OwnerUserId,
  DATEDIFF(month, CreationDate, GetDate()) as [MonthsSince]
from Posts
where
  PostTypeId = 2
  and DATEDIFF(month, CreationDate, GetDate()) < 4;

fork query

edited jan 27 12

created jan 27 12 jon.doe7137