Posts per / year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

select
  Year(CreationDate) as [Year],
  Count(*) as [# of Posts]
from
  PostsWithDeleted
where
  PostTypeId = (
    case Lower(##PostType:string##)
      when 'questions'    then 1
      when 'answers'      then 2
   -- when 'orphan wikis' then 3
      when 'tag wikis'    then 4
      when 'tag excerpts' then 5
      when 'nominations'  then 6
   -- when 'tour change'  then 7
   -- when 'privilege'    then 8
      else null
    end
  )
group by
  Year(CreationDate)
order by
  Year(CreationDate)
  asc

Enter Parameters

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