TOP 100 "MOST-ANSWERED QUESTIONS" OF ALL TIME

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select top 100
  parentid as [Post Link],
  (select x.score from posts x where x.id=p.parentid) as qScore,
  (select x.viewcount from posts x where x.id=p.parentid) as Views,
  count(id) as Answers,
  avg(score) as [Avg aScore],
  format(min(creationdate),'yyyy-MM-dd') as [First Answer],
  format(max(creationdate),'yyyy-MM-dd') as [Latest Answer]
from posts p
where posttypeid=2  --AND CommunityOwnedDate IS NULL
group by parentid
order by count(id) desc

Enter Parameters

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