Q&A for people interested in governments, policies, and political processes
select q.Id as [Post Link], max(aa.score) as 'aa score' from Posts as q left join Posts as aa on q.Id = aa.ParentId --- aa: accepted answer where q.PostTypeId = 1 and q.AcceptedAnswerId is not null and q.AnswerCount > 1 and aa.Id = q.AcceptedAnswerId and aa.Score = (Select max(score) from Posts csq where csq.ParentId = q.id) group by q.id order by max(aa.score) DESC;