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],
  CreationDate - GetDate() as [Diff Date]
from Posts
where
  PostTypeId = 2
  and year(CreationDate) = 2010
order by year, month

view current version

edited jan 27 12

created jan 27 12 jon.doe7137