title: SQL - How To Order Using Count From Another Table
body: <p><strong>1. Bloggers</strong></p>
  
  <pre><code>blogger_id
  1 
  2
  3
  </code></pre>
  
  <p><strong>2. Posts</strong></p>
  
  <pre><code>post_from_blogger_id
  1 
  1
  1
  2
  2
  3
  </code></pre>
  
  <p>As you can see blogger №1 posted more than the others and blogger №3 less. The question <strong>is
  how to build a query that selects all bloggers and sorts them by the number of their posts?</strong></p>