select count (distinct p.Id) from Users u inner join Post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

select count (distinct p.Id)
from Users u inner join Posts p on u.Id = p.OwneruserId
inner join PostHistory ph on ph.PostId = p.Id
where u.CreationDate >= '2019-01-01' and u.CreationDate < '2020-01-01'
and ph.PostHistoryTypeId = 12
and p.CreationDate = (select min (Creationdate) from Posts p2 where p2.Id = p.Id)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results