Good morning.

I have an XML file of the following format:

<?xml version="1.0" encoding="UTF-8"?>

<resultsets>

<resultset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<row>

<column name="TITULO">A Adequação de Sistemas Baseados em Casos no Sequenciamento Inteligente de Ações</column>

<column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column>

</row>

<row>

<column name="TITULO">Sistemas Distribuídos Inteligentes</column>

<column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column>

</row>

<row>

<column name="TITULO">Uma Arquitetura para Planejamento Inteligente</column>

<column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column>

</row>

<row>

<column name="TITULO">Navegação de robôs móveis com Lógica Paracpmsistente Anotada e método de Campos Potenciais</column>

<column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column>

</row>

<row>

<column name="TITULO">Adaptation in a Traffic Control System</column>

<column name="NOMECOMPLETO">José Pacheco de Almeida Prado</column>

</row>

...

The file contains titles for articles and their authors..

I was asked to develop a query that returns the author's name followed by the titles of all of its articles, so the result would be something like this:

<Author1>:<Article1>, <Article2>, <Article3>...

<Author2>:<Article1>, <Article2>...

...

Any ideas on how can I do it?

Thank you in advance.