title: MySql Select, Count(*) and SubQueries in Users<>Comments relations
body: <p>I have a task to count the quantity of users having count of comments > X. </p>
  
  <p>My SQL-query looks like this:</p>
  
  <pre><code>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 &gt; 150;
  </code></pre>
  
  <p>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. </p>