Posts per Year

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

SELECT 
  YEAR(CreationDate) AS Year, 
  FORMAT(COUNT(*),'0,,.00 M') AS Posts
FROM Posts
GROUP BY YEAR(CreationDate)
ORDER BY Year

edited oct 1 20

created oct 1 20

Polygnome

Options: Text-only results Include execution plan

Switch to meta site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached