Q&A about the site for professional robotic engineers, hobbyists, researchers and students
--SELECT top 10 * FROM comments-- where userdisplayName = 'Guffa'
--select top 10 * from posts where ParentId = 20407276 and posttypeid = 2
--select * from users where id = 534124
--select * from posttypes
SELECT datepart(year,creationdate), count(*) FROM posts
where posttypeid = 2
group by datepart(year,creationdate)