0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

SELECT TOP 100 q.Id, u.Reputation, a.Reputation
FROM Posts as q
JOIN Users as u ON q.OwnerUserId = u.AccountId
JOIN (
    SELECT p.ParentId, u2.Reputation
    FROM Posts as p
    JOIN Users as u2 ON p.OwnerUserId = u2.AccountId
    WHERE p.PostTypeId = 2 AND p.CreationDate Between '2015-07-31' AND '2017-12-31'
) as a ON a.ParentId = q.Id
WHERE q.PostTypeId = 1 AND q.AnswerCount > 2 AND q.CreationDate Between '2015-07-31' AND '2017-12-31';

fork query

edited oct 17 18

created oct 15 18 anonymous