new answers per month since 2018

0

Please login or register to vote for this query.

(click on this box to dismiss)

TeX Meta

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

-- Ignore the datapoints for the current month. That data is not yet complete. Ex. Things like roomba have "lag"

SELECT
  DATEFROMPARTS(YEAR(P.DeletionDate), MONTH(P.DeletionDate), 1) AS Date,
  'average new deleted answers' AS Type,
  CAST(SUM(CASE WHEN P.PostTypeId = 2 THEN 1 ELSE 0 END) AS REAL)
FROM PostsWithDeleted P
WHERE P.PostTypeId IN (1,2)
AND YEAR(P.DeletionDate) >= 2022 and month(P.DeletionDate)>=10
GROUP BY DATEFROMPARTS(YEAR(P.DeletionDate), MONTH(P.DeletionDate), 1)
ORDER BY Date

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results