How long waiting for an answer, by language


Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

select top 25 TagName, 
       avg(cast(ResponseTime as bigint)) as Average,
       stdev(cast(ResponseTime as bigint)) as StandardDev
         Answers.CreationDate as ResponseDate,
         datediff(minute, Questions.CreationDate, 
                          Answers.CreationDate) as ResponseTime,
         cast(DATEPART(hour, Questions.CreationDate) as int) as ResponseHour
    FROM Posts Questions
    join Posts Answers on = Questions.AcceptedAnswerId
                         and datediff(hour, Questions.CreationDate, Answers.CreationDate) < 5
    join PostTags ON PostTags.PostId = Questions.Id
    join Tags on Tags.Id = PostTags.TagId
    WHERE Questions.CreationDate > convert(datetime, '01/01/2012', 101)  
          and TagName in ('python', 'perl', 'ruby', 'c++', 'c', 'clojure', 
                          'scala', 'javascript', 'haskell',
                          'c#', 'java', 'lua', 'php')
) as Responses
group by TagName
order by 2 asc

Enter Parameters

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