MLB Skills Assessment

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

-- *BONUS* For the questions created in 2017, what was the average time (in seconds) between when the question was created and when the accepted answer was provided?
;with questions_answered as (
select 
  ID, 
  CreationDate, 
  AcceptedAnswerid
from 
  posts
where
  year(creationdate) = 2017 
  and Acceptedanswerid is not null
)

Select 
  qa.ID as 'QuestionID', 
  qa.CreationDate as 'Question_date', 
  qa.AcceptedAnswerid, 
  p.ID as 'AnswerID', 
  p.Creationdate as 'Answer_date', 
  datediff(second, qa.CreationDate, p.Creationdate) as 'Response_time'
into 
  #responsetime
from 
  posts p
inner join 
  questions_answered qa on qa.AcceptedAnswerid = p.id

Select
  Count(*) as 'Number of Questions Answered',
  avg(cast(Response_time as bigint)) as 'AVG Response Time (Seconds)'
from 
  #responsetime

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results