1

Please login or register to vote for this query.

(click on this box to dismiss)

Answers that (at the time) new users made within a week of registering, to questions that were at least six-months old at the time, that have accumulated more than a net of 25 votes.

Q&A for professional and enthusiast programmers

select  a.id as [Post Link],
        a.Score,
        q.CreationDate as [Question Date],
        u.CreationDate as [User Date],
        a.CreationDate as [Answer Date]
from Posts a
inner join Posts q
on  a.ParentId = q.Id
inner join Users u
on a.OwnerUserId = u.Id
where
    q.PostTypeId = 1
and a.PostTypeId = 2
and datediff(month, q.creationDate, a.creationDate) > 6
and datediff(day, u.creationDate, a.creationDate) < 7
and u.creationDate > q.CreationDate
and a.score >= 25
order by a.CreationDate Desc

fork query

edited aug 3 15 Deer Hunter

created oct 21 12 martin clayton