title: SQL Group rows based on column value
body: <p>Example Address Table</p>
  
  <pre><code>ID, EmployeeID, Address
  
  1, 100, TownA
  2, 200, TownA
  3, 300, TownB
  </code></pre>
  
  <p>How can i return a count of all employess for each unique address?</p>
  
  <p>e.g</p>
  
  <pre><code>EmployeeCount, Address
  
  2 TownA
  1, TownB
  </code></pre>