Q&A about the site for software quality control experts, automation engineers, and software testers
-- Most Down-Voted Questions -- The top 20 questions with the most down-votes (ignores up-votes) select top 20 up = sum(case when VoteTypeId = 2 then 1 else 0 end), down = sum(case when VoteTypeId = 3 then 1 else 0 end), v.postid AS [Post Link] from votes v inner join posts p on p.id=v.postid where PostTypeId = 1 and v.VoteTypeId=3 group by v.postid order by down desc