Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence
select top 10 Users.DisplayName, BestComment.Id, BestComment.Score, WorstComment.Id, WorstComment.Score from Users join (select top 1 Comments.Id, Comments.Score, Comments.UserId from Comments order by Comments.Score) BestComment on Users.Id = BestComment.UserId join (select top 1 Comments.Id, Comments.Score, Comments.UserId from Comments order by Comments.Score desc) WorstComment on Users.Id = WorstComment.UserId where BestComment.Score>0 and WorstComment.Score<0