Closed questions that have answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Personal Finance and Money

Q&A for people who want to be financially literate

select AnswerCount, count(1)
from
(select PostID 
 from PostHistory
 where PostHistoryTypeID=10
 ) Hist
 inner join 
 (select ID, AnswerCount
  from Posts
  where PostTypeID=1
  and year(CreationDate)=2020
  ) Post
 on Hist.PostID=Post.ID
 group by  AnswerCount
 order by  AnswerCount

Enter Parameters

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