0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software

with correctResponseTime as (
    select question.id, datediff(hh, question.creationDate, answer.creationDate) as correctresponsetime
    from posts as question join posts as answer
      on question.acceptedAnswerId = answer.id
    where question.postTypeId = 1
)

select tagName, averageCorrectResponseTime
from tags join (select tagId, avg(correctResponseTime) as averageCorrectResponseTime
                from postTags join correctResponseTime
                  on postId = id
                group by tagId) as tagAverageCorrectResponseTime
  on id = tagId
order by tagName asc

fork query

edited oct 21 20

created oct 20 20 anonymous