title: Group by a field in my sql and concatinate another field values as one string
body: <p>My table is something like that.</p>
  
  <pre><code>Location | Building | Department | 
  
  L1        | B1       | D1      
  L2        | B2       | D2      
  L3        | B1       | D3
  </code></pre>
  
  <p>What I want to do is a query that counts locations and groups by buildings, but then display departments in that building as a string</p>
  
  <pre><code>Building | Count L | Departments | 
  
  B1        | 2       | D1,D3     
  B2        | 1       | D2      
  </code></pre>