Q&A for Ubuntu users and developers
select Top 1000 Count(Comments.Id) FROM Posts Join Comments ON Comments.PostId = Posts.Id Group By Posts.Id