title: How to get number of occurance and the field value from a table
body: <p>Table </p>
  
  <pre><code>ID Name 
  1  abc
  2  cde
  3  xyz
  4  abc
  5  cde
  6  cde
  </code></pre>
  
  <p>My expected result is </p>
  
  <pre><code>abc 2
  cde 3
  </code></pre>
  
  <p>how will be the query ?</p>