select posts1.Id, count(*) from Posts posts1 join ( selec...

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

select posts1.Id, count(*) from Posts posts1
join 
(
select Id, CreationDate, OwnerUserId from Posts posts1
) a on a.Id = posts1.Id
where a.CreationDate < posts1.CreationDate and posts1.OwnerUserId = 4783614
group by posts1.Id

Enter Parameters

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