select postId, p1.questionTime, p1.ansTime, (CASE WHEN Vo...

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 postId, p1.questionTime, p1.ansTime,
  (CASE
    WHEN VoteTypeId = 2 THEN 10 
    WHEN VoteTypeId = 3 THEN  -2
    ELSE 0
    END) as ReputationWon
  from votes 
  
join
  (select p.Id , questionTime, p.CreationDate as ansTime
  from posts as p
  join
    (select Id , CreationDate as questionTime from posts
    where CreationDate BETWEEN '2015-08-01' AND '2015-08-31'
    and AnswerCount=2
    and PostTypeId = 1) --question
  as d on d.Id = p.ParentID
  where p.CreationDate BETWEEN '2015-08-01' AND '2015-08-31') 
as p1 on p1.Id = votes.PostId --p1 has requd posts 
  
where VoteTypeId between 2 and 3
order by postId

Enter Parameters

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