0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

DECLARE @tagname varchar(20) = ##language:string##

SELECT
         Questions.CreationDate, 
         Questions.Title, 
         Tags.TagName,
         Answers.CreationDate as ResponseDate,
         DateDiff(minute, Questions.CreationDate, Answers.CreationDate) as ResponseTime
FROM Posts Questions
    join Posts Answers on Answers.id = Questions.AcceptedAnswerId
    join PostTags ON PostTags.PostId = Questions.Id
    join Tags on Tags.Id = PostTags.TagId
    WHERE Questions.CreationDate > convert(datetime, '01/01/2011', 101)  
                 and TagName = @tagname

fork query

edited oct 31 12

created oct 31 12 anonymous