Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 50000 p1.id as p1_Id,
min(p2.CreationDate) as p2_CreationDate_min,
avg(u2.Reputation) as u2_Reputation_avg, avg(u2.UpVotes) as u2_UpVotes_avg,avg(u2.DownVotes) as u2_DownVotes_avg
from ((posts as p1 left join posts as p2 on p1.id=p2.parentid) left join
users as u1 on p1.OwnerUserId = u1.id) left join users as u2 on
p2.OwnerUserId = u2.id
where p1.PostTypeID = 1 and p1.CreationDate > '2018-02-06' and
p1.CreationDate < '2018-05-06'
group by p1.id
order by min(p1.CreationDate) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results