SELECT p.Id as Question, d.Id as Answer, d.Reputation FRO...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

--SELECT * FROM Users where ID = 31736040;
--SELECT FROM Posts as p JOIN Users as u 
--ON p.OwnerUserId = u.AccountId where ParentId = 31736040 
SELECT p.Id as Question, d.Id as Answer, d.Reputation
FROM Posts as p INNER JOIN 
(SELECT c.Id, c.ParentId, u.Reputation
  FROM Posts as c 
  INNER JOIN Users as u
  ON c.OwnerUserId = u.AccountId
  WHERE c.PostTypeId = 2
  AND c.CreationDate BETWEEN '07-31-2015' AND '12-31-2015'
  ) as d 
ON p.Id = d.ParentId
WHERE p.AnswerCount = 2
AND p.PostTypeId = 1
AND p.CreationDate BETWEEN '07-31-2015' AND '12-31-2015'
ORDER BY Question DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results