За сколько дней в среднем на вопрос даётся правильный ответ?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Hinduism Meta

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

select top 100 format(convert(date, p.creationdate), 'yyyy-MM-dd') as 'дата создания поста',
format(convert(date, pa.creationdate), 'yyyy-MM-dd') as 'дата создания ответа',
avg(datediff(d, p.creationdate, pa.creationdate)) as 'среднее время ответа'
from posts p
join posts pa on p.acceptedanswerid = pa.id
group by p.id, convert(date, p.creationdate), convert(date, pa.creationdate)
order by convert(date, p.creationdate) desc

Enter Parameters

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