0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

;with TopAnswers as 
(
  select parentid 
       , len(body) size
       , row_number() over (partition by parentid order by score desc) rownum
  from posts
  where posttypeid = 2 -- A
  and score > 5
)

select top 10 
       q.id [Post Link] 
       , len(q.body) + sum(a.size) total_size
from posts q
inner join TopAnswers a on a.parentid = q.id
where q.score > 100
and q.answercount > 2
and a.rownum < 21
group by q.id, q.body
order by len(q.body) + sum(a.size) desc

fork query

edited oct 22

created oct 22 rene