0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

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 BestComment.UserId = Users.Id
  join (select Comments.Id, Comments.Score, Comments.UserId
        from Comments) WorstComment
    on WorstComment.UserId = Users.Id
  where BestComment.Score>0
    and WorstComment.Score<=0

fork query

created sep 22 19 anonymous