title: How to get total count of each group concat fields?
body: <p>I have one table called <code>'activity_data'</code> </p>
  
  <p>table contain following fields</p>
  
  <pre><code>id int(11),
  sports_name varchar(20),
  activity_date datetime
  </code></pre>
  
  <p>information of <code>activity_data</code> table</p>
  
  <pre><code>id         sports_name      activity_date
  1          Cricket          2015-05-12
  2          Football         2015-05-12 
  3          Cricket          2015-06-10    
  4          Basketball       2015-06-08  
  5          Khokho           2015-06-02 
  6          Kubbdi           2015-06-04
  7          Cricket          2015-05-12
  8          Kubbdi           2015-05-12  
  9          Cricket          2015-06-09   
  10         Football         2015-06-03
  </code></pre>
  
  <p>now I'm execute following queries</p>
  
  <pre><code>SELECT GROUP_CONCAT(id) id ,GROUP_CONCAT(DISTINCT(sports_name)) sports_name,activity_date FROM filter_activity_data WHERE activity_date BETWEEN '2015-05-12' AND '2015-06-04' GROUP BY activity_date ORDER BY activity_date ASC
  </code></pre>
  
  <p>while executing this:output is getting like this</p>
  
  <pre><code>id         sports_name                activity_date
  1,2,7,8    Cricket,Football,Kubbdi    2015-05-12
  5          Khokho                     2015-06-02 
  10         Football                   2015-06-03    
  6          Kubbdi                     2015-06-04  
  </code></pre>
  
  <p>I want to get output total count of each <code>GROUP_CONCAT sports_name</code>. expected out put like this:</p>
  
  <pre><code>id         sports_name                activity_date
  2,1,1      Cricket,Football,Kubbdi    2015-05-12
  1          Khokho                     2015-06-02 
  1          Football                   2015-06-03    
  1          Kubbdi                     2015-06-04  
  </code></pre>
  
  <p>How to achieve this goal ?</p>