Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select COUNT(*) from Comments as comment_count where PostId = 123; select UserId , count(*) as comment_count from Comments group by UserId ;