select top 10 Users.DisplayName, BestComment.Id, BestComm...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select top 10 Users.DisplayName,
              BestComment.Id, BestComment.Score,
              WorstComment.Id, WorstComment.Score
from Users
  join (select Comments.Id, Comments.Score, Comments.UserId
        from Comments) BestComment
    on Users.Id = BestComment.UserId
  join  (select Comments.Id, Comments.Score, Comments.UserId
        from Comments) WorstComment
    on Users.Id = WorstComment.UserId
  where BestComment.Score>0 and WorstComment.Score<0

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results