0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

created oct 27 17 anonymous