0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

/*
SELECT * FROM Tags AS t WHERE t.TagName = N'sql-server-2008';
TagId == 30408
*/

/*
SELECT * FROM TagSynonyms AS t WHERE N'sql-server-2008' IN ( t.SourceTagName, t.TargetTagName );
Id: 
768 'sql2008'
2020 'mssql2008'
5155 'ssms-2008'
*/

SELECT
  YEAR( CreationDate ) AS PostedYear,
  COUNT(*) AS CountPosts,
  COUNT( ClosedDate ) AS CountClosed
FROM
  Posts
GROUP BY
  YEAR( CreationDate )
ORDER BY
  PostedYear;

view current version

edited aug 11

created aug 11 Dai