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