select PostId [Post Link], count(*) Bumps, max(CreationDa...

0

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 PostId [Post Link], count(*) Bumps, max(CreationDate) LastBumped
from PostHistory
where CreationDate > getdate()-365
and PostHistoryTypeId=50 -- bump
group by PostId
order by count(*) desc

Enter Parameters

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