select distinct Percentile_Cont(.5) within group (order b...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct Percentile_Cont(.5) 
within group (order by datediff(minute, s.CreationDate, coalesce(ApprovalDate, RejectionDate))*1.0) over () MedianMinutesToCompletion

from SuggestedEdits s
join PostTags pt on pt.PostId=s.PostId
join Tags t on t.Id=pt.TagId
where t.TagName='opencart'
and s.CreationDate > getdate()-90 -- edits suggested in the past 90 days

Enter Parameters

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