Percentage of first posts which get closed (per day, between dates)


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

;with firstpostids_cte as (
SELECT MIN(Id) AS MinId, OwnerUserId, OwnerDisplayName
FROM PostsWithDeleted
WHERE PostTypeId=1
GROUP BY OwnerUserId, OwnerDisplayName
, firstpostsclosed_cte as (
p.Id, p.CreationDate AS cre, p.ClosedDate AS clo
FROM firstpostids_cte fp JOIN PostsWithDeleted p ON fp.MinId=p.Id

CAST(cre AS date), ROUND((COUNT(clo))*100.0/(COUNT(*)),2) AS percentage
FROM firstpostsclosed_cte
WHERE cre >= '##Date1##' AND cre <= '##Date2##'
GROUP BY CAST(cre AS date)
ORDER BY CAST(cre AS date)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results