title: how to get max repeated count with sql
body: <p>Hi have a table name is cou</p>
  
  <pre><code>name      type
  
  kasu      1
  kasu      4
  kasu      3
  nimal     1
  nimal     2
  </code></pre>
  
  <p>I need this answer as</p>
  
  <pre><code>name  cnt
  
  kasu  3
  </code></pre>