title: How to count entry by refrenceName?
body: <p>How to count entry by refrenceName?
  my sql query is </p>
  
  <pre><code>SELECT GROUP_CONCAT(refrenceName)
  FROM attendance
  where event='4'
  GROUP BY refrenceName
  HAVING ( COUNT(refrenceName) &gt; 0 )
  </code></pre>
  
  <p>and showing result below</p>
  
  <p><a href="https://i.stack.imgur.com/qXwm3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qXwm3.png" alt="enter image description here"></a></p>
  
  <p>but how to count? I want Ashish(6), Babli(1)Rebecca(5) pls help me</p>