Q&A for pro webmasters
select count(distinct(p.id)) , year(p.CreationDate) from Posts p where year(p.CreationDate)=2017 group by year(p.CreationDate)