select Score, iif(PostTypeId=1, 'question', 'answer') Pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select Score, iif(PostTypeId=1, 'question', 'answer') PostType, count(*) "Number of posts to score X in the past 2 years"
from
(
  select Score, PostTypeId
  from Posts
  where CreationDate > getdate()-730
) x
group by Score, PostTypeId
order by Score

Enter Parameters

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