Distribution of HNQs based on minutes until entering


Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

;with times_cte AS (
p.Id AS pid,
p.CreationDate AS cre,
ph.CreationDate AS hot,
DATEDIFF(minute, p.CreationDate, ph.CreationDate) AS minutes
FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id
WHERE ph.PostHistoryTypeId=52
---52 = Question became hot network question

  COUNT(pid) AS Count
FROM times_cte
GROUP BY minutes
ORDER BY minutes

Enter Parameters

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