SPARQL concat plus group_concat on multiple fields
<p>I have the following RDF structure that I cannot change:
<a href="https://i.stack.imgur.com/XXhyF.png" rel="noreferrer"><img src="https://i.stack.imgur.com/XXhyF.png" alt="enter image description here"></a></p>

<p>Multiple Assignments can be associated to each employee (Manager). The output I'd like would be (including the word "in" and "&amp;):</p>

<pre><code>Employee Name   | Assignment

Name 1          | Assignment1 in Location1 &amp; Assignment2 in Location2 &amp;....
Name 2          | Assignment1 in Location2 &amp; Assignment3 in Location1 &amp;....
</code></pre>

<p>Is there a way to do this in <code>Sparql</code>?</p>

<p>This is what I have so far:</p>

<pre><code>select ?name group_concat(DISTINCT ?description; separator("&amp;"))
where
{
  ?employee :hasName ?name
  {
  select concat(?name, "In", ?location)
  ?employee ^:hasManager/:hasAsstName ?name
  ?employee ^:hasManager/:hasLocation ?location
  }

}
</code></pre>

<p>This gives me empty employee name and lots of ?Descriptions. It does not seem to reflect what I was expecting.</p>