1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select top 100
p.CreationDate,
p.id as [Post Link],
case when p.PostTypeId = 1 then 'Question'
      when p.PostTypeId = 2 then 'Answer'
      else 'Other'
      end
as Type,
count(*)
from posts p
join posthistory h on h.postid = p.id
where PostHistoryTypeId = 5
group by h.postid, p.id, p.CreationDate, p.PostTypeID
order by count(*) desc

fork query

edited sep 25 12 mmyers

created sep 25 12 anonymous