0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT top 50
  question.id as [Post Link],
  --tagName.tagName as 'tag name',
  count(*) as 'number of accepted answers',
  cast(avg(datediff(hour, question.CreationDate, answer.CreationDate)) as char(8)) + 'h ' +
  cast(avg(datediff(minute, question.CreationDate, answer.CreationDate))%60 as char(8)) + 'm ' +
  cast(avg(datediff(second, question.CreationDate, answer.CreationDate))%60 as char(8)) + 's' as time
FROM 
    posts as question
  inner join
    posts as answer
    on
      question.acceptedAnswerID = answer.id
  inner join 
    postTags as tag
    on 
      question.id = tag.postID
  inner join 
    tags as tagname
    on
      tag.tagID = tagname.id
GROUP BY 
--  tag.tagID
  tagname.tagName,
  question.id
HAVING 
  count(*) >= 10
  and tagname.tagname like '##tagname##'
ORDER BY 
  avg(datediff(second, question.CreationDate, answer.CreationDate)) ASC

fork query

edited sep 8 12 Pureferret

created sep 8 12 KevinN