Gets the posts with the most comments
Q&A for programmers
-- Posts with lots of comments
-- Gets the posts with the most comments
select top 100
posts.id as [Post Link], count(comments.id) as 'Number of Comments'
comments.postid = posts.id