KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a task to count the quantity of users having count of comments > X. My SQL-query looks like this: SELECT users.id, users.display_name, (SELECT COUNT(*) FROM cms_comments WHERE cms_comments.author_id = users.id) AS comments_count FROM users HAVING comments_count > 150; Everything is ok, it shows all users correctly. But i need query to return the quantity of all these users with one row. I don't know how to change this query to make it produce correct data.
Tags (comma-separated)
Save Edits
Cancel