Percent Questions with Accepted Answer Over Time

1

Please login or register to vote for this query.

(click on this box to dismiss)

Total questions with an accepted answer on [site] from each month over time (grouped by year-month).

Ask Different

Q&A for power users of Apple hardware and software

-- Adapted from https://data.stackexchange.com/stackoverflow/query/1424996 @Larnu

DECLARE @SEDEUpdated AS DATETIME = (SELECT TOP 1 LastAccessDate FROM Users ORDER BY LastAccessDate DESC)

SELECT DATEFROMPARTS(YEAR(P.CreationDate), MONTH(P.CreationDate), 1) AS [Question Year Month],
       COUNT(P.AcceptedAnswerId) / (COUNT(*) * 1.) AS [Acceptance Rate For Qs In <Month>]
FROM Posts P
WHERE P.CreationDate >= '20090101' -- Exclude first few months on SO since it skews the scale
  AND P.CreationDate < DATEFROMPARTS(YEAR(@SEDEUpdated), MONTH(@SEDEUpdated), 1) -- Only include months prior to latest SEDE update (incomplete data)
GROUP BY DATEFROMPARTS(YEAR(P.CreationDate), MONTH(P.CreationDate), 1)
ORDER BY DATEFROMPARTS(YEAR(P.CreationDate), MONTH(P.CreationDate), 1) DESC

Enter Parameters

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