title: How to use GROUP_CONCAT in a CONCAT in MySql AND SUM VALUES
body: <p>I have a table with the following data in MySQL.</p>
  
  <pre><code>Id Name Total 
  1   A    25
  2   B    10
  1   C    5
  1   D    10
  2   F    7
  </code></pre>
  
  <p>how do I get it into the following format?</p>
  
  <pre><code>id   column   total
  1     A,C,D     40
  2     B,F       17 
  </code></pre>