Response Time Median To Question With Tag Bixby

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Enter Query Title
-- Enter Query Description


with diffs as
(select cast(a.creationdate - q.creationdate as float) as d from posts q
join posts a on a.id = q.acceptedanswerid)



SELECT 
(
 (SELECT MAX(d) FROM
   (SELECT TOP 50 PERCENT d FROM diffs ORDER BY d) AS BottomHalf)
 +
 (SELECT MIN(d) FROM
   (SELECT TOP 50 PERCENT d FROM diffs ORDER BY d DESC) AS TopHalf)
) / 2 AS Median

from Posts
where PostTypeId = 1 AND Tags like '%<abap>%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results