For each author in the bibliography, list the author's name and the titles of
all books by that author, grouped inside a result
element.
<results>
{
for $a in distinct-values(document("bib.xml")//author)
return
<result>
{ $a }
{ for $b in document("bib.xml")/bib/book[author=$a]
return $b/title
}
</result>
}
</results>
Adapted from XML Query Use Cases