Q&A for music historians, critics, and fans
select top 30 Users.DisplayName, BestComment.Id, Max(BestComment.Score), WorstComment.Id, Max(WorstComment.Score) from Users join (select top 50000 Comments.Id, Comments.Score, Comments.UserId from Comments order by Comments.Score desc) BestComment on BestComment.UserId = Users.Id join (select top 50000 Comments.Id, Comments.Score, Comments.UserId from Comments order by Comments.Score) WorstComment on WorstComment.UserId = Users.Id where BestComment.Score>0 and WorstComment.Score<=0 group by Users.DisplayName, BestComment.Id, WorstComment.Id