title: SQL Query that counts the members of each group
body: <p>i have a table with details given as :</p>
  
  <pre><code>Assignment_name  organization   location  position    owner
  
  1                 xyz            delhi     staff        ABC 
  2                 GDH            Lucknow   Sr. Mgr      ABC
  3                 GDRT           Kerala    Staff        AEZ
  4                 xyz            delhi     staff        AEZ
  5                 GDH            Lucknow   Sr. Mgr      BZD
  6                 GDRT           Kerala    Staff        BZD
  </code></pre>
  
  <p>Now i want the count of records such that i get the count of the records against each owner.</p>
  
  <p>For example ,2 records against ABC owner , 2 records against AEZ and 2 against BZD.</p>
  
  <p>output like </p>
  
  <pre><code>Count  Owner
  2      ABC
  2      AEZ
  2      BZD
  </code></pre>
  
  <p>The following query is not working:</p>
  
  <pre><code>select count(distinct owner), owner
  from table abc
  group by owner;
  </code></pre>
  
  <p>This query is returning only 1 record for each</p>