Sur

0

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
         Questions.CreationDate, 
         Questions.Title, 
         Tags.TagName,
         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 Answers.id = 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')

Enter Parameters

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