Can XQuery handle hierarchical data?

Is hierarchical aggregated total expressible in XQuery? Given

<emp name = ALLEN sal = 2000>
<emp name = SMITH sal = 1500>
</emp>
<emp name = MILLER sal = 1800>
<emp name = ADAMS sal = 1000>
</emp>
</emp>
</emp>

the result is supposed to be

<emp name = ALLEN budget = 4300>
<emp name = SMITH budget = 1500>
</emp>
<emp name = MILLER budget = 2800>
<emp name = ADAMS budget = 1000>
</emp>

    </emp>
</emp>
Received on Thu Jan 13 2005 - 20:27:20 CST