title: SQL Count Rows From Multiple tables
body: <p>Lets say i have 2 tables</p>
  
  <p>Companies</p>
  
  <pre><code>company_id    
  name
  </code></pre>
  
  <p>Users</p>
  
  <pre><code>id
  company_id
  name
  </code></pre>
  
  <p>each company has multiple users assign to it... which is referenced in the company_id field from each record in the users table</p>
  
  <p>HOW can i get a record showing the <code>(company_id), (company_name) and (number or users)</code></p>
  
  <p>for eg:</p>
  
  <pre><code>id# 1234 | name# Microsoft | n of users# 2000 
  </code></pre>
  
  <p>I dont know how to make this query, i know i have to use the function <code>COUNT()</code> but i dont know how</p>