I don't know enough about SQL to build one, but Bill the Lizard already did the grond work for us and presented the below sniper to get the number of questions per year.

SELECT count(Id), YEAR(CreationDate)
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY YEAR(CreationDate)

You can test it at https://data.stackexchange.com/blender/query/1774058/total-questions-per-year

I don't know enough about SQL to build one, but Bill the Lizard already did the ground work for us, so I adapted to get the number of questions per month per year.

SELECT count(Id), MONTH(CreationDate), YEAR(CreationDate)
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY YEAR(CreationDate), MONTH(CreationDate)
  ORDER BY YEAR(CreationDate), MONTH(CreationDate)

You can test it at https://data.stackexchange.com/blender/query/1774167/total-questions-per-month-year

Data Stack Exchange API will let you build SQL Queries to get whatever data you want about a stack exchange site.

I don't know enough about SQL to build one, but Bill the Lizard did the grond work for me and presented the below sniper

SELECT count(Id), YEAR(CreationDate)
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY YEAR(CreationDate)

You can test at https://data.stackexchange.com/blender/query/1774058/total-questions-per-year

After extracting the output CSV file into your favorite spreadsheet software we can compute a sum column.

Using your favorite office suite we can build a beautiful chart.

Data Stack Exchange API will let you build SQL Queries to get whatever stats you want about a stack exchange site.

I don't know enough about SQL to build one, but Bill the Lizard already did the grond work for us and presented the below sniper to get the number of questions per year.

SELECT count(Id), YEAR(CreationDate)
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY YEAR(CreationDate)

You can test it at https://data.stackexchange.com/blender/query/1774058/total-questions-per-year

After extracting the output CSV file into a spreadsheet editor we can compute a partial sum column.

Using your favorite office suite you can then build a beautiful line chart.