0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

select a.Id,a.Total_answers from
(select p.Id,SUM(AnswerCount) as Total_answers,Rank() over(order by SUM(AnswerCount) desc)as rank1 from Posts p
join PostTypes pt
on p.PostTypeId=pt.Id
where pt.Name='Question'
group by p.Id) a
where a.rank1=1

fork query

edited nov 18

created nov 17 anonymous