Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
select q.Id as [Post Link], max(aa.score) as 'aa score', max(hsl.score) as 'later answer hs', max(hsl.score) - max(aa.score) as aa_hsl_diff from Posts as q left join Posts as aa on q.Id = aa.ParentId --- aa: accepted answer left join Posts as hsl on q.Id = hsl.ParentId --- hsl: highest scoring later answer where q.PostTypeId = 1 and q.AcceptedAnswerId is not null and q.AnswerCount > 1 and aa.Score < hsl.Score and --- aa has lower score, ordering will change aa.Id = q.AcceptedAnswerId and aa.CreationDate < hsl.CreationDate ---and not q.tags like '%single-word-requests%' ---- remove first 3 dashes to exclude SWR group by q.Id order by aa_hsl_diff DESC;