title: How to group by comma delimited column in mssql?
body: <p>I have tables with</p>
  
  <p>T1(user)</p>
  
  <pre><code>Id  Name CourseIds
  
  1   Joel  1,2,3 
  2   Jeff  2,3,4
  </code></pre>
  
  <p>T2(courses)</p>
  
  <pre><code>CourseId CourseName
  
  1         C# 
  2         Javascript
  3         SQL
  4         VB
  </code></pre>
  
  <p>I have to join the two tables and find out the count of each courses - learned by a user (group by) like
  (result table)</p>
  
  <pre><code>Courses      Count
  
  C#           1  
  Javascript   2
  SQL          2
  VB           1 
  </code></pre>
  
  <p>I have tried stackoverflow answers related to the question but they din't help. Please help me.</p>