Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
select Posts.Id as [Post Link], count(comments.id) AS comment_count from comments inner join posts on comments.PostId = posts.id where len(Text) <= 50 and (Text like '%hank%') group by Posts.Id having count(comments.id) > 1 order by count(comments.id) desc;