title: How to take multiple rows and make a comma separated list in SQL
body: <p>I have a query I ran which is </p>
  
  <p><code>SELECT * FROM rpg.class_primary_abilities AS cpab
  INNER JOIN rpg.abilities AS ab ON cpab.ability_id = ab.ability_id
  INNER JOIN rpg.classes AS cl ON cpab.class_id = cl.class_id;</code> </p>
  
  <p>It gives me the below output.</p>
  
  <p><a href="https://i.stack.imgur.com/59kGE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/59kGE.png" alt="enter image description here"></a></p>
  
  <p>What I would like to know is how can I change this query in order to display everything except the first <code>class_id</code> column in a comma separated list.  Essentially I would like to get an output of <code>class_id</code>and <code>value,value,value,value,value,value,value,value</code> as my two columns in the output.</p>
  
  <p>I am a college student just learning SQL and have not been exposed to any possible solutions to this problem in class.  Any help is appreciated.</p>