Q&A for professional and enthusiast programmers
select top 100 Posts.Id,count(Comments.Id) from Comments inner join Posts on Comments.PostId=Posts.Id group by Posts.Id