Q&A for science fiction and fantasy enthusiasts
select COUNT(*) from Comments as comment_count where PostId = 123; select UserId , count(*) as most_count from Comments group by UserId Order by most_count;